Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Changing the sequential file records into packed decimal rec

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
yellanki

New User


Joined: 27 Mar 2006
Posts: 8
Location: columbus

PostPosted: Tue Feb 19, 2008 2:43 am    Post subject: Changing the sequential file records into packed decimal rec
Reply with quote

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 .
Back to top
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Feb 19, 2008 3:52 am    Post subject: Re: Changing the sequential file records into packed decimal
Reply with quote

yellanki wrote:
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 .


SPUFI returns everything in character format. I'm not sure what you want but try using CHAR instead of DIGITS. I can't understand why so many people think PD is something nasty.
Back to top
View user's profile Send private message
yellanki

New User


Joined: 27 Mar 2006
Posts: 8
Location: columbus

PostPosted: Tue Feb 19, 2008 4:06 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Feb 19, 2008 4:52 am    Post subject:
Reply with quote

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. . .
Back to top
View user's profile Send private message
yellanki

New User


Joined: 27 Mar 2006
Posts: 8
Location: columbus

PostPosted: Tue Feb 19, 2008 11:15 am    Post subject: Reply to: Changing the sequential file records into packed d
Reply with quote

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


):-
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Feb 19, 2008 6:40 pm    Post subject:
Reply with quote

Why not just have the program query the data directly instead of making a copy of something already in storage?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us