Hi Moro, [EMAIL PROTECTED] wrote: > > I tried to use xsql. On my Windows installation the following line works > fine > > >xsql -u dba,dba -d tst > > but not on my Linux box I get the following error > > * -709: CONNECT: (database not running) > > The database is definitifly running (Checked it from Windows with > DbmGUI)! > > Can someone give me a hint?
xsql is a very old tool (written in sqlpl as far as I know) and don't expect to find it also in every of the next releases. From the first plans it shouldn't be there any more some releases ago :-)... Everything in the future has to be done with SQL-Studio or dbmcli direct: dbmcli -d <SID> -u <controluser>,<controluser-passwd> -uSQL <SQL-user>,<password> sql_execute "select * from users" The Output is something like CSV and therefore the columns are separated by ';'. BTW, as long as xsql exists: you can not specify a database in the command. It is only using the xuser data and the database defined in there. So the equivalent to the dbmcli command above is xsql "select * from users" The xuser data can be set up with the tool xuser. There you can store usernames and the corresponding password for specified databases and tools are using there data sets to login to that databases. Ciao Ralf __________________________________________________________________ Dr. Ralf Czekalla mailto:[EMAIL PROTECTED] _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
