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
