MVSFORUMS.com

kavi · Beginner Joined: 15 Sep 2006 Posts: 64 Topics: 22

Hi All,
I have a input file of 9 bytes. I want to creat a dynamic control card
with the following condition.
OMIT COND=(17,9,CH,EQ,C'input file value')
the input file has more than 2 record, hence for first record the condition should be
OMIT COND=(17,9,CH,EQ,C'input file value',OR,
This can be achieved by STOPAFT=1.
For second should be
17,9,CH,EQ,C'input file value',OR,
and so on.
Last record should be
17,9,CH,EQ,C'input file value')
How this can be achieved by SORT. In my shop we have
only SORT (No icetool)

Thanks in advance
Kavi

ofer71 · Posted: Tue Jan 09, 2007 8:16 am Post subject:

How about REXX?

O.
________
Mazda RX-3 history

kavi · Beginner Joined: 15 Sep 2006 Posts: 64 Topics: 22

Thanks for your reply Ofer71,
But SORT is preferable

Thanks in Advance
Kavi

kolusu · Posted: Tue Jan 09, 2007 12:17 pm Post subject:

kavi,

The best way to generate the dynamic control cards is to put some dummy values in the include condition. By doing so your next sort step which reads in the dynamic control cards will work fine.

try this

kavi · Beginner Joined: 15 Sep 2006 Posts: 64 Topics: 22

Kolusu,
You are simply superb.

Thanks for your solution It works.

Thanks for all
Kavi

semigeezer · Posted: Wed Jan 10, 2007 1:28 am Post subject:

I don't know how to use sort control cards but it looks like this will generate OMIT conditions for AAAAAAAAAA and ZZZZZZZZZZ which does not meet the original criteria? Is this right?

I'd like to understand why Rexx is not the appropriate tool for this. It is 6 or 7 lines of very easy to understand, read "maintain", code.

kavi · Beginner Joined: 15 Sep 2006 Posts: 64 Topics: 22

semigeezer
As per our requirement it should be in SORT. Thats why we tried it in SORT. It doesn't mean that Rexx is not the appropriate tool for this. Can you please post the REXX solution so that i can learn an alternate solution for this.

Thanks
Kavi

kolusu · Posted: Wed Jan 10, 2007 9:57 am Post subject:

Frank Yaeger · Posted: Wed Jan 10, 2007 12:17 pm Post subject:

Actually, a better dummy condition for "never true" is:

1,1,NE,1,1,

That way, you don't need to pick a value that doesn't exist in the input file.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

kavi · Beginner Joined: 15 Sep 2006 Posts: 64 Topics: 22

Hi All,
Is there any limit in the control card for omiting the records?. Because we created a dynamic control card with 1800 records to be omitted but the SORT failed with error message EXCESS CARDS in SYSOUT.

Please clarify the following
1. Does that means SORT can't handle more than the specified limit, If so let me know the limit.
2. What is the alternate way of fullfilling the requirement?

Thanks in advance
Kavi

kolusu · Posted: Wed Jan 17, 2007 9:18 am Post subject:

Frank Yaeger · Posted: Wed Jan 17, 2007 12:18 pm Post subject:

DFSORT does not have a limit on the number of SYSIN statements, but it does have a limit on the number of INCLUDE/OMIT conditions that varies with the length and format of the fields. For this situation, the limit is a bit over 1700 conditions. And you can extend that limit by using IFTHEN clauses as explained for DFSORT's message ICE151A:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CM20/2.2.147?SHELF=&DT=20060721170811&CASE=

However, the 'EXCESS CARDS in SYSOUT' message indicates you're using Syncsort, not DFSORT.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

kavi · Beginner Joined: 15 Sep 2006 Posts: 64 Topics: 22

Hi

Thanks for all your replies.
we have V1R2 SYNCSORT product in our shop. Please let me know the alternate ways.

Thanks
Kavi

kolusu · Posted: Thu Jan 18, 2007 10:20 am Post subject:

amargulies · Beginner Joined: 10 Jan 2007 Posts: 123 Topics: 0