Customizing SQL accesses is modifying a standard access
or creating a nonstandard access.
You can customize SQL accesses as follows:
- Add or replace clauses in a standard access. To do so, you can
modify the standard access or associate the standard access with a
nonstandard access.
- Create an SQL access by coding a nonstandard access.
- Implement extraction criteria which correspond to extraction methods.
Note: You must be familiar with the SQL syntax before customizing
SQL accesses.
Implementing customized standard accesses is automatic or almost
automatic whereas implementing nonstandard accesses must be requested
with specific code.
So you choose between customizing a standard access or a nonstandard
access according to how often this access will be used in Programs,
Screens, or Servers.
Customizing SQL accesses consists in:
- Describing customized accesses on the GG Lines of
the -G Lines tab of Segments.
- Implementing these accesses by indicating the SQL micropattern
in the COBOL source code of the entities (Program, Screen, or Server)
which call this Segment. You can also ignore them. You can choose
to implement them in a given Program only, or to implement only some
of them. You are free to use them as you need.
A customized access is, for example, to select only the clients
who put in an order which amounts to more than $50.