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
 

 

Case insenstive in INCLUDE Condtion

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
smileseenu

New User


Joined: 27 Sep 2006
Posts: 13
Location: India

PostPosted: Mon Feb 15, 2016 8:42 pm    Post subject: Case insenstive in INCLUDE Condtion
Reply with quote

Dears,

In the input file we have,

Test
TEST
test
exclude


I am trying to extract using Include condition in SORT all records with "Test" (3 records) in position1
Back to top
View user's profile Send private message

Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 988
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Mon Feb 15, 2016 9:35 pm    Post subject:
Reply with quote

Code:
 INCLUDE COND=(1,4,CH,EQ,C'TEST',OR,
               1,4,CH,EQ,C'TESt',OR,1,4,CH,EQ,C'TEsT',OR,
               1,4,CH,EQ,C'TeST',OR,1,4,CH,EQ,C'tEST',OR,...


... and keep going until you've covered every combination. If the file is VB, alter the position accordingly.

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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Mon Feb 15, 2016 9:50 pm    Post subject: Reply to: Case insenstive in INCLUDE Condtion
Reply with quote

if you are up-to-date:

"Alphanumeric comparison tests
New UC, LC, MC, UN, LN and MN keywords (similar to the previously available
NUM keyword) now allow you to test a field for various combinations of
alphanumeric characters or non-alphanumeric characters using binary (BI) format.
The new keywords allow you to select any of the following alphanumeric
character sets:
v UC: Uppercase characters (A-Z)
LC: Lowercase characters (a-z)
MC: Mixed case characters (A-Z, a-z)
UN: Uppercase and numeric characters (A-Z, 0-9)
LN: Lowercase and numeric characters (a-z, 0-9)
MN: Mixed case and numeric characters (A-Z, a-z, 0-9)
You can use these new keywords in the following comparison operands: COND,
INCLUDE, OMIT, BEGIN, END, WHEN and TRLID."

There are similar new options for starting and ending PARSE.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts Include Cond issue vickey_dw DFSORT/ICETOOL 6 Tue Mar 29, 2016 8:51 pm
No new posts How steps execute in Job in case of a... richiewalia JCL & VSAM 4 Tue Jan 12, 2016 12:34 pm
No new posts Include groups of records jyotsnapanicker SYNCSORT 4 Wed Dec 30, 2015 4:37 pm


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