Steve Brett wrote:
> How would i write a transaction block in Sapdb ? > > In Postgres i could fire sql commands in in the format: > > begin work; > select yadda from yaddayadda; > commit work; > > but sapdb doesn't seem to like multiple line queries > sepaerated by ;s in the > sql manager. > > how would i seperate the lines in a transaction blobk if i > wanted to send it > in via odbc or jdbc ? You are always in a transaction block. If you start a session / connect to the database, your first transaction is started implicitly. If you close one transaction with commit / rollback, the next transaction is opened implicitly. Do you mean the SQLStudio with sql manager? This tool has the option to 'AUTOCOMMIT' every single statement. Therefore no explicit commit is necessary. For other tools: I hope you will receive answers by other guys. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
