[Users] How can I send the parameter to the report ?

[Paul Mason]

On 20/06/07, Jose Luis Levieux <jlevieux at adinet.com.uy> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ingres.com/pipermail/users/attachments/20070620/0eb39849/attachment.html