It happens occasionally that the same SQL string will behave differently depending on the SQL mode or the programming interface. The script ftp://ftp.sap.com/pub/sapdb/misc/sapdbmodes.py allows to test for these variations by executing the same command in all the combinations of SQL mode (internal, oracle) and client mode (ODBC, JDBC, C/C++ Precompiler, dbmcli, Python).
The Python included with SAP DB is sufficient to run this script (see head of script for details). There are still a few differences this script can't detect: - the programming interfaces differ in the way they detect whether a command returned a result set - some SQL strings are changed by the interface library because of statement options (e.g. for updatable result sets) Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
