Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Importing and exporting data » Importing data


Handling conversion errors during import

When you load data from external sources, there may be errors in the data. For example, there may be invalid dates and numbers. Use the conversion_error database option to ignore conversion errors and convert invalid values to NULL values.

For more information about setting database options, see SET OPTION statement, and conversion_error option [compatibility].