Re: Problems with NULL and UPDATE in OCI programs

In article <51u3g0$4ij6_at_news-s01.ny.us.ibm.net>, sysnet5_at_ibm.net wrote:
>I have an OCI program that acts like this:
>
>1) Parse an UPDATE statement;
>2) Bind variables;
>3) Loop obtaining records and processing the UPDATE.
>
>Moving "-1" to indicator variables is not working when the corresponding
>variable is referenced in "Where" Clause.

you cannot successfully use the form WHERE COLUMN=:X when the indicator on X declares it to be a null value. you can only compare to a null value by using the forms WHERE COLUMN IS NULL or WHERE COLUMN IS NOT NULL.

Dave Mausner, Managing Consultant, Braun Technology Group, Chicago. Received on Wed Oct 02 1996 - 00:00:00 CEST