Need to convert PD length from Decimal(4,0) to Decimal(6,2)

gotlamitla · New User Joined: 31 Oct 2006 Posts: 11

I have a DB2 column defined as Decimal(4,0) and is getting changed to Decimal(6,2). I have a file with old column length in a flatfile in PD format. I have to create a load file by converting this field to the new length(decimal 6,2) which is also in PD format.

Do we have any sample to convert a PD format field length as required to include decimal positions ?

shankar.v · Posted: Thu Feb 21, 2008 4:36 pm

gotlamitla,

Let us assume the DB2 column defined as Decimal(4,0) is in position 1 and length 3 of load file.

Please check with the following code for your requirement.

gotlamitla · New User Joined: 31 Oct 2006 Posts: 11

Thanks for the quick response.
But I understand that this sample you have given will not harm the integer part even it is getting multiplied with +100 as Decimal(4,0) and Decimal(6,2) will have integer part as S9(4) (execluding decimal part) ..
Ex: 1234 in decimal(4,0)
after the jcl ... it will be 123400 which will get mapped as 1234.00 for decimal(6,0)

I guess this approach creates problem if the destination field is having length decimal(11,2).

Let me know how can we acheive this.
Correct me if my understanding is wrong.

shankar.v · Posted: Thu Feb 21, 2008 7:51 pm

Hi gotlamitla,

Frank Yaeger · Posted: Thu Feb 21, 2008 10:46 pm

I don't use DB2 so I don't know the notation being used here.

Does Decimal(4,0) mean 4 digits with 0 digits after the decimal point (e.g. 1234)?

Does Decimal(6,2) mean 6 digits with 2 digits after the decimal point (e.g. 1234.56)?

Does Decimal(11,2) mean 11 digits with 2 digits after the decimal point (e.g. 123456789.01)?

If so, then to convert from Decimal(4,0) to Decimal(11,2), you could use:

Craq Giegerich · Posted: Thu Feb 21, 2008 11:04 pm

He shouldn't be, he should just be multiplying by +100 to add 2 zeros to the end.

shankar.v · Posted: Fri Feb 22, 2008 10:43 am

Hi Craq Giegerich/Frank Yaeger