Changing the sequential file records into packed decimal rec

yellanki · New User Joined: 27 Mar 2006 Posts: 8 Location: columbus

Hi All,

I ran a query in SPUFI, the selected field is packed decimal variable in the table but where as in SPUFI output I got it as normal variable.

I would like to convert my selected field as packed decimal, I used DIGITS in the query but didn't get the expected result.

Can some one help me on that, Thanks for your valuable time .

Craq Giegerich · Posted: Tue Feb 19, 2008 3:52 am

yellanki · New User Joined: 27 Mar 2006 Posts: 8 Location: columbus

I ran the query the CHAR but it looks like got the similar result when I tried with DIGITS.

The reason i need the file in PD format is my spufi output is input to another program which accepts the file in PD format.

Thanks

dick scherrer · Posted: Tue Feb 19, 2008 4:52 am

Hello,

I'd suggest you discontinue using spufi and write a bit of program code to create the file as you want it or change the file definiton to use the data as spufi creates it.

An additional step could also be added to convert the file from spufi format to needed format. . . . No, that was not really a suggestion. . .

yellanki · New User Joined: 27 Mar 2006 Posts: 8 Location: columbus

I follow it, wrote the syncsort for that not yet tested. Thanks for your timely response.

):-

stodolas · Posted: Tue Feb 19, 2008 6:40 pm

Why not just have the program query the data directly instead of making a copy of something already in storage?