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

Include Cond issue


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Tue Mar 29, 2016 8:51 pm
Reply with quote

Hi All

In my file i have records in HEX format.But when it is read in 9(2) variable.

Now i have to retrieve records with code as "98" which looks like below in the file at position 14.
Code:
6
2


I tried below include cond but they are not working to retrieve these records.
Code:
INCLUDE COND=(14,1,PD,EQ,62)
INCLUDE COND=(14,1,PD,EQ,98)
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Tue Mar 29, 2016 9:07 pm
Reply with quote

As you show, the field is not packed decimal (PD). What do you think should specify instead?
Back to top
View user's profile Send private message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Tue Mar 29, 2016 9:20 pm
Reply with quote

Actually i am not very sure if the record in file are Packed decimal or hex.
Its appearing as in input file.
Code:
6
2


As i need to find code as "98" i converted it to hex and got 62.

I am not sure now how to peel the records using include cond.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Tue Mar 29, 2016 9:46 pm
Reply with quote

Code:
INCLUDE COND=(14,1,CH,EQ,X'98')

.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Tue Mar 29, 2016 10:30 pm
Reply with quote

vickey_dw,

You also can't have multiple INCLUDE COND statements (or OMIT COND, or a mixture). Or, you can have them, but it won't do what you think.

Look at using OR, and in other cases AND, to have multiple conditions.
Back to top
View user's profile Send private message
Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1100
Location: Dublin, Ireland

PostPosted: Wed Mar 30, 2016 6:04 pm
Reply with quote

Quote:

Code:
INCLUDE COND=(14,1,CH,EQ,X'98')


actually,
Code:

Code:
INCLUDE COND=(14,1,CH,EQ,X'62')


Garry
Back to top
View user's profile Send private message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Wed Mar 30, 2016 9:29 pm
Reply with quote

Yes Garry you are correct.It worked for me.

Thanks Garry,Rahul and Bill !!!!
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts include cond ascii constant DFSORT/ICETOOL 4
No new posts Required Date Format in Include Sort ... DFSORT/ICETOOL 6
This topic is locked: you cannot edit posts or make replies. issue with Syntax error SYNCSORT 2
No new posts SMF Specify in the INCLUDE parameter ... DFSORT/ICETOOL 7
No new posts Issue while fetching a column(Nullabl... DB2 18
Search our Forums:

Back to Top