DEL data type descriptions

The following table lists the data types and the acceptable forms for each one for the import and load utilities.

Table 1. Acceptable data type forms for the DEL file format
Data type Form in files created by the export utility Form acceptable to the import and load utilities
BIGINT An INTEGER constant in the range -9223372036854775808 to 9223372036854775807. An ASCII representation of a numeric value in the range -9223372036854775808 to 9223372036854775807. Decimal and float numbers are truncated to integer values.
BLOB, CLOB Character data enclosed by character delimiters (for example, double quotation marks). A delimited or non-delimited character string. The character string is used as the database column value.
BLOB_FILE, CLOB_FILE The character data for each BLOB/CLOB column is stored in individual files, and the file name is enclosed by character delimiters. The delimited or non-delimited name of the file that holds the data.
BOOLEAN A Boolean value of 1 or 0. Other values (TRUE or FALSE, YES or NO, etc.) cannot be used. A delimited or non-delimited character string containing the character "1" (indicating TRUE) or "0" (indicating FALSE).
CHAR Character data enclosed by character delimiters (for example, double quotation marks).

A delimited or non-delimited character string. If required to match the width of the target column, the character string is leading truncated or padded with trailing spaces (X'20').
DATE yyyymmdd (year month day) with no character delimiters. For example: 19931029 for 29 October 1993.

Alternatively, the DATESISO option can be used to specify that all date values are to be exported in ISO format.

 A delimited or non-delimited character string containing a date value in an ISO format consistent with the territory code of the target database, or a non-delimited character string of the form yyyymmdd.
DBCLOB (DBCS only) Graphic data is exported as a delimited character string. A delimited or non-delimited character string, an even number of bytes in length. The character string is used as the database column value.
DBCLOB_FILE (DBCS only) The character data for each DBCLOB column is stored in individual files, and the file name is enclosed by character delimiters. The delimited or non-delimited name of the file that holds the data.
DB2SECURITYLABEL Column data is exported as raw data enclosed in quotation marks ("). Use the SECLABEL_TO_CHAR scalar function in the SELECT statement to convert the value to the security label string format. The value in the data file is assumed by default to be the actual bytes that make up the internal representation of that security label, delimited by quotation marks (" ").
DECIMAL A DECIMAL constant with the precision and scale of the field being exported. The decplusblank file type modifier can be used to specify that positive decimal values are to be prefixed with a blank space instead of a plus sign (+).

An ASCII representation of a numeric value that does not overflow the range of the database column into which the field is being imported. If the input value has more digits after the decimal point than can be accommodated by the database column, the excess digits are truncated.

LOAD and IMPORT accept decimal values enclosed in double quotes in a DEL file. For example, using "1234.5" in inputFile loading into a decimal column.
FLOAT(long) A FLOAT constant in the range -10E307 to 10E307. An ASCII representation of a numeric value in the range -10E307 to 10E307.
GRAPHIC (DBCS only) Graphic data is exported as a delimited character string. A delimited or non-delimited character string, an even number of bytes in length. The character string is truncated or padded with double-byte spaces (for example, X'8140'), if necessary, to match the width of the database column.
INTEGER An INTEGER constant in the range -2147483648 to 2147483647.

ASCII representation of a numeric value in the range -2147483648 to 2147483647. Decimal and float numbers are truncated to integer values.

LOAD and IMPORT accept integer values enclosed in double quotes in a DEL file. For example, using "123" in inputFile loading into an integer column.
LONG VARCHAR Character data enclosed by character delimiters (for example, double quotation marks). A delimited or non-delimited character string. The character string is used as the database column value.
LONG VARGRAPHIC (DBCS only) Graphic data is exported as a delimited character string. A delimited or non-delimited character string, an even number of bytes in length. The character string is used as the database column value.
SMALLINT An INTEGER constant in the range -32768 to 32767. AnASCII representation of a numeric value in the range -32768 to 32767. Decimal and float numbers are truncated to integer values.
TIME hh.mm.ss (hour minutes seconds). A time value in ISO format enclosed by character delimiters, as shown in the following example:
09.39.43		 A delimited or non-delimited character string containing a time value in a format consistent with the territory code of the target database.
TIMESTAMP yyyy-mm-dd-hh.mm.ss.nnnnnn (year month day hour minutes seconds microseconds). A character string representing a date and time enclosed by character delimiters. A delimited or non-delimited character string containing a time stamp value acceptable for storage in a database.
VARCHAR Character data enclosed by character delimiters (for example, double quotation marks).

A delimited or non-delimited character string. If required to match the width of the target column, the character string is leading or trailing truncated.
VARGRAPHIC (DBCS only) Graphic data is exported as a delimited character string. A delimited or non-delimited character string, an even number of bytes in length. The character string is truncated, if necessary, to match the maximum width of the database column.