COLSTAT returns an indicator to the Extract and Replicat programs that a field is MISSING, NULL, or INVALID.
COLSTAT
MISSING
NULL
INVALID
Syntax
@COLSTAT (MISSING | INVALID | NULL)
Example
The following example returns a NULL into target column DATE1.
DATE1
DATE1 = @COLSTAT (NULL)
Scripting on this page enhances content navigation, but does not change the content in any way.