packed decimal to unpacked decimal

[jagan403]

hello every one

can any one help me out from this?

mainframe flat file was transfering to datastage,while transfering file was in packed decimalformat but in end target the packed decmial format shouldnt come?
this was the format in datastage we aree geeting--

member_sub_amt
0000000{
0000045{
0000198H
0000203C
0000098I
0000203C
0000098I
0000265D

i should not get this in endtarget for this wat i need to do....?
{-->meaning
h--->meaning
thanks in advance

[eddie13]

Originally Posted by jagan403

hello every one

can any one help me out from this?

mainframe flat file was transfering to datastage,while transfering file was in packed decimalformat but in end target the packed decmial format shouldnt come?
this was the format in datastage we aree geeting--

member_sub_amt
0000000{
0000045{
0000198H
0000203C
0000098I
0000203C
0000098I
0000265D

i should not get this in endtarget for this wat i need to do....?
{-->meaning
h---> meaning
thanks in advance

You probably have an answer by now. Sorry but I haven't checked posted as much as I should. The meaning of "{" is a number that ends with positive zero and "}" is a number that ends with a negative zero... such as -10 which would be 000001}. Fields ending in "A" are numbers that end with a positive 1... B==2, C==3 ... J==9. Negative 1 is "K", L==-2, M==-3 etc. ?This packed format would be either PIC S9(7) or decimal equalivent... S9(5)V9(2). To upload files, I always unpacked first and then upload that file. The unpacked file will have 4 additional characters. The packed field occupies 4 bytes (characters) and the unpacked field will occupy 8 bytes. If you want to convert the zone signed characters, use output format PIC 9999999- for trailing sign. Also notice that mainframe "a" and "A" have different values.
hope this helps.