On Saturday 27 September 2003 11:56, jean-michel OLTRA wrote:
> 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"
Well, probably this works - but I was told, that using dbmcli for everyday SQL
usage should not be used by a SAPDB developer (Daniel Dittmar). Here is my
question and his response:
--------------------------- snip ------------------------
> 1) In ADABAS-D I had some scripts for creating the
> tables/users. For this I
> piped the sql-commands in a program called "xquery" - this
> seems to be not
> available with SAPDB. How would someone do this with SAPDB? I
> saw that "xsql"
> is "back" (this tool was available in former ADABAS-D
> distributions and we
> used this before xquery) but I don't know if "xsql" will
> remain in future
> SAPDB-verions. So - should I use "dbmcli" instead? Or the new
> "loader"? Or
> write python.sql/loader scripts?
The official batch tool is the loader.
xsql will remain in the distribution for some time, but isn't
really dsigned for batch sql.
dbmcli shouldn't be used for SQL at all because it uses
a special SQL mode.
Python scripts would be your choice if you have to to something fancy
like elaborated error handling, variable substitution or creating
ALTER TABLE statements on the fly.
---------------------- snip --------------------------
Best Regards,
Hermann
--
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
