> When I try to use explain in a dbmcli session nothing much happens: > > /opt/sapdb/indep_prog/bin/dbmcli on ZDB>sql_execute explain SELECT > sum(amount) FROM "transaction" WHERE target_account_id=1234
They are two techniques to detect if a SQL statement returns a result set: - checking whether the reply packet contains a 'result table name' part - checking the function code The dbm server seems to use the latter method and forgot to add the function code for EXPLAIN. (The function codes are declared in vsp001.h) Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
