Query regards INCLUDE COND

karthikr44 · Posted: Fri Jun 20, 2008 11:10 am

Hi,

The following condition is
INCLUDE COND=(558,02,CH,NE,C'PD,PF,X,G')

eqiuvalent to

(558,02,CH,NE,C'PD', OR
558,02,CH,NE,C'PF', OR
558,02,CH,NE,C' X', OR
558,02,CH,NE,C' G',) OR

Is there any single line statement to acheive

(558,02,CH,NE,C'PD', AND
558,02,CH,NE,C'PF', AND
558,02,CH,NE,C' X', AND
558,02,CH,NE,C' G',) AND

Regards
R KARTHIK

gcicchet · Posted: Fri Jun 20, 2008 12:17 pm

Hi,

it's not possible for the same field to have more than 1 value, it can only be an or.

Gerry

gcicchet · Posted: Fri Jun 20, 2008 12:22 pm

Hi,
my apologies, I read it as EQ and not NE

Gerry

gcicchet · Posted: Fri Jun 20, 2008 12:41 pm

Hi,
INCLUDE COND=(558,02,CH,NE,C'PD,PF,X,G') resolves to AND

ie. NE to PD and NE to PF etc.

Gerry

karthikr44 · Posted: Fri Jun 20, 2008 12:47 pm

Hi gcicchet,

U are saying that
INCLUDE COND=(558,02,CH,NE,C'PD,PF,X,G')

is equivalent to

(558,02,CH,NE,C'PD', AND
558,02,CH,NE,C'PF', AND
558,02,CH,NE,C' X', AND
558,02,CH,NE,C' G',) AND

Are u sure?

gcicchet · Posted: Fri Jun 20, 2008 12:54 pm

Hi,

I used INCLUDE COND=(1,3,SS,NE,C'350,375') for my test.

Gerry

karthikr44 · Posted: Fri Jun 20, 2008 12:55 pm

Because i am getting different output for

INCLUDE COND=(558,02,CH,NE,C'PD,PF,X,G')

RCD IN 914, OUT 413

and

(558,02,CH,NE,C'PD', AND
558,02,CH,NE,C'PF', AND
558,02,CH,NE,C' X', AND
558,02,CH,NE,C' G',) AND

RCD IN 914, OUT 312

gcicchet · Posted: Fri Jun 20, 2008 1:09 pm

Hi,
please note I used SS and not CH in my test.

Gerry

Garry Carroll · Posted: Fri Jun 20, 2008 1:11 pm

How about using substring?

karthikr44 · Posted: Fri Jun 20, 2008 1:33 pm

Hi gcicchet,

I corrected the mistake.

Also as Garry Carroll said whenever i include more than one condition like

INCLUDE COND=(558,02,CH,NE,C'PD,PF,X,G')

Then i have to use

INCLUDE FORMAT=SS,COND=(558,02,CH,NE,C'PD,PF,X,G')
[/quote]