SQL Implementation

This appendix contains examples illustrating differences between earlier versions of CA 2E SQL implementations and current implementations. Use these examples as guidelines to understanding how SQL is implemented in your generated application.

The following SQL features are covered. Each is discussed in detail in the sections that follow.

• Extended SQL Naming—Supports long table and column names.
• Separate View and Index Creation—Lets the designer specify whether to generate a view, an index, or both a view and index for an access path.
• Reduced Number of SQL SELECTs—Suppresses SELECTs prior to update, delete, or insert.
• Row Level Locking—Lets the designer specify what lock capability to use when updating rows.
• Restrictor and Positioner Functionality—Lets the designer determine whether to use NOT or OR logic to implement restrictor and positioner capability.
• Direct Table Access—Lets the designer specify whether to access data using a view or directly from the table.
• Cursor Name Length
• SQL SELECT in CRTOBJ