[sapdbapi] paramstyle

[Oliver Vecernik]

Hi!

I'm writing a small test utility to evaluate some open source db's (MySQL, PostgreSQL, SAP DB and SQLite). This is my first time playing with the new DB-API 2.0 and I must say, it's *not* portable between db's (I think I'm not the first person who found out ;-) ). Besides of differences between SQL modes also the paramstyle is different.

My first question is: why does sapdbapi only support 'named'? All other db's support 'pyformat'.
Second question (not sapdbapi specific): why is there no 'BEGIN' for a transaction? As far as I found out a transaction is automatically started after a commit or rollback, but isn't 'BEGIN' specified by SQL-92?

Best Regards,
Oliver

--
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general