Rational Programming Patterns for System z

Principle of customized SQL accesses

Customizing SQL accesses is modifying a standard access or creating a non-standard access.

You can:
Note: You must be familiar with the SQL syntax before customizing SQL accesses.

Implementing customized standard accesses is automatic or almost automatic whereas implementing non-standard accesses must be requested with specific code.

So you choose between customizing a standard access or a non-standard access according to how often this access will be used in Programs, Screens, or Servers.

Customizing SQL accesses consists in:
A customized access is, for example, to select only the clients who put in an order which amounts to more than $50.

Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)