Download IBM Informix High-Performance Loader User's Guide
Transcript
that is not described in this table, you must create a new machine definition using the Machines window. For more information, see “Machines window” on page 5-6. Column Type Description machinename CHAR(18) Computer name or type (primary key) byteorder CHAR(3) Binary byte ordering: LSB or MSB shortsize INTEGER Size of a short integer intsize INTEGER Size of an integer longsize INTEGER Size of a long integer floatsize INTEGER Size of a float value doublesize INTEGER Size of a double value Mapitem table in the onpload database The mapitem table defines the relationship between the columns of a database table and the record fields of a data file. The table stores pairs of column/record entries. The map options modify this table. For more information, see “Load and unload maps” on page 9-1. Column Type Description formid INTEGER Specifies the map to which this record belongs (foreign key to the maps table) seq INTEGER Unique identifier for the database-column/data file-record pair colname VARCHAR(128,0) Name of database column fname CHAR(128) Name of field in a data-file record Mapoption table in the onpload database The mapoption table defines conversion options for the mapping pairs that are defined in mapitem table. Use the Mapping Options window to modify this table. For more information, see “Using the mapping options” on page 9-8. Column Type Description formid INTEGER Specifies the map to which this record belongs (foreign key to the maps table) seq INTEGER The database-column and/or data file-record pair to which this option applies (foreign key to the mapitem table) bytes INTEGER Maximum number of bytes to transfer from a field of a data file minvalue FLOAT Minimum value allowed in field maxvalue FLOAT Maximum value allowed in field ccase CHAR(18) Case conversion option: None, Lower, Upper, Proper Noun justify CHAR(18) String justification to perform: None, Left, Right, Center Appendix A. onpload database A-7