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
 

 

STOPAFT use in ICETOOL SELECT OPERATOR

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

New User


Joined: 28 Jul 2005
Posts: 37

PostPosted: Tue Oct 06, 2009 3:39 pm    Post subject: STOPAFT use in ICETOOL SELECT OPERATOR
Reply with quote

Hi,

Do we have some option used in ICETOOL SELECT OPERATOR?


Code:
 SELECT FROM(IN) TO(OUT) ON(1,3,CH) ALLDUPS


Can we stop the ICETOOL in case we have any duplicate records selected?

For example, we have below records in the input file.
111
333
444
111
222
333

We need ICETOOL stop after process to record 4 since already find one duplicate record with 111.
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Oct 06, 2009 8:56 pm    Post subject:
Reply with quote

Yes, you can use STOPAFT with SELECT, but I suspect that won't help you.

But it isn't clear what you want to do. What do you mean by "Can we stop ICETOOL in case we have any duplicate records selected"? Do you mean that you want a non-zero return code in that case, or what? If you're looking for some particular expected output records, show what you expect. Explain the "rules" for satisfying your requirement. Give the RECFM and LRECL of the input file.
Back to top
View user's profile Send private message
rally

New User


Joined: 28 Jul 2005
Posts: 37

PostPosted: Wed Oct 07, 2009 5:22 pm    Post subject:
Reply with quote

I have one input SEQ file with RECFM=FB, LRECL=80. there are more than 3,000,000 records in this file.

I want to know if we have duplicate record (for the 1st 10 bytes) or not in this file. We don't want the ICETOOL to check all records if we already found the duplicate record in this file.

1111111111
3333333333
4444444444
1111111111
2222222222
3333333333

for above sample, we will find we have duplicate record when we process to the 4th records, can I stop the SELECT process and continue next STEP? we don't need to know all duplicate records since it will need more time.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed Oct 07, 2009 6:20 pm    Post subject:
Reply with quote

Quote:
we don't need to know all duplicate records since it will need more time.

How much time dfsort is taking currently to process all records?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Oct 07, 2009 8:50 pm    Post subject:
Reply with quote

Quote:
We don't want the ICETOOL to check all records if we already found the duplicate record in this file.
...
can I stop the SELECT process and continue next STEP?


The answer is No. In order to find the duplicate records, we must read all of them and sort them. STOPAFT operates on the input records, not the sorted records.

I suppose you could do what you want by using a COPY with an E15 to save off each record until you find a duplicate and then have the E15 pass back RC=8. But that could require a lot of storage if you have a lot of records and the first duplicate is far into the file. And depending on how big your file is, it may not save you any time since an E15 slows DFSORT down.
Back to top
View user's profile Send private message
rally

New User


Joined: 28 Jul 2005
Posts: 37

PostPosted: Thu Oct 08, 2009 8:35 pm    Post subject:
Reply with quote

Thanks for your clarification for STOPAFT usage. it's very helpful for me to understand how DFSORT works.
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 Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 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 How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm


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