RE: SQL0312 on UPDATE but not on INSERT

Peter,

I question rather using RRN is going to work in a production environment.

Perhaps if this is a _VERY_ limited scope, but if you're trying to 
roll-your-own HA/DB sync....I'd be willing to lay money down that it'd be 
cheaper in the long run to buy a package to handle this.

As far as the original question....

What version are you on?

Just for comparison, have you tried specifying the individual fields & null 
indicators (it looks like you only have 6)?



Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Peter Dow
> Sent: Wednesday, April 13, 2005 11:56 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: SQL0312 on UPDATE but not on INSERT
> 
> 
> 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
> 
> 
> -- 
> 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.
> 
>