Dataloader/MP Reference Manual

Specifying File-Related Options for DataLoader/MP
DataLoader/MP Reference Manual—424148-003
4-6
EBCDIC
Each character in a record in a DUMP file is displayed once in hexadecimal format
and, if it is a printable character, again in ASCII. If the character is not printable, a
period (.) is printed.
When changing records in a DUMP file, the use designator allows you to avoid
changing both the hexadecimal and ASCII versions of the characters. If use is HEX,
only the hexadecimal representation of the record is used to reconstruct the record. If
use is ASCII, the ASCII representation is used to reconstruct the record. The only
exception is that if use is ASCII and the ASCII representation of a character is a period
(.), DataLoader/MP cannot tell what character is represented, so the hexadecimal
representation for the character that corresponds to a period (.) is used for the
reconstruction.
If <use> is omitted, the default is HEX.
Dump records have a specific format, as shown following, and any records that do not
conform to this format are transparently skipped on input. Interpretation of any ASCII
characters appears on the right side of the listing:
00000 54 68 69 73 20 72 65 63 6F 72 64 20 63 6F 6E 74 This record cont
00016 61 69 6E 73 20 41 53 43 49 49 20 63 68 61 72 61 ains ASCII chara
00032 63 74 65 72 20 64 61 74 61 20 66 6F 6C 6C 6F 77 cter data follow
00048 65 64 20 62 79 20 73 6F 6D 65 20 62 69 6E 61 72 ed by some binar
00064 79 20 64 61 74 61 00 01 02 03 04 05 06 07 08 09 y data..........
< blank line >
The primary use for the DUMP interpretation is for the error (-E) file. DataLoader/MP
puts records that have problems into this file in the correct dump format, together with
a description of the problem. This arrangement lets you research the problem, use a
text editor to fix the records, and then rerun DataLoader/MP with the corrected records
as the input.
The error file can be edited directly and used as input to the DataLoader/MP rerun by
specifying the edit file as the input (-I) file with the interpretation of DUMP. Problem
descriptions are ignored, so they need not be deleted. Further, it might be useful to add
a description of what corrective actions have been taken in the file.
The DUMP interpretation can be used only for edit files.
EBCDIC
The EBCDIC interpretation directs DataLoader/MP to convert all of the data in the input
file from EBCDIC to ASCII. It applies only to input files.
The conversion assumes the whole record is character data and converts it all. If the
record contains any binary fields, their values will be changed by the conversion, which
is probably not desirable. In such cases you can supply a CONVERTIT or MISCn user
exit in which you can use the library function DTLEBCDICToASCII() to convert only the
fields that are character fields.