bonjour Philippe,

you can use xsql like in the following example:

xsql -u TEST,TEST -d TST -k -b "select owner,tablename from tables where owner 
= 'TEST'"

or with a sql-script-file as input

xsql -u TEST,TEST -d TST -k -b < test.sql

Regards,
Michael

Am Samstag, 27. September 2003 11:56 schrieb jean-michel OLTRA:
> Le vendredi 26 septembre 2003, Philippe a �crit...
>       bonjour,
>
> > Is there a way to execute a SELECT statement with a command line tool.
> > I've tried with "loadercli". It answered me that everything was "OK", but
> > there was no output data... (I excepted the result of my SELECT query to
> > appear on the screen in a text format...).
>
> I use dbmcli which can call select statements and get result, but not
> get any resultset whith a dbproc call (but ok !)
> syntax:
> dbmcli -d database -u dbm,dbmpasswd -uSQL user,passwd -c "sql_execute stmt"
> --
> jean-michel


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to