Checking Path Statuses

When accessing ASF tables you should always check for the following path statuses:

INVALID_DATA is returned when the data violates the definition-time selection criteria (for example, WHERE STATE EQ 'MA' and the program tries to replace the state with 'NY'). When INVALID_DATA is returned, the ERROR_STATUS field in the IDMS communications block is set to 0000.
DEFN_MISSING is returned when the record definition cannot be found. When DEFN_MISSING is returned, the ERROR_STATUS field in the IDMS communications block is set to 0000.
OOAK_MISSING is returned when a one-of-a-kind record cannot be found. When OOAK_MISSING is returned, the ERROR_STATUS field in the IDMS communications block is set to 0000.
SYNC_ERROR is returned when the time stamp in the catalog and the table definition do not match. When SYNC_ERROR is returned the ERROR-STATUS field in the IDMS communications block is set to 0000.

The return of any of these statuses indicates a fatal error; for more information, consult your DBA.