Value handling variables
This section describes variables that are used for handling NULL and other values.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
The defined symbol will substitute all NULL values from ODBC, and connectors,
on the lowest level of data. This is a user-defined variable.
The defined symbol will
be interpreted as NULL when it occurs in a text file, Excel file or an inline statement. This is a user-defined variable.
If the NullAsValue statement is used, the defined symbol will substitute all NULL values in the NullAsValue specified fields with the specified string.
Defines a symbol to be treated as 'all other values' before a LOAD/SELECT
statement. This is a user-defined variable.