Customizing SQL accesses consists in either modifying a
standard access or creating a nonstandard access.
You can customize SQL accesses as follows:
- Add or replace clauses in a standard access type. To do so, you
can modify the standard access type or associate the standard access
type with a nonstandard access type.
- Create an SQL access by coding a nonstandard access type.
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 involves two steps:
- Describe customized accesses in the GG Lines of
Segments.
- Implement these accesses by indicating the SQL micropattern
in the COBOL source code of the entities (Program, Screen, or Server)
that call this Segment. You can also ignore them. You can choose to
implement them in a Program only, or to implement only some of them.
You are free to use them as you need.
You can customize an access type to select only the clients
who put in an order that amounts to more than $50.