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 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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here