RE: update statement

Jarek

The select part of your statement is returning an empty result set which
in turn is translated to null by the set part of the statement.

Option 1.

In your RPG program you could put a in a updatable cursor that would
select records from ATX that have a match in APH.  In the do while loop
you would have an update statement for ATX where the record is equal to
the current cursor. 


Option 2.

Modify your update statement to have a where clause for the update
portion of the statement.

Andrew
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jszarlik
Sent: Wednesday, June 21, 2006 11:39 AM
To: "rpg400-l@xxxxxxxxxxxx"@mail.midrange.com
Subject: update statement

Hello,
I would like to update one field in ATX file and I try to use SQL.
The SQL statement is following:

UPDATE ITSKCTST83/ATX SET ATX.TXIDTE
= (SELECT APH.APIRDT FROM ITSKCTST83/APH WHERE ATX.TXVNDR=APH.APVNDR AND
ATX.TXINV = APH.APINV AND APH.PHDCYR = ATX.TXDCYR AND ATX.TXDCPX =
APH.PHDCPX AND ATX.TXDCSQ = APH.PHDCSQ AND ATX.TXCOMP = APH.APCMPY)

but I receive message:

Null values not allowed in column or variable TXIDTE

could anybody explain it and how to resolve it?

Thanks in advance
Jarek

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
Note: This message, including attachments, is from H&R Block Financial Advisors,
Inc., Member NYSE, SIPC. This is not a solicitation of any order to buy or 
sell. The
information contained herein is deemed to be reliable but is in no way 
warranted by us as
to accuracy or completeness. Messages are monitored and retained by the 
Company, but
the company cannot guarantee the security of this message. The company, and its
associates, may not accept orders to affect purchase or sale transactions, 
accept funds,
securities, or similar instructions via email. If you are not the intended 
recipient of this
message promptly delete this message and notify the sender of the delivery 
error by
return email or calling 1.800.HRBLOCK and selecting the option for 'Financial 
Services'
You may not forward, print, copy, distribute, or use the information in this 
message if
you are not the intended recipient.