CAS Programming Interface ($CACALL) › Action=LOAD Class=TABLE

Action=LOAD Class=TABLE

Loads the tables for an application (normally during system initialization). You must perform the LOAD TABLE function before you can the tables to validate data.

This statement has the following format:

&CONTROL NOSHRVARS
-EXEC $CACALL   OPT=ACTION
                ACTION=LOAD
                CLASS=TABLE
                NAME=‘APPL=application id
                       [FIELD=fieldName]’
                [PARMS=‘RELOAD={YES | NO}’]

APPL=application id

A required parameter giving the identifier of the application.

FIELD=fieldName

An optional parameter giving the name of the table if only one table is to be loaded. If omitted, all tables for the specified application are loaded.

RELOAD={YES | NO}

An optional parameter specifying whether the tables for the application are to be reloaded if previously loaded. The default is NO.

Input Variables

This statement has no input variables.

Return Variables

This statement contains the following return variables:

&SYSMSG

System message. Contains the error message (for return code 8).

Feedback Codes

If a return code of 8 is set, then additional information is available as one of the following feedback codes, set in &$CAFDBK:

8

Processing error

10

Nesting level exceeded

Example

The following statements load the tables for the application identified by ID ZPR. Any tables already loaded are reloaded.

&CONTROL NOSHRVARS
-EXEC $CACALL     OPT=ACTION +
                  ACTION=LOAD +
                  CLASS=TABLE +
                  NAME=‘APPL=ZPR’ +
                  PARMS=‘RELOAD=YES’