Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
High-Performance Loader User's GuideThe describes how to use the HCL Informix® to load and unload large quantities of data efficiently to or from Informix® databases.
Define formatsThis section describes the formats that the provides and shows how to prepare and edit the format component.
Delimited recordsDelimited records are records whose fields can vary in length. In a data file that contains delimited records, the records and fields are separated by a delimiter.
Create a delimited format that includes BYTE or TEXT dataIn a delimited format, BYTE or TEXT data can be characters, hexadecimal data, or a separate file.

Create a delimited format that includes BYTE or TEXT data

In a delimited format, BYTE or TEXT data can be characters, hexadecimal data, or a separate file.

The following sample data-file record shows a data record that has two fields of character data followed by a field of character BYTE or TEXT data, a field of hexadecimal byte or text data, and the path name of a file that contains BYTE or TEXT data.

field1|field2|TEXT data|BEEEF6699|/bbs/kaths/data2jn95

The following figure shows a format for the sample data-file record previously illustrated.

begin figure description - This figure is described in the surrounding text. - end figure description — Figure 1: Delimited format with BYTE or TEXT entries

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.