Hello,
you can use:
EXEC SQL COMMIT WORK;
to commit your changes without releasing the connection.
If you use: 
EXEC SQL COMMIT WORK RELEASE;
your changes will be commited and the session will be released.

Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Donnerstag, 21. Februar 2002 10:16
> To: [EMAIL PROTECTED]
> Subject: C/C++-Precompiler: COMMIT command available?
> 
> 
> Hi,
> 
> is there the COMMIT command (analogon to the COMMIT of SAP 
> DB's SQL-PL) in the C/C++-Precompiler language available? If 
> not is it possible to use the 'COMMIT WORK RELEASE' command 
> which the precompiler user manual demands as completion of 
> the dynamic SQL
> in a precompiler encoded program?
> 
> Thanks in advance!
> Frank Schimmelpfennig
> 
> PHILIPS Semiconductors Hamburg
> ATO-PICTOH  IT&DataSupport
> Tel.: +49 40 5613 -1835, Fax: -3020
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to