|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.