SEND TABLE—OLQ access mode

Commands and Syntax › SEND TABLE—OLQ access mode

SEND TABLE—OLQ access mode

SEND TABLE stores information from the current or named report file as an ASF table.

Access mode:The syntax below is invalid when the access switch is set to IDMS.

The columns that make up the new ASF table are derived from existing fields in the current report file.

Syntax:

►►─── SENd TABle ─┬─────┬─ asf-table-name ────────────────────────────────────►
                  └─ = ─┘

 ►─┬───────────────────────────────────────────────────────────────┬──────────►
   └─ REPort ─┬─────┬─ report-name ─┬────────────────────────────┬─┘
              └─ = ─┘               └─ USEr ─┬─────┬─ user-name ─┘
                                             └─ = ─┘

 ►─┬─────────────────────────────┬────────────────────────────────────────────►
   └─ OWNer ─┬─────┬─ user-name ─┘
             └─ = ─┘
 ►─┬─────────────────────────────────────┬────────────────────────────────────►
   └─ CATalog ─┬─────┬─ dictionary-name ─┘
               └─ = ─┘

 ►─┬──────────────────────────────────────┬───────────────────────────────────►
   └─ LOCation ─┬─────┬─ dictionary-node ─┘
                └─ = ─┘

 ►─┬─────────────────────────────────┬────────────────────────────────────────►
   └─ TYPe ─┬─────┬─┬─ CREate ─────┬─┘
            └─ = ─┘ ├─┬─ APPend ─┬─┤
                    │ └─ ADD ────┘ │
                    └─ REPlace ────┘
 ►─┬─────────────────────────────┬────────────────────────────────────────────►
   └─ ONLine ─┬─────┬─┬─ NO ◄ ─┬─┘
              └─ = ─┘ └─ YES ──┘

 ►─┬────────────────────────────┬─────────────────────────────────────────────►
   └─ AREa ─┬─────┬─ area-name ─┘
            └─ = ─┘

 ►─┬──────────────────────────────────────────┬───────────────────────────────►
   └─┬─ MODify ─┬─ access ─┬─────┬─┬─ NO ◄ ─┬─┘
     └─ ERase ──┘          └─ = ─┘ └─ YES ──┘
 ►─┬─────────────────────────────────────────┬────────────────────────────────►
   └─ STOrage sequence ─┬─────┬─┬─ NEXt ◄ ─┬─┘
                        └─ = ─┘ ├─ PRIor ──┤
                                ├─ LASt ───┤
                                └─ FIRst ──┘

 ►─┬────────────────────────────────────────────────────────────────────────┬─►
   │                 ┌────────────────────────────────────────────────────┐ │
   │                 │     ┌──────────────┐                               │ │
   └─ INDices ─┬───┬─▼─ ( ─▼─ field-name ─┴─ ) ┬─────────────────────────┬┴─┘
               └ = ┘                           │ ┌─────────────────────┐ │
                                               └─v┬─┬─ ASCending ◄ ─┬─┬┴─┘
                                                  │ └─ DEScending ──┘ │
                                                  ├─┬─ LASt ◄ ──────┬─┤
                                                  │ ├─ FIRst ───────┤ │
                                                  │ └─ NOT ALLowed ─┘ │
                                                  ├─ DISPlay ─────────┤
                                                  └─ STOrage ─────────┘
 ►─┬───────────┬──────────────────────────────────────────────────────────────►
   ├─ SUMmary ─┤
   └─ DETail ──┘

 ►─┬─────────────────────────────────────────────────────┬────────────────────►◄
   └─ COLumns ─┬─────┬─ ( ─┬─ MAXimum ─────────────┬─ ) ─┘
               └─ = ─┘     │ ┌───────────────────┐ │
                           └─▼─ field-reference ─┴─┘

Parameters:

asf-table-name

The name of the ASF table to be saved in CA IDMS or CA IDMS/DB.

REPORT= report-name

Identifies the saved report containing the columns that define the ASF table. Report-name names a report that was created with the SAVE REPORT command. If REPORT=report-name is not specified, the ASF table is defined by using columns from the current report.

USER= user-name

Identifies the user who saved the named report. If USER=user-name is not specified, the report is retrieved from the current user's directory.

OWNER= user-name

Specifies the user ID for the owner of the ASF table. If user-name is not specified, the ASF table is saved under the current user's ID.

CATALOG= dictionary-name

Specifies the name of the IDB or ASF dictionary where the catalog entry to the named ASF table is added.

LOCATION= dictionary-node

Specifies the name of the Distributed Database System (DDS) node controlling the named dictionary.

TYPE=

Specifies whether the named ASF table is being created, added to, or replaced. Type can be:

CREATE—The ASF table is new and is being assigned an initial definition.
APPEND/ADD—New data is added to an existing table definition.
REPLACE—The ASF table already exists and is replaced by new data.

Note: When either TYPE=APPEND/ADD or TYPE=REPLACE is specified, the columns in the current report must be the same as the columns in the existing table definition.

ONLINE= NO/YES

Specifies whether a map and dialog are built for the ASF table. The default is NO.

AREA= area-name

Names an alternative area to store the ASF table. Users must have DBA authority to specify this option.

MODIFY ACCESS= NO/YES

Specifies whether or not individual rows in the stored ASF table can be modified through ASF. The default is NO. A logical record MODIFY path is not built in the table subschema.

ERASE ACCESS= NO/YES

Specifies whether or not individual rows in the stored ASF table can be deleted through ASF. The default is NO.

STORAGE SEQUENCE=

Specifies how data is added to the database:

NEXT—Each new DATA record occurrence is connected immediately after the record occurrence that is current of set.
PRIOR—Each new DATA record occurrence is connected immediately before the record occurrence that is current of set.
LAST—Each new DATA record occurrence is connected immediately preceding the owner record.
FIRST—Each new DATA record occurrence is connected to the set in the position immediately following the owner record.

The STORAGE SEQUENCE cannot be specified if the STORAGE parameter is specified in the INDICES statement.

Notes:

For more information about set order, see the CA IDMS Performance Monitor System Administration Guide.
For more information about ASF, see the CA IDMS ASF User Guide.

INDICES=

Defines characteristics of the index set for the ASF table.

field-name—A single or concatenated key field. You can specify more than one field-reference value for a table.
ASCENDING/DESCENDING—The order in which record occurrences are connected to a set sorted by key value. The default is ASCENDING.
LAST—A new record with a duplicate sort key value is stored immediately after the existing duplicate record.
FIRST—A new record with a duplicate sort key value is stored immediately before the existing duplicate record.
NOT ALLOWED—Duplicate sort keys are not allowed.
DISPLAY—Specifies a display sequence of that defined as the display sequence for the table in ASF.
STORAGE—Specifies a display sequence of that defined as the storage sequence for the table in ASF.
Note: You can specify STORAGE and DISPLAY only once each for any table. You cannot specify STORAGE SEQUENCE= and STORAGE for the same table.

SUMMARY

Specifies that summary report lines only be included in the ASF table.

Note: In addition to specifying SUMMARY, you can create a table which contains summary information only by specifying DISPLAY SUMMARY or by selecting SUMMARY ONLY from the Sort screen in menu mode. Any subsequent SEND TABLE will contain only the summary information.

DETAIL

Specifies that all detail report lines be included in the ASF table.

COLUMNS=

Specifies the report file columns included in the ASF table. Columns can be:

MAXIMUM—All sequential columns are saved as columns in the ASF table.
field-reference—The columns and the number of characters in each column saved in the ASF table.

Considerations:

When an ASF table is created, the names of the field columns in the report file are assigned to the columns in the table definition.

If CA OLQ headers have been assigned to any report fields, these headers are retained as column names; both dynamic headers and CA OLQ headers retrieved from the data dictionary can be assigned to columns in an ASF table.

For multiple line headers, CA OLQ uses the field name for the internal name.

Examples:

Send Table

The SEND TABLE command can be used to instruct CA OLQ to replace all data previously associated with an ASF table with new data occurrences from the current report file. The following example replaces the EMP-HOSPITAL table with a single record:

send table=emp-hospital owner=bdm catalog=asfdict
  type=replace

 OLQ 102017   TABLE PROCESSING HAS BEEN SUCCESSFULLY COMPLETED

Send Table Indices

This example presents the use of INDICES to define the characteristics of the index set for the ASF table:

send table=emp-salary online=yes
 indices=(emp-id-0415) not allowed
 (emp-last-name-0415, emp-first-name-0415)

For more information:

Global Syntax