Table processing commands

Command Summary › Table processing commands

Table processing commands

You can use data table processing commands to maintain information in either ASF or SQL tables.

ASF tables:

ASF tables refers to tables associated with the IDMSR schema.

In order to use ASF tables for the session, you must set the access switch to olq.

Note: For more information about ASF tables, see the CA IDMS ASF User Guide.

SQL tables:

SQL tables refers to tables associated with an SQL schema.

In order to use SQL tables for the session, you must set the access switch to idms.

Note: For more information about SQL tables, see the CA IDMS SQL Quick Reference Guide.

How to specify the access switch:

The access switch can be set in the following ways:

At system generation time
For an individual user in the Dictionary (IDD)
For the session, interactively (or until the switch is changed)

Note: For more information about setting the access switch, see SET.

Table processing commands:

The following table lists the CA OLQ table processing commands:

Use this command	To do this
DELETE TABLE	Delete SQL and ASF tables.
SELECT	Retrieve specific information from SQL and ASF tables, logical and database records, and sequential files (batch only).
SEND TABLE	Store information from the current or named report file in SQL and ASF tables.
SIGNON TABLE	Access a specific ASF table to increase efficiency. This command is only relevant in OLQ access mode.
HELP TABLES	List tables saved by the current or named user.

Invalid OLQ commands:

The following figure shows which OLQ commands become invalid When you set the access switch to IDMS access mode:

  ┌──────────────────────┐   ┌──────────────────────┐
  │   When you invoke:   │   │   When you invoke:   │
  │                      │   │                      │
  │    SET ACCESS OLQ    │   │   SET ACCESS IDMS    │
  │                      │   │                      │
  └─────────┬────────────┘   └──────────┬───────────┘
            │                           │
          valid                      invalid
            │                           │
┌───────────┘               ┌───────────┘
│                           │
├─► BYE                     ├─► BYE
├─► CLEAR CURRENCY          │   CLEAR CURRENCY
├─► CLEAR FUNCTION          ├─► CLEAR FUNCTION
├─► COMPUTE                 ├─► COMPUTE
├─► COMPUTE...GROUP BY      ├─► COMPUTE...GROUP BY
├─► DEFINE FILE             ├─► DEFINE FILE
├─► DEFINE PATH             │   DEFINE PATH
├─► DELETE COMPUTATION      ├─► DELETE COMPUTATION
├─► DELETE QFILE            ├─► DELETE QFILE
├─► DELETE REPORT           ├─► DELETE REPORT
├─► DELETE TABLE            ├─► DELETE TABLE
├─► DELETE USER             ├─► DELETE USER
├─► DISPLAY                 ├─► DISPLAY
├─► EDIT                    ├─► EDIT
├─► EDIT COMPUTATION        ├─► EDIT COMPUTATION
├─► EDIT GROUP              ├─► EDIT GROUP
├─► END PATH                │   END PATH
├─► EXECUTE PATH            │   EXECUTE PATH
├─► FIELDS FOR              │   FIELDS FOR
├─► FIND/GET...             │   FIND/GET...
├─► FUNCTION                ├─► FUNCTION
├─► HELP                    ├─► HELP
├─► MENU                    ├─► MENU
├─► OPTIONS                 ├─► OPTIONS
├─► PAGE HEADER/FOOTER      ├─► PAGE HEADER/FOOTER
├─► PRINT                   ├─► PRINT
├─► QFILE                   ├─► QFILE
├─► SAVE QFILE              ├─► SAVE QFILE
├─► SAVE REPORT             ├─► SAVE REPORT
├─► SELECT                  ├─► SELECT
├─► SEND TABLE              ├─► SEND TABLE
├─► SET                     ├─► SET
├─► SIGNON                  │   SIGNON
├─► SIGNON TABLE            │   SIGNON TABLE
├─► SORT                    ├─► SORT
├─► SUSPEND                 ├─► SUSPEND
├─► SWAP                    ├─► SWAP
├─► SWITCH                  ├─► SWITCH
└─► UNSORT                  └─► UNSORT

Note: For the syntax and syntax rules of CA IDMS SQL commands, see the CA IDMS SQL Quick Reference Guide.

For more information:

Commands and Syntax