1
Download Guide to the High-Performance Loader, Version 7.3
Transcript
Setting the Mapping Options Setting the Mapping Options You can set as many of the choices on the Mapping Options window as you need. Justification The Justification option positions text within a record. You can justify the text to the left or right, or you can center it. Case Convert The Case Convert option converts the case of the data to the selected case. The HPL supports upper, lower, and proper-name conversions. For example, you can make the following conversions. Input Conversion Type Result JOHN LEE SMITH Proper Name John Lee Smith john lee smith Proper Name John Lee Smith john lee smith Upper JOHN LEE SMITH JOHN LEE SMITH Lower john lee smith Default Value The Default Value option specifies the value that is inserted into the column when no field is mapped into that column. Transfer Bytes The Transfer Bytes option specifies the number of bytes in the record field to transfer to the database column. For variable-length format records, this number reflects the maximum size of the field. The actual number of bytes to transfer is determined by the record or field delimiters. Defining Maps 9-15
