|
Neeraj, There are not two variables. There is one variable and a null indicator. This is why the "two" variables are not separated by a comma. You just use a space to separate a null indicator from it's field. When you use null capable fields you have to send whether or not the field is null in a null indicator field. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com "Neeraj Sarougi" <neeraj.sarougi@xxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 04/13/2005 01:42 AM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> To "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx> cc Subject RE: SQL0312 on UPDATE but not on INSERT I Guess your syntax for update is wrong... c+ Update BATCH c+ Set Field1= :JrnBATCH ,field2= :NULLindI c+ Where rrn(BATCH) = :@JrnRRN Some thing like that... -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Dow Sent: Wednesday, April 13, 2005 11:57 AM To: RPG400-L@xxxxxxxxxxxx Subject: SQL0312 on UPDATE but not on INSERT Hi Everyone, I have the following code in an SQLRPGLE program: ------------------------------------------------------ d JrnBATCH e ds extname(BATCH) d NULLindI s 5i 0 dim(006) c Select c When @JrnEntryType='PT'c/exec SQL c+ Insert Into BATCH c+ Values(:JrnBATCH :NULLindI) c/end-exec c When @JrnEntryType='DL' c/exec SQL c+ Delete From BATCH c+ Where rrn(BATCH ) = :@JrnRRN c/end-exec c When @JrnEntryType='UP' c/exec SQL c+ Update BATCH c+ Set ROW = (:JrnBATCH :NULLindI) c+ Where rrn(BATCH ) = :@JrnRRN c/end-exec c EndSl ------------------------------------------------------ The fascinating thing is that the INSERT stmt compiles, but not the UPDATE. The precompiler complains: SQL0312 30 70 Position 26 Variable JRNBATCH not defined or not usable. Any ideas why? Peter Dow Dow Software Services, Inc. 909 793-9050 voice 909 793-4480 fax 951 522-3214 cell -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 4/12/2005 -- 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. -- 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.
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.