Re: Embedded SQL does not work

Mark:

Was the file journaled for which you were doing the delete?  Most of the times
the error is not generated but joblog will have some inane sql return code.
The bottom line is it will not do what you tell it to do if you do not have the
file journaled and the compile with commit(*chg) which is the default option.
HTH

Mark Lazarus wrote:

> Dave,
>
> At 01:42 PM 1/15/99 -0500, you wrote:
>
> >I think it has to do with journaling.  Since, commitment control requires
> >journaling and if you do not have journaling on a file, update fails.  I
> >usually compile with Commit(*none) on non-journaled file for
> >update/delete/insert.   Of course, this has no impact on a select.  I hope
> >others in the list will confirm or deny?
>
>  I found it interesting that no error was generated and when I tried
> running COMMIT on the command line after the program finished the DELETEs
> were not applied.
>
>  -mark
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> * 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          *
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *