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)