Creating a Delimited Format

To create a format for delimited records, follow the same steps as in Creating a Fixed Format, with the following modifications:

• In step 3, click Delimited in the Type group.
• Omit step 9. When you use delimited records, ipload does not need byte or decimal information.

Data Types Allowed in a Delimited Format

You can use the following data types when you prepare a delimited format.

Data Type

Description

Chars

Normal ASCII data

BYTE or TEXT File

File that contains BYTE or TEXT data

TEXT Data

TEXT data is formatted as ASCII text. If the text includes carriage returns (new lines) or delimiters, a backslash (\) must precede those characters.

BYTE or TEXT HexASCII

BYTE or TEXT data that is formatted in ASCII hexadecimal. The onpload utility translates the data into binary before it loads the data into the database.

BLOB or CLOB

File that contains BLOB or CLOB data

Simple LO File

The name of a file that contains Simple LO data (BYTE and TEXT data)

Simple LO Text

Simple LO data that is formatted as ASCII text. If the text includes carriage returns, newline characters, or delimiters, a backslash (\) must precede those characters

Simple LO HexASCII

Simple LO data that is formatted in ASCII hexadecimal. The onpload utility translates the data into binary before it loads the data into the database.

Ext Type String

The ASCII representation of a Data Type (Ext Type) value

Ext Type HexASCII

The HexASCII representation of an Ext Type value