Re: update statement

you need to match your file on the outside of the parens..something like: 

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)
where exists 
 (SELECT 1 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)

-----Original Message-----
From: bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx]On Behalf
Of Jszarlik
Sent: Wednesday, June 21, 2006 10:35 AM
To: .
Subject: [BPCS-L] 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