Re: Embedded Sql not writing records

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

IIRC... SQL Messages Reference


Doug Palme wrote:
> What is the name of the manual that lists out all of the SQL codes and 
> states...I thought it was the sql reference, but I have not been able to 
> find the chart in that one.....
>
>
>
>
> From:
> R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>
> To:
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> Date:
> 05/22/2008 04:42 PM
> Subject:
> Re: Embedded Sql not writing records
>
>
>
> A) What commit level is the program compiled with? If it is anything 
> other than *none, then you need to commit the data.
> 2) Are you actually executing the insert statement? Is it ever reached 
> in the program?
> iii) What is the value of SQLCODE or SQLSTATE after the insert? That 
> will tell you why the write failed, if it did fail.
>
> Doug Palme wrote:
>   
> > Ok, 
> > I have recompiled the program as an SQLRPGLE object and added the 
> > following:
> >
> >        insert into Pharmcd (Phacctno, PhDiv, PhVndno, Phcrmno, 
> >                             PhCrmdt, Phcrmamt, Phcrmddt, PhDocTyp, 
> >                             PhVndtrm, Phclccrd, PhOvrAmt) Values( 
> >                             :Wacctno, :Wacctdiv, :Wvndno, :Wcrdmno,
> >                             :Wcrdmdt, :Wcrdmamt, :Wduedt, :WDocTyp,
> >                             :Wvndtrms, :Wclccstcrd, :WOvrAmt); 
> >
> >
> > It compiles successfully, and runs without any errors, what it does not 
> > do, is write the data.....
> >
> > I have checked the values of the variables and there is data 
> > there.....suggestions?
> >
> >
> > This transmission may contain information that is privileged, 
> >     
> confidential 
>   
> > and/or exempt from disclosure under applicable law. If you are not the 
> > intended recipient, you are hereby notified that any disclosure, 
> >     
> copying, 
>   
> > distribution, or use of the information contained herein (including any 
> > reliance thereon) is STRICTLY PROHIBITED. If you received this 
> > transmission in error, please immediately contact the sender and destroy 
> >     
>
>   
> > the material in its entirety, whether in electronic or hard copy format. 
> >     
>
>   
> > Thank you.
> >
> >     
>
>