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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Importing data

Using proxy tables to import data Next Page

Handling 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 invalid values to NULL values.

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