×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Your EXISTS clause has to query the same file your update subquery clause
does. In fact, they really ought to be identical (i.e. copy the update
subquery clause into the EXISTS subquery clause).
You have 2 different files now: SRCEXPIRE and XPIRESRCE.
HTH, Elvis
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
Subject: SQL and NULL
Is there a way to see if a field is null?
I am trying the following SQL script
UPDATE SRCMSTP B SET B.XTRAFLD07
= (SELECT A.EXPIREDATE
FROM AXSLIB/SRCEXPIRE A
WHERE A.XCATCD=B.LCATCD and A.EXPIREDATE <> ' ')
WHERE EXISTS
(SELECT * FROM AXSLIB/XPIRESRCE A
WHERE A.XCATCD=B.LCATCD and A.EXPIREDATE <> ' ')
but I get the response
Null values not allowed in column or variable XTRAFLD07.
Now, I have run a seperate SQL to blank the field XTRAFLD07 in ALL the
records, but I still get the same response
Anybody see whats wrong with my UPDATE?
Thanks in advance
Alan Shore
As an Amazon Associate we earn from qualifying purchases.
This thread ...
Re: ODBC exit point removed; by whom?, (continued)
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
