The Extended Bulk Load Utility for both Sybase ASE and Sybase IQ has the following options:

Commit ever row(s)

The row interval to commit or write transactions to the database.

Column Delimiter

Is the delimiter character(s) used between fields. It is used by the intermediate flat file used to load the database.

The delimiter can be up to four characters and can be specified as:

TAB. A tab character. This is the default value.

a. A character string, for example ~.

0x nn. A hex code, for example, 0x44 (a comma), or 0x0D0A (a return and a linefeed).

Row Delimiter

Is the delimiter character used between records. It is used by the intermediate flat file used to the load the database. The row delimiter can be specified in the same manner as the (field) delimiter except that character comma (,) is not permitted.

Activate Server Log

This parameter is available for Sybase IQ only.

Activates log information about integrity constraint violations and the types of violations. With this option, two types of LOG files could be written into a temporary space in the configuration directory: MESSAGE LOG file etlblk.msg and ROW LOG file etlblk.log.

For Sybase IQ:

• Yes. Writes both MESSAGE LOG and ROW LOG files: etlblk.msg and etlblk.log
• No. The LOG files are not written. This is the default value.

Maximum Number of Load Sessions

The maximum number of Load Sessions logged on to the database.

Maximum Number of Load Session Restarts

The maximum number of restart attempts after recoverable Load Session error.