The Generate window appears, as Figure 115 shows. This window generates all of the components required for a load job and an unload job: format, load map, unload map, query, and device array. The Generate window lets you specify the characteristics of the components that ipload creates.
The Generate group specifies the type of generate to perform. The Generate group has the following choices.
| Choice | Effect | See Page |
|---|---|---|
| Load/Unload Job | Generates both load and unload jobs | Generating Load and Unload Components |
| No Conversion Job | Generates a job that treats an entire database record as one entity | Using the No Conversion Job Option |
| Maps and Formats only | Generates only a format, a load map, and an unload map |
The Format Type group specifies the format of the data file. The Format Type group has the following choices.
| Choice | Description | See Page |
|---|---|---|
| Delimited | The fields of a data-file record are separated by a field delimiter, and records are separated by a record delimiter. The default delimiters are vertical bar (|) and new line, respectively. | Modifying Delimited-Format Options |
| Fixed Internal | The data file uses Informix internal format. The only changes to the data that you can make when you use this format are ALTER TABLE changes: modify the order of columns, delete or add columns, or change the data type. The HPL loads and unloads data in this format more efficiently than data in the Delimited and Fixed ASCII formats. | Other Formats |
| Fixed ASCII | All records are the same length. Each record contains characters in fixed-length fields. This format is the same as the Fixed format choice of the Record Formats window. | *** |
| Fixed Binary | The data-file records contain data in fixed-length fields. Character-oriented data is in character fields. Numeric data (integer, float, and so on) is in machine-dependent binary values. Use this format for loading or unloading data for an application that has or requires data in binary format. Data in binary format is much more compact than data in ASCII format. | *** |
| COBOL | The data file is formatted according to COBOL 86 standards. All COBOL data types are supported. | COBOL Records |
| COBOL (byte) | The data file is formatted using byte alignments for COMP-4 data type. All COBOL data types are supported. |