Home | Previous Page | Next Page   Defining Formats > Format Options >

Modifying Delimited-Format Options

The Delimiter Options window (Figure 73) lets you modify the following options of the delimited format.

Option
Description
Character set
The code set used to translate the data in the data table.
Driver
The driver that is used with the delimited format. For more information, see Selecting a Driver.
Delimiting characters
The delimiting characters, which are sometimes called record separators and field separators, indicate the beginning and end of records and fields.

You can specify the delimiting characters in ASCII, HEX, OCTAL, or DECIMAL format.

Global Language Support

You can select a desired GLS code set from the Character Set selection list. For information about locales and code sets, see the IBM Informix: GLS User's Guide.

End of Global Language Support
To modify the options for delimited formats
  1. Display the Delimited Format definition window.

    To do this, complete the steps in Creating a Fixed Format with the following modification: in step 3, click Delimited.

  2. Click the Options button in the Delimited Format definition window.

    The Delimiter Options window appears, as Figure 73 shows.

    Figure 73. The Delimiter Options Window
    begin figure description - This graphic depicts the ipload graphical user interface. The onpladm command line utility provides the same functionality. - end figure description
  3. Modify the options that you want to change.
  4. Click OK to save your changes and return to the Delimited Format definition window.
Tip:
You can use the DBDELIMITER environment variable to set the field delimiter for the dbexport utility and the LOAD and UNLOAD statements. However, do not use DBDELIMITER with the HPL because the onpload utility does not use this environment variable.

For more information on environment variables, see the IBM Informix: Guide to SQL Reference.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]