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: 6966
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: 2180
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 Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am


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