Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SYNCSORT SORT Out any HEX values from a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
viveksingal

New User


Joined: 11 Sep 2005
Posts: 10

PostPosted: Sun Oct 21, 2007 8:03 am    Post subject: SYNCSORT SORT Out any HEX values from a file
Reply with quote

Hi,

I sorted a file to convert packed decimal value to ZD but my output file has some junk values as well.

Here is the sort card i used to convert the values from PD to ZD

SORT FIELDS=COPY
OUTREC FIELDS=(1:1,4,PD,TO=ZD,LENGTH=7,8:5,4,PD,TO=ZD)

Can you please tell me if the above sort is correct as per my requiremnt. If yes then is there any way i can find some records without any junk or hex value in it?

Thanks
Back to top
View user's profile Send private message

krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Sun Oct 21, 2007 8:26 am    Post subject:
Reply with quote

viveksingal
in your SORT statement, try this one
Code:
SORT FIELDS=COPY,ZDPRINT
Back to top
View user's profile Send private message
viveksingal

New User


Joined: 11 Sep 2005
Posts: 10

PostPosted: Sun Oct 21, 2007 8:51 am    Post subject: Reply to: Need to SORT Out any HEX values from a file
Reply with quote

Hi,

I tried using the ZDPRINT option but my job ended with Maxcc=16. below is the error message i am getting...

SORT FIELDS=COPY,ZDPRINT
*
OUTREC FIELDS=(1:1,4,PD,TO=ZD,LENGTH=7,8:5,4,PD,TO=ZD)
WER161B ALTERNATE PARM USED
WER268A SORT STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Sun Oct 21, 2007 10:39 am    Post subject:
Reply with quote

viveksingal
Sorry,

Code:
OPTION ZDPRINT
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,4,PD,TO=ZD,LENGTH=7,8:5,4,PD,TO=ZD)
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 Tue Apr 17, 2018 10:42 pm
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts LOW VALUES as a KEY juares castro DB2 10 Sat Apr 07, 2018 1:06 am
No new posts Reformatting and adding additional fi... Badbeef SYNCSORT 6 Thu Apr 05, 2018 4:45 pm
No new posts converting a mainframe file with ASA ... Lynne Schuler All Other Mainframe Topics 5 Wed Apr 04, 2018 9:44 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us