RE: update statement

That means that when the SQL finds the record in the subselect (file APH), the 
value in field APIRDT is null.  Apparently, file ATX does not allow null values 
in the field TXIDTE, so it throws the error message.

You either need to change the value of the field in file APH, or change file 
ATX to allow null values in the field.

Dawn Siegrist

-----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