IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT for retrieveing binary values


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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: 2481
Location: @my desk

PostPosted: Wed Dec 17, 2008 9:36 pm
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: 496
Location: USA

PostPosted: Sat Dec 20, 2008 1:58 am
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: 496
Location: USA

PostPosted: Mon Dec 22, 2008 9:02 pm
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: 496
Location: USA

PostPosted: Mon Dec 22, 2008 9:10 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts Converting ASCII values to COMP-3 (ZD... JCL & VSAM 2
Search our Forums:

Back to Top