On 20/06/07, Jose Luis Levieux <[EMAIL PROTECTED]> wrote:
Hi , I want to run a report from crontab.. I have the report in a file but the problem is that it need a parameter. How can I send the parameter to the report? I find this in the documentacion exec sql call report (database = 'newdb', report = 'myrpt',param = :parmvar); The variable, parmvar, must contain the value: bin="f01" wstation="u1" type=12 sect=11 But I need to do it in the command line. Thanks. José Levieux
At the command line report newdb myrpt "(bin='f01',wstation='u1',type=12,sect=11)" Note that there's double quotes around the parameters as a whole and single quotes around the string values. If you're running this from cron you need to make sure that II_SYSTEM and your PATH are set - so you'll probably need a little wrapper script. -- Paul Mason
_______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
