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
 

 

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 Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
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
No new posts Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm


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