External table options

There are numerous table format options that you can use to help control how the data is processed during a load that uses external tables.

External table option summary
When you create an external table definition, you can specify options that control processing for records or rows, for fields, and for the load operation itself. Use these options when loading from an external table or when using the external table directly in an SQL query.
External table load option details
Use the detailed information in this section to understand the options that you can use to load data by using external tables.
External table option processing
This section contains more information about how the system processes the external table options.
Restrictions on external table options for data unloading
Not all external table options are supported for unloads.

Parent topic: Data loading