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