Accessing SQL Defined Tables › SQL Parameter

SQL Parameter

Purpose

The SQL parameter contains the SELECT clause that is passed to the CA IDMS/DB database engine to perform REC card generation and data retrieval.

Note: For more information on the SELECT statement syntax, see the CA IDMS SQL Reference Guide.

Syntax

      Col
      2
      ▼
►►─── SQL sql-select-statement ───────────────────────────────────────────────►◄

Syntax Rules

SQL

Identifies the parameter. Must begin in column 2.

sql-select-statement

Any SQL SELECT statement, according to the syntax rules of the selected compliance.

Note: For more information on authorization requirements, expanded syntax, parameter descriptions, usage notes and examples, see the CA IDMS SQL Reference Guide.

Usage

Reminders

• SQL must begin in column 2
• The SQL parameter must immediately follow the INPUT parameter
• Continuation lines must have an asterisk in column 1
• No comments are allowed in the SQL statement

Use the column names from the SQL defined data table when coding Edit parameters (types 4, 5, and 6).

The SQL statement can be continued across any number of lines using the standard CA Culprit continuations character (*) in column 1. At the detection of the last continued line, the entire SQL SELECT statement is passed unchanged to the database engine to generate REC parameters.

Note that SQL comments can NOT be placed into the SELECT statement.

Example

 SQL SELECT "EMP-ID-0415"         AS  ID,
*           "EMP-LAST-NAME-0415"  AS "LNAME"
*    FROM   EMPLOYEE
*    WHERE  "EMP-ID-0415"  IN (1000,2000,3000)
*    ORDER  BY ID;