Hi Stephen Sorry for the delay ...
> -----Original Message----- > From: Stephen Gutknecht (SAPDB) [mailto:IML-sapdb@;i405.com] > Sent: Mittwoch, 16. Oktober 2002 17:29 [snip] > I'm confused how one can get EXPLAIN output from a ODBC > client program. I > am trying to automate performance study of my queries... > > I get no result on my "EXPLAIN SELECT * FROM myTable WHERE > FIELD1 IS NOT > NULL" statements. The statement executes without error, but > I do not get > any result tables/rows. I am executing the statement just > like I would a > "SELECT"... > > Based on hints from the archive, I have also tried doing a > "SELECT * FROM > SHOW" immediately following my EXPLAIN statement, but I get > an error about > no SHOW table. Hm, this is exactly the way it should work. Just I checked it without problems. What happened if you send the explain-statement in SQL Studio? Does it also return nothing? Greetings Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
