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.

NullDisplay

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.

NullInterpret

If the NullAsValue statement is used, the defined symbol will substitute all NULL values in the NullAsValue specified fields with the specified string.

NullValue

Defines a symbol to be treated as 'all other values' before a LOAD/SELECT statement. This is a user-defined variable.

OtherSymbol