Using @COLTEST

Use the @COLTEST function to check for the following conditions:

• PRESENT tests whether a column is present and not null.

• NULL tests whether a column is present and null.

• MISSING tests whether a column is not present.

• INVALID tests whether a column is present but contains invalid data.

The following example checks whether the AMOUNT column is present and NULL and whether it is present but invalid.

@COLTEST (AMOUNT, NULL, INVALID)