Re: update statement

The following web page will be of assistance to you
http://www.itjungle.com/mgo/mgo100303-story02.html
The problem is that NOT all records exist in both files.
Using COALESCE (see web page) should rectify this



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx


                                                                       
             "Jszarlik"                                                
             <jszarlik@xxxxxx>                                         
             Sent by:                                                   To
             rpg400-l-bounces@         "rpg400-l@xxxxxxxxxxxx"@mail.midran
             midrange.com              ge.com                          
                                                                        cc
                                                                       
             06/21/2006 11:38                                      Subject
             AM                        update statement                
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the AS400 /                                           
                  iSeries                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




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.