|
|
|
Retrieves one or all entries from a table.
This statement has the following format:
&CONTROL SHRVARS=($VM)
-EXEC $CACALL OPT=ACTION
ACTION=GET
CLASS=TENTRY
NAME=’APPL=application id
FIELD=fieldName
[VALUE=fullValue]’
[PARMS=’ACTIVE={YES | NO | ANY}’]
A required parameter giving the identifier of the application.
A required parameter giving the name of the table.
An optional parameter giving the full value of the entry to be retrieved. If omitted, all entries in the table are returned.
An optional parameter that indicates which entries are to be retrieved from the table if the VALUE parameter is omitted.
Only active table entries are to be retrieved. This is the default.
Only inactive table entries are to be retrieved.
All table entries are to be retrieved.
This statement has no input variables.
This statement contains the following return variables:
System message. Contains the error message (for return code 8).
If a full value is supplied, the following variables are returned:
The abbreviated value of the table entry.
The full value of the table entry.
The description of the table entry.
The text fields of the table entry.
If a full value is not supplied, the following variables are returned:
The total number of entries in the table.
The abbreviated value for each table entry.
The full value for each table entry.
The description of each table entry.
If a return code of 8 is set, then additional information is available as one of the following feedback codes, set in &$CAFDBK:
No data found
Processing error
Nesting level exceeded
The following statements retrieve the entry $NDSYS from the Report Writer table:
&CONTROL SHRVARS -EXEC $CACALL OPT=ACTION + ACTION=GET + CLASS=TENTRY + NAME=‘APPL=$RW + FIELD=APPL + VALUE=$NDSYS’
| Copyright © 2008 CA. All rights reserved. |
|