Hi, for xsql it's not necessary to use the // as line separator. Use only <CR><LF> to separate your commands as you type as the command prompt.
'sql-file' select * from testtable create table test2 (nr smallint, name char(50)) insert into test2 values (1, 'hello') select * from test2 Regards Burkhard -----Original Message----- From: Danny Tramnitzke [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 3:59 PM To: [EMAIL PROTECTED] Subject: RE: execute sql-file on sapdb 7.4 Hi I have found the programm xsql and I have to start it with ./xsql , but it works.. To connect to a database i have to type the following: ./xsql -d <database> -u <username>,<userpass> then I can make my statements like "select * from <table>" , but I'm not able to import a sql-file containing several sql-statements yet. To import a sql-file I have to type : ./xsql -d database -u username,userpass < file Also that works, but when I make more than one statement in that sql-file, the Programm isn't able to execute them. A sql-file with the following content: select * from testtable // create table test2 (nr smallint, name char(50)) // insert into test2 values (1, 'hello') // select * from test2 didn't work. Also, when I substitude the "//" by ";" So, what form must the sql-file have to be executeable? Danny > Danny Tramnitzke wrote: > > > > > So there is no according option with dbmcli? > > > > Where can I type 'xsql -h' ? It's no option of dbmcli ... > > > > Danny > > xsql is a client-tool like dbmcli, not part of dbmcli... > > Elke > SAP Labs Berlin > > > > > > > Hello Danny, > > > you can use xsql from the command line. > > > You can use it to get the commands from STDIN 'xsql < sql-file' > > > For more explanations about xsql use the -h option. > > > > > > Regards, > > > Burkhard > > > > > > > > > -----Original Message----- > > > From: Danny Tramnitzke [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 06, 2003 10:33 AM > > > To: [EMAIL PROTECTED] > > > Subject: execute sql-file on sapdb 7.4 > > > > > > > > > Hi all > > > > > > How can I execute a sql-file with several statements from > > linux command > > > line? > > > So I have access to the database with dbmcli but then I > > want to make a > > > number of sql-statements without type them in again and again. > > > > > > > > > Danny > > > > > > -- > > > +++ GMX - Mail, Messaging & more http://www.gmx.net +++ > > > NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen! > > > > > > _______________________________________________ > > > sapdb.general mailing list > > > [EMAIL PROTECTED] > > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > > > > -- > > +++ GMX - Mail, Messaging & more http://www.gmx.net +++ > > NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen! > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
