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
 

 

ICETOOL select records issue

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

New User


Joined: 11 Dec 2008
Posts: 33
Location: China

PostPosted: Mon May 12, 2014 1:56 pm    Post subject: ICETOOL select records issue
Reply with quote

Hi Guys,

I have a QSAM file like below: 9 bytes field1 + other fileds
111111111+rec1
111111111+rec2
111111111+rec3
222222222+rec21
333333333+rec31
333333333+rec32
333333333+rec33
333333333+rec34
333333333+rec35

Now I want to select all records whose fields 1 occurs more than two times. for example, records 1 and 2 and 3 occurs 3 times on the fileds 1, so it will be output.

111111111+rec1
111111111+rec2
111111111+rec3
333333333+rec31
333333333+rec32
333333333+rec33
333333333+rec34
333333333+rec35

may I know can we use ICETOOL for this purpose? thanks!
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7255

PostPosted: Mon May 12, 2014 2:10 pm    Post subject: Reply to: ICETOOL select records issue
Reply with quote

Yes, please feel free to use ICETOOL fo this and any other purpose to which it is well-suited. You don't need to ask permission.

How do you find out what it is useful for? There is a manual, and each of the ICETOOL operators is listed. At the very least know where to find what is available. Then read the first few paragraphs. Then look at the examples at the end of each operator. Also look at the Smart DFSORT Tricks publication.

Then, when you get stuck with something difficult, you know the types of places to come to.
Back to top
View user's profile Send private message
lee_issc

New User


Joined: 11 Dec 2008
Posts: 33
Location: China

PostPosted: Mon May 12, 2014 2:21 pm    Post subject: Re: Reply to: ICETOOL select records issue
Reply with quote

Bill Woodger wrote:
Yes, please feel free to use ICETOOL fo this and any other purpose to which it is well-suited. You don't need to ask permission.

How do you find out what it is useful for? There is a manual, and each of the ICETOOL operators is listed. At the very least know where to find what is available. Then read the first few paragraphs. Then look at the examples at the end of each operator. Also look at the Smart DFSORT Tricks publication.

Then, when you get stuck with something difficult, you know the types of places to come to.


may I have any key words or operator of ICETOOL to use?OCCURS or COUNT? but they use to generate a report I think
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7255

PostPosted: Mon May 12, 2014 2:28 pm    Post subject: Reply to: ICETOOL select records issue
Reply with quote

Mmmm.... language barrier maybe.

Look at OCCURS in the documentation. Look at COUNT. Do they do what you want? Then you can stop thinking what they are used for and know.

Then continue your reading.

I know you want everything just here, but you'll pick up more this way.

Quote:
Now I want to select all records whose fields 1 occurs more than two times. for example, records 1 and 2 and 3 occurs 3 times on the fileds 1, so it will be output.


So, bear what you want in mind, and do what I suggested previously. Say to yourself "I want to select, I want to select, I want to select" whilst going through the list of operators. It'll help.
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
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm


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