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: 7306

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: 7306

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 Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am


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