Unload Table - External Table Options
Use this page to define an external table to unload data to.
File Options
Specify the file options.
Attention: A semicolon (;) cannot
be the field or record delimiter when an external table is created
in the Schema Manager. To create an external table with a semicolon
as the delimiter, use the CREATE EXTERNAL TABLE statement at the command
line.
- Field delimiter
- For delimited external tables, type the character that separates the fields in the external table. The default is the pipe (|) character.
- Record delimiter
- For delimited external tables, type the character that separates the records in the external table. The default is the newline (\n) character.
- Recognize the escape character
- For delimited external tables, select this option to recognize the escape character that marks ASCII special characters in ASCII-text-based files. The backslash (\) is the default escape character, indicating that the next character is a literal character in the data, rather than a special character.
- Date format
- Specify the format of date columns in the external table. The date format is the value for the DBDATE option in the CREATE EXTERNAL TABLE statement.
- Money format
- Specify the format of money columns in the external table. The money format is the value for the DBMONEY option in the CREATE EXTERNAL TABLE statement.
Load Options
Specify the options for the unload task.
- Number of rows
- Specify the approximate number of rows in the external table. Specifying the number of rows can improve performance when the external table is used in a join query.
- Maximum errors
- Specify the number of errors that are allowed before the database server stops the load task.
- Reject file
- Specify the full path name for the reject file. Rows that have conversion errors during a load task or that violate check constraints on the external table are written to the reject file. If the reject file is not specified or cannot be opened, any error ends the load task abnormally.
Data Files
Click Add to specify the location of an external file that is opened when you use the external table.
- Type
- Disk: The data files reside on disk.
- Pipe: The data files reside on a named pipe.
- File name
- Enter the full path of the external file that is opened when the
external table is loaded or unloaded. To specify additional files,
click Add Another. Tip: For multiple files, you can use a formatted path name to designate the file name by using the substitution character %r (first ..last). For example, for the files ext_table_1.dat, ext_table_2.dat, and ext_table_3.dat, in the File name field, enter: ext_table_%r(1..3).dat.
- Options
When the data files reside on disk for a delimited table, you can specify the paths for the smart large objects. If the BLOB or CLOB directory is left blank, the data is stored in the directory entered in the File name field.
- BLOB directory: (Optional) Type the full path for the server directory in which the BLOB data is stored.
- CLOB directory: (Optional) Type the full path for the server directory in which the CLOB data is stored.