MVSFORUMS.com

[haritha_e]

Hi All,

I have a requirement where in i need to receive a file from UNIX. There is one table in DB2 UDB sitting on the UNIX box, which will be unloaded on a daily basis and will be sent it across to the mainframe. The table contains the below mentioned data types
1. Bigint - size 8 bytes
2. Smallint - size 2 bytes
3. Varchar
4. Decimal

To define my copybook in mainframe, i need to know the compatible data types on mainframe. Could anybody let me know those details?

Thanks
Haritha

[dr_te_z]

Do not try to walk that road:"using native database formats and expect them to be handled well during 'unload/ftp/ascii ebcdic translation / load' process"

Guide your data trough that process. Use "cast" to flatten (is that english?) your data into readable format. Simple: if a human can read it a computer can easaly translate it to another code-set. DB2-SQL offers a rich syntax to cast to-and-from CHAR in your unload/load jobs.

[kolusu]

haritha_e,


Here are the equivalent data types

BIGINIT = S9(10) through S9(18 ) COMP which is a Binary double-word (8 bytes)
SMALLINT = S9(1) through S9(4) COMP Binary half-word (2 bytes)
VARCHAR = will contain 2 components the length field and the actual field size.