Re: SQL0312 on UPDATE but not on INSERT

["Peter Dow" <maillist@xxxxxxxxxxxxxxx>]

Hi Sur,

If by transition variable you're thinking this is a trigger program, it's
not.  It's intended to read remote journal entries and update the
corresponding file.  And keep in mind, the INSERT stmt compiles without
error.  I appreciate the thoughts though.

Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
951 522-3214 cell



----- Original Message ----- 
From: "Suresh Moda (EAI - JD Edwards)" <suresh.moda@xxxxxxxxx>
To: "'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, April 12, 2005 11:54 PM
Subject: RE: SQL0312 on UPDATE but not on INSERT


> Hello Peter,
>
> I could guess that the error is that, the variable is an OLD transition
> variable and cannot be modified.
>
> So we can try by Specifying a NEW transition variable when the variable is
> modified in an SQL trigger.
>



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.8 - Release Date: 4/13/2005