Christoph Langguth wrote: > But I still have a few questions, probably easy to answer: > > 1. why doesn't sapdb like my statement separators? > "select * from users" works, "select * from users;" doesn't: > [SAP AG][LIBSQLOD SO][SAP DB]Syntax error or access > violation;-3014 POS(20) Invalid end of SQL statement. > It gives me this in both cases: when I use the web > administration tool, and when I use ODBC. > Is there something I missed?
As far as I know exactly one SQL-statement can be put into one ODBC-call, for example an SQLExecDirect. And all complete ODBC-call have to be separated by ';'. But only within definition of dbprocedures/triggers semicolon may be part of a SQL-statement. No ';' has to be given at the end of normal SQL-statements. If you put this semicolon at the end of a SQL-statement, i.e. IN the ODBC-call then it is send to the kernel which dislikes such extra signs. > 4. Can I actually _do_ anything as the user "domain"? > I have tried logging on as different users, including > "domain". This one is strange because it doesn't get the > fancy menus and all, just a plain SQL input window. And all I > can do is select etc. (no updates/inserts...). So what is > this user for?... This is a user for holding several of those systemtables, who should not be used for real users work (creation of tables or something like this). Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
