MVSFORUMS.com

[Dip]

I am using DSNUTILB utility to load a table from a file.
Load control card is created from the extracted SYSPUNCH

Input file
----------

Field1 Field2 (varchar)

222 abcd

After loading the value In the table
------------------------------------

Field1 Field2 (varchar)
----------- -----------------
222 


select field2, hex(field2) from MY TABLE where field1 = 222;

FIELD2 hex(FIELD2)
----------------------------------- -----------------------------------
 D1C9C2C1

In the LOAD control card the defination of field2 is

"FIELD2 " POSITION( X:Y ) VARCHAR MIXED

(i am not very sure about the Keyword MIXED here. This is the way i got it in the SYSPUNCH)


Basically the table is getting loaded with the Hex format data from the file.
Do i need to change anything in the LOAD control card before loading the data?

Thnx
-Dip

[kolusu]

Dip,

The fielld2 column contains DBCS data. MIXED Specifies that the input field contains mixed DBCS data. If MIXED is specified, then any required CCSID conversions use the mixed CCSID for the input data; if MIXED is not specified, then any such conversions will use the SBCS CCSID for the input data.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu