MVSFORUMS.com

[waves]

Hi all,
i have two questions.

first one is as follows:

i'm using two sort conditions to eliminate the following:

a) zeroes in the Timestamp field

//SYSIN DD *
SORT FIELDS=COPY
OMIT COND=(260,14,CH,EQ,C'00000000000000')
//*

b)all blanks in the two columns.

//SYSIN DD *
SORT FIELDS=COPY
OMIT COND=(188,13,CH,EQ,C' ')
//*

is there any possibility to merge the above said sort conditions using SYNCSORT tool.

My second question is as follows:

after doing the above sort fucntions, i will be recieving the sorted record without the zeroes and blanks in the respective fields.

i want those records for which i eliminated the zeroes and blanks to be moved to a separate file.

please help me on this. please correct me if i'm wrong anywhere.

thanks in advance.

[vkphani]

Waves,

For your first question: Yes you can combine both the conditions as below.

[vkphani]

Waves,

For your second question: You can extract the eliminated records by checking for zeros or blanks in your input file as below.

[waves]

hi Vkphani,

thanks a lot for ur quick reply.

the solution which u gave for the first one worked fine for me..

but i have a question regarding the second one.

if i need to extract the eliminated records to a separate file, do i need to use another condition 'INCLUDE' in my jcl using the same input file which i used for the 'OMIT' Condition.

is there any possibility to get those eliminated records after from the OMIT condition which was mentioned for the first question. is it possible to get those eliminated records without using another 'INCLUDE or OMIT' condition in the jcl so that i can write the eliminated records in a separate file.

please advice on this.

thanks in advance

waves

[vkphani]

[vivek1983]

waves,

Following is my suggestion:

1. Use SORTOF01, SORTOF02 instead of SORTOUT. S0RTOF01 represents the excluded file. SORTOF02 represents the included file.

2. You could use the below card:

[waves]

Hi vivek,

thanks for ur valuable reply.

i have tested the job using the suggestion given by you.

but the job got abended saying that there is a syntax error in the OUTFIL Statement.

this was the spool output:

SYSIN :
SORT FIELDS=COPY
OUTFIL FILES=01,OMIT COND=((260,14,CH,EQ,C'00000000000000'),OR,
*
(188,13,CH,EQ,C' '))
*
OUTFIL FILES=02,INCLUDE COND=((260,14,CH,EQ,C'00000000000000'),OR,
*
(188,13,CH,EQ,C' '))
WER268A OUTFIL STATEMENT : SYNTAX ERROR
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER268A OUTFIL STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000

[vivek1983]

waves,

I was wrong on the syntax. Regrets...

Try the below sort card:

[waves]

Hi vivek,

ya it worked!!! thanks a ton!!...

now i got my required output.

thanks,

waves