Contents Index Table structures for import Outputting NULLs

ASA SQL User's Guide
  Importing and Exporting Data
    Importing and exporting data

Conversion errors during import


When you load data from external sources, there may be errors in the data. For example, there may be dates that are not valid dates and numbers that are not valid numbers. The CONVERSION_ERROR database option allows you to ignore conversion errors by converting them to NULL values.

For more information about setting Interactive SQL database options, see SET OPTION statement, or CONVERSION_ERROR option [compatibility].


Contents Index Table structures for import Outputting NULLs