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 for retrieveing binary values

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

New User


Joined: 26 Aug 2008
Posts: 52
Location: inida

PostPosted: Wed Dec 17, 2008 5:46 pm    Post subject: SYNCSORT for retrieveing binary values
Reply with quote

Hi,

I want to retrieve values 11 and 1 starting from position 5 and length of 2. This is VB file.i have used following control card.

OPTION COPY
INCLUDE COND=((7,2,BI,EQ,11,OR,1)

i got the syntax error. please help me to retrieve 11 and 1 in starting position 3 and length of 2.

regards
suneel
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Wed Dec 17, 2008 8:37 pm    Post subject:
Reply with quote

you are indicating Binary with the BI.
I imagine your constants, 11 and 1, are not coded as Binary Constants.

COBOL would be X'11' and X'01'.

I know that if your include condition was for CH (characters) the constants would be coded as C'11' and C'01'.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2276
Location: @my desk

PostPosted: Wed Dec 17, 2008 9:36 pm    Post subject:
Reply with quote

suneelv,

Since you already have a topic in discussion for the same problem, you could have replied to the same rather than starting a new topic.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Sat Dec 20, 2008 1:58 am    Post subject:
Reply with quote

The reason for the syntax error is that the INCLUDE statement is not coded correctly. Try this:

Code:
INCLUDE COND=(7,2,CH,EQ,C'11',OR,
              7,2,CH,EQ,C'01')

If you have access to SyncSort for z/OS 1.3, this can be simplified to the following:
Code:
INCLUDE COND=(7,2,CH,EQ,L(C'11',C'01'))
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Dec 22, 2008 9:02 pm    Post subject:
Reply with quote

(sorry Gerry - I deleted your post by accident. But thanks for pointing out the extra paren. I made the correction in my previous post).

-Alissa
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Dec 22, 2008 9:10 pm    Post subject:
Reply with quote

suneelv,

It was brought back to my attention that you originally stated that your data was binary. If that is the case, then you can specify the following:
Code:
INCLUDE COND=(7,2,BI,EQ,11,OR,
              7,2,BI,EQ,01)
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 Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm


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