Accessing SQL Defined Tables › Retrieving Data with SQL

Retrieving Data with SQL

CA Culprit can retrieve data from CA IDMS/DB tables using Structured Query Language (SQL). A new SQL parameter has been added to CA Culprit syntax that allows the user to code a complete SQL select statement This select statement is used at two different times during CA Culprit processing:

• During the Precompile Phase the SQL commands Prepare and Describe are issued to provide CA Culprit with an SQL Descriptor area (SQLDA) that describes the format of the data that is retrieved. This information is used by CA Culprit to automatically generate REC parameters to describe the format of the CA Culprit input buffer.
• During the Extract Phase the SQL SELECT clause is prepared once again, and data is retrieved from CA IDMS/DB using the highly efficient bulk fetch technique. All cursor manipulation is completely automated by CA Culprit, so that data is returned, one row at a time, to the CA Culprit input buffer.