SELECT—IDMS access mode

Commands and Syntax › SELECT—IDMS access mode

SELECT—IDMS access mode

Retrieves values from one or more SQL tables and views for display in CA OLQ.

Syntax:

►►─── idms-sql-select-statement ──────────────────────────────────────────────►◄

Note: For the syntax, authorization, parameters, usage notes, and examples for the SELECT (IDMS access mode) command, see the CA IDMS SQL Reference Guide.

Coding considerations:

The parsing rules are different for SELECT depending on how the access switch is set. For instance, you cannot follow SELECT (IDMS access mode) with a separator or comment character.

Also the use of abbreviations, literals, and operators differs:

In IDMS mode	In OLQ mode
:display.SELECT * from emp where emp-lname = 'Smith'	:display.SEL * from emp where emp-lname EQ Smith

In the above example for OLQ mode:

SELECT is abbreviated to SEL
The operator EQ is used
The character string Smith is not enclosed in quotes

You cannot do this with the SELECT command in IDMS mode.

Note: Consult CA IDMS SQL Reference Guide, for more information about rules for using SELECT (IDMS access mode).