Sort O/P with selection and SORT

nivasaya · New User Joined: 03 May 2007 Posts: 27 Location: India

Dear Team,

I need to select only the accounts with below criteria

SORT FIELDS=COPY
INCLUDE COND= (11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’)

and as well as Sort the output based on

(1,3 and 4,19)

Please let me know if we can combine both the steps.

Thanks & Regards,
Nivasaya

expat · Posted: Thu Jun 11, 2009 4:54 pm

Yes, substitute the FIELDS=COPY with the fields that you wish sorted.

nivasaya · New User Joined: 03 May 2007 Posts: 27 Location: India

Thanks Expat. Also please let me know the following senario:

I Need to include 3 conditions:

1) SORT FIELDS=(1,22,CH,A)

2) INCLUDE 11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’
3) OMIT 1,1,CH,EQ,C’3’,AND
7,5,CH,NE,C’00003

Please let me know if this is fine:
SORT FIELDS=(1,22,CH,A)
INCLUDE COND =(11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’)
OMIT COND= (1,1,CH,EQ,C’3’,AND
7,5,CH,NE,C’00003)

Thanks & Regards,
Nivasaya

And SORT GMAD-PRIMARY-CMS-ORG and GMAD-PRIMARY-CMS-ACCT

To O/P file SORTED GMAD file.

AND eliminate AMEX accounts as well.

Arun Raj · Posted: Fri Jun 12, 2009 11:26 am

nivasaya,

I dont think you can code both INCLUDE and OMIT together. And I wonder how you expected somebody here to know how to sort "GMAD-PRIMARY-CMS-ORG" and "GMAD-PRIMARY-CMS-ACCT" and eliminate "AMEX accounts".

Post some more info which makes some sense like field-positions, field lengths, field formats and keywords to identify and process records selectively.

nivasaya · New User Joined: 03 May 2007 Posts: 27 Location: India

Sorry ARCVNS

I need to do the following conditions:

1) SORT FIELDS=(1,22,CH,A)

2) INCLUDE 11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’
3) OMIT 1,1,CH,EQ,C’3’,AND
7,5,CH,NE,C’00003

Please ignore the other info, which is irrelevent.

Thanks & Regards,
Nivasaya

Skolusu · Posted: Sat Jun 13, 2009 1:31 am

nivasaya,

Try these control cards

gcicchet · Posted: Sat Jun 13, 2009 8:43 am

Hi Skolusu,

how does the omit come into your example ?

With your example nothing will ever be selected as byte 11 cannot be both a 3 and an A.

Gerry

Skolusu · Posted: Sat Jun 13, 2009 8:53 am

gcicchet,

The omit cond is looking for pos 1 , not pos 11

gcicchet · Posted: Sat Jun 13, 2009 9:08 am

Hi Skolusu,

doesn't

Skolusu · Posted: Mon Jun 15, 2009 10:12 pm

gcicchet,

I was merely trying to replicate the sort cards provided by OP and failed to notice the overlapping fields. sorry about that.