Introducing the OLQ SELECT statement › Some Tips On Using CA OLQ › Setting the access to IDMS

Setting the access to IDMS

When you want to access SQL-defined tables, your default access setting must be set to IDMS. You can do this for your CA OLQ session by specifying:

 set access idms


OLQ 092120 00  Processing mode changed to IDMS.

You are now able to use the SELECT statement to access SQL-defined tables.

Note: The examples of the SELECT statement in this manual are not necessarily valid for SQL-defined tables.

For more information about using the SELECT statement with SQL-defined tables, refer to the CA IDMS SQL Reference Guide.