Re: sql procedure code fails on V7R4

pretty sure it has to do with the SQL query optimizer evaluating all the
WHERE OR rules in parallel.

the failing code does this:
WHERE ( INSEQN = ' ' or INSEQN <> a.srcseq )

prior to V7R4 SQL would evaluate INSEQN = ' ', find it was true, and not
bother to evaluate INSEQN <> a.srcseq
now in V7R4, SQL is evaluating both sides of the OR at the same time.
Which could save time in the case where the first evaluation returns FALSE.

I had a similar case on a V7R1 system where I was comparing a character
parameter against DATE columns.
WHERE ( inDATE = ' ' or inDATE > a.shipDate )
I had to change the code to
WHERE ( inDate = ' ' or ( inDate <> ' ' and inDate > a.shipDate ))

-Steve