4.4 COLSTAT

COLSTAT returns an indicator to the Extract and Replicat programs that a field is MISSING, NULL, or INVALID.

Syntax

@COLSTAT (MISSING | INVALID | NULL)

Example

The following example returns a NULL into target column DATE1.

DATE1 = @COLSTAT (NULL)