Re: Embedded SQL does not work

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Silvio,

Based on the message I would guess that you do not journal the file(s).  If 
this is 
the case you need to journal the file or change the COMMIT keyword on the 
CRTSQLRPG to *NONE.  In any case you should be able to determine the 
exact cause of the problem by looking in the joblog for the message SQL7008.  
It should show a reason code which will explain why you got the message.  To 
display the SQLERM you can also append the SQLCOD to SQL and display 
the message description in QSQLMSG.

David Morris

...But the update is not working. I also tried to run the debug an I saw that 
the sqlcod is with the value = 0 before the update, but after it contains -7008,
I also tried to see the sqlerm but it appears strange things. 
I tested an equivalent update in the command line of the STRSQL and it works, 
so what can be wrong ?

Silvio.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *