How to use Include and exclude/Omit condition in same step ?

M.RAJAN · New User Joined: 18 Jul 2005 Posts: 5 Location: chennai

Hi All,

I am new to this forum and trying to find out the alternate solution for the below problem.

My Input:

002 130 1000
002 130 2000
050 090 3000
123 999 4000
345 234 5000
001 234 6000
034 234 7000
025 233 8000
050 987 1500
023 365 9000

Expected Output:

002 130 2000
050 090 3000
050 987 1500

My code is,

SORT FIELDS=(1,15,CH,A)
INCLUDE COND=((1,3,CH,EQ,C'002',AND,9,4,CH,NE,C'1000'),OR,
(1,3,CH,EQ,C'050',AND,9,4,CH,NE,C'1000'))

it is working as expected. But i am trying to find out the alternate way, using Include and Exclude/Omit condition. I would like to get answer in DFSORT as well as SYNCSORT.

dick scherrer · Posted: Sun Feb 21, 2010 10:02 am

Hello,

Your working syntax should work for both sort products.

M.RAJAN · New User Joined: 18 Jul 2005 Posts: 5 Location: chennai

Thanks Dick,

Can you please give me a DFSORT and syncsort manual links ?

CICS Guy · Posted: Sun Feb 21, 2010 10:16 pm

DFSort: DFSORT/ICETOOL Reference Material
Syncsort, talk to the source.....

dick scherrer · Posted: Mon Feb 22, 2010 12:11 am

Hello,

Syncsort manuals are covered by copyright and we may neither post nor link to them.

If your organization is licensed to use the product, all of the material may be obtained from Syncsort support.

Alissa Margulies · Posted: Tue Feb 23, 2010 2:57 am

Please feel free to send me a PM or contact me offline at alissa.margulies@syncsort.com and I would be happy to assist you with acquiring the SyncSort manuals.

Escapa · Posted: Tue Feb 23, 2010 10:26 am

dick scherrer · Posted: Tue Feb 23, 2010 10:38 am

Hi Sambhaji,

Yes, if the organization has licensed the product. . .

jctgf · Active User Joined: 04 Nov 2006 Posts: 109

maybe you can use the IFTHEN statement combined either with the include OR the omit statement.

dick scherrer · Posted: Mon Mar 01, 2010 2:24 am

Hello,

How does this reply abput IFTHEN relate to the problem using both INCLUDE and OMIT in the same process. . .

As quoted earlier from the manual:

jctgf · Active User Joined: 04 Nov 2006 Posts: 109

he said he wanted an alternate way of selecting records.
he could use the inrec ifwhen to flag the records and then discard/maintain them either with a simplified omit or include statement.
i wouldn't do that, but it's an "alternate way".
he can use omit and include in the same step since he uses sortfil, and the many outputs can be concatenated if he uses icetool.
these are possibilities, only.
i'd maintain the include statement as presented in the original post, though. to me, it's the best solution since it does what he needs.
regards.

dick scherrer · Posted: Mon Mar 01, 2010 4:42 am

Hello,

Have you successfully done "both" in the same Syncsort execution?

Please post only successfully tested "solutions" and the informational system output from them.

Arun Raj · Posted: Mon Mar 01, 2010 7:01 am

jctgf · Active User Joined: 04 Nov 2006 Posts: 109

hi,
i think this way is simpler.
both include and omit at the same step.

Arun Raj · Posted: Mon Mar 01, 2010 6:50 pm

jctgf · Active User Joined: 04 Nov 2006 Posts: 109

simpler than using icetool.
this is just an "alternate way", as required in the original post.

Arun Raj · Posted: Mon Mar 01, 2010 8:49 pm

somunote · New User Joined: 23 Jan 2010 Posts: 7 Location: Toronto

Frank Yaeger · Posted: Tue Mar 09, 2010 5:37 am

Well, if the question was "how can I use INCLUDE and OMIT in the same step to create separate data sets", then your solution would apply. But nobody said anything about separate data sets. Of course, you could have another step to bring those separate data sets together, but that would require another pass.

The fact is you cannot use an INCLUDE statement and an OMIT statement in the same run. You can certainly use one INCLUDE statement or one OMIT statement for multiple conditions that would include or omit records. You can use IFTHEN clauses to set flags that could then be used in OUTFIL INCLUDE. You could do lots of things to solve particular problems. But in this case, it's not clear what the original poster even wanted to do with INCLUDE and OMIT, so it's difficult to say what's relevant as a solution.

I think the original poster got tired of the discussion a long time ago so it's not likely we'll get any clarification.

CICS Guy · Posted: Tue Mar 09, 2010 5:40 am

Well put Frank, is it time to just lock the Topic?

Frank Yaeger · Posted: Tue Mar 09, 2010 6:05 am