Hi Alexey,
you could schedule a
dbmcli -u <dbmuser>,<dbmpass> -d <dbname> -uSQL [<sqluser>,<sqlpass>] -c
sql_execute select count(*) from dual;
As you can see, sqluser and sqlpass are optional. If you leave that out, the
system administrator's account is used.
For arbitrary command sequences you must schedule the execution of an input
script, e.g.
dbmcli -u <dbmuser>,<dbmpass> -d <dbname> -i <inputfile>.
Please look up the documentation at
http://dev.mysql.com/doc/maxdb/en/default.htm
<BLOCKED::http://dev.mysql.com/doc/maxdb/en/default.htm> for the details.
Regards,
Marc-Philip
________________________________
From: Alexey Gaidukov [mailto:[EMAIL PROTECTED]
Sent: Dienstag, 10. Januar 2006 01:37
To: Werner, Marc-Philip
Cc: [email protected]
Subject: Re: sql_execute with user_spec
I want to execute sql statement from sql user in scheduler. How can I
do this?
Thanks in advance,
Alexey Gaidukov.
Werner, Marc-Philip пишет:
Hi Alexey,
Maxdb 7.6.00.16 Linux. From dbmcli documentation
sql_execute <user_identification> <statement>
*<user_identification> :: = <user_spec> | <user_type>*
*<user_spec> :: =
<database_user>,<database_user_password>*
*<user_type> :: = user-type=<value>
*
The documentation is wrong and will be fixed. The option
<user_spec>
does not exist. The option <user_type> does work though.
Sorry for the inconvenience.
Regards,
Marc-Philip
