Hi Philipp, you wrote : > I can't seem to issue valid SQL statements with SQL Studio > (DB 7.3.0.21) in > general. I don't know if I'm missing something but as the > TEST User I created > some tables via CatalogManager->New->Table which are now listed under > Tables->TEST->Table1 etc. > > Now, many valid SQL statements like "SELECT * FROM > TEST.Table1" or "SELECT * > FROM Table1" (when connected as the TEST user) fail in the > "Direct SQL" window > with > > Negative Error No.: -4004 > Error Text: Base table not found;-4004 POS(15) Unknown table > name:TABLE1. > Return code: -1 > SQL State: [ODBC] [S0002] Base table not found
you created a table named 'Table1' (SQLStudio allows you to specify mixed case identifiers in create dialogs unless you turn this off in the 'settings'). You selected from 'TABLE1' with your sql statement, because identifiers in statements are uppercased by the db kernel unless they are enclosed in doublequotes : SELECT * FROM "TEST"."Table1" should succeed. The referential constraints : it is very unlikely that we release a bugfix in the next two weeks. Try to create (graphically, in SQLStudio) an FK referencing an explicitly defined index and use the 'export to direct sql' function of the context menu (right mouse button on the create/alter table dialog to export this to an sql window. Use this as a template. regards, Markus Stausberg SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
