5.31.4 CHECK

The CHECK command is used to check for the existence of a data object.

If an object is available a response status of OK is returned otherwise a response status of NOT_EXIST is returned.

Syntax:

Command

Keyword

Value

Developer notes for Command/Keyword/Value

CHECK

OBJECT

*DATASOURCE

Mandatory. Checks if a data source object exists.

*FIELD

Checks if a data source field exists.

*TABLE

Checks if a data source table exists.

NAME

value

Optional for *DATASOURCE.
Mandatory for *FIELD and *TABLE.
The NAME keyword is the name of the table, field or data source.
The field name is the data source field name not the program field name.

 

Example

 

CHECK OBJECT (*DATASOURCE)
CHECK OBJECT (*DATASOURCE) NAME (PEOPLE)
CHECK OBJECT (*TABLE) NAME (SKILLS)
CHECK OBJECT (*FIELD) NAME (EMPLOYEE_ID)