CAS Programming Interface ($CACALL) › Action=GET Class=TENTRY

Action=GET Class=TENTRY

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}']

• APPL=application id

  A required parameter giving the identifier of the application.

• FIELD=fieldName

  A required parameter giving the name of the table.

• VALUE=fullValue

  An optional parameter giving the full value of the entry to be retrieved. If omitted, all entries in the table are returned.

• ACTIVE={YES | NO | ANY}

  An optional parameter that indicates which entries are to be retrieved from the table if the VALUE parameter is omitted.

  • YES

    Only active table entries are to be retrieved. This is the default.

  • NO

    Only inactive table entries are to be retrieved.

  • ANY

    All table entries are to be retrieved.