RE: sql_execute with user_spec

[Werner, Marc-Philip]

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: maxdb@lists.mysql.com
        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