COnversion

[shrey3a]

Hi,

I've a typical scenario , I need to do the below conversion to provide the file to mainframe group so that they can match the data from ascential generated file with mainframe file

e.g. Value -212.00 should be converted to 0000000021200D

The above looks like decimal to Hex conversion. I tried all tyhe routines in DS for the same like Xtd, dtx, mxoc, MUOC but its not giving the desired o/p even i tried the packed decimal routines provided by datastage for packed decimal field .

Can any body help.

Regards.

[chulett]

Nope, not hex, not packed. Looked like Zoned Decimal for a second, but it's not that either. Ask your mainframe folks what that 'D' is supposed to represent.

The FMT command can handle the zero padding and the descaling of the number to remove the decimal point.

[I_Server_Whale]

Hi Shrey3a,

I have encountered a similar case before. It looks like you have to encode your values using a particular logic. Find out if there is any logic to be applied inorder to get the 00D for a negative number.

I think your o/p field is of length 14. You should also let us know the length and datatype of your input field.

More information is needed from your side to proceed further. Once you are sure about the conversion logic, then apply the logic and use the Fmt function as said by Craig.

Thanks,
Naveen.

[shrey3a]

Hi ,

The D stands for (-) and (+) or nothing stands for C. And length of the mainframe field is 14.

Regards,

Hi Shrey3a,

I have encountered a similar case before. It looks like you have to encode your values using a particular logic. Find out if there is any logic to be applied inorder to get the 00D for a negative number.

I think your o/p field is of length 14. You should also let us know the length and datatype of your input field.

More information is needed from your side to proceed further. Once you are sure about the conversion logic, then apply the logic and use the Fmt function as said by Craig.

Thanks,
Naveen.

[chulett]

Was wondering if 'D' was debit.

So look at using FMT for everything except the 'D' and manually tack the appropriate trailer character on based on the sign of the amount.

[ray.wurlod]

Code: Select all

Fmt(Abs(Iconv(TheNumber,"MD2")),"R%13") : (If TheNumber < 0 Then "D" Else "C")