If you are not using committment control make sure that the COMMIT 
parameter on the CRTSQLRPG is set to *NONE.   *CHG is the default and 
will cause the SQL statements not to execute if committment control is 
not being used on the file.


Rich Dotson
RT3 Consulting Services, Inc.
P.O. Box 126
Lorain, OH  44052-0126

Phone: 1-216-556-1710
eMail: rich_dotson@hotmail.com  or
       rich_dotson@centuryinter.net


>Date: Fri, 11 Sep 1998 18:17:46 +0500
>To: RPG400-L@midrange.com
>From: Pavan Krishnamurthy <pavankri@wipsys.soft.net>
>Subject: RPG/400 !!
>Reply-To: RPG400-L@midrange.com
>
>Hi,
>
>1)     I tried an embedded SQL program, but it was not working as I 
intended it
>to. The code I wrote looked somewhat like (program is of the type 
SQLRPG) :
>
>C/EXEC SQL
>C+ INSERT/UPDATE/DELETE INTO/FROM TABLE-NAME
>C+.......................
>C/END-EXEC
>
>Now the problem is that the program is compiling properly, but it is 
not
>updating, inserting or deleting from the particular table. Do I have to
>change the compiler options somewhere ? 
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].