FW: New to SQR and need help

["Aultman, Steven (SMAU)" <SMAU@CHEVRON.COM>]

Bill,

I'm in a similar environment, SunOs and Sybase 11.  Try wrapping a shell
script around your SQR call.  Have the the shell script prompt for the db
version, then pass the version as a parameter on the SQR command line.  In
the SQR, use the "ask" command to pick up the (perhaps call it "dbname")
parameter and then use "use {dbname}".

HTH

Steve Aultman
CITC

> -----Original Message-----
> From: Doc Iceman [SMTP:B_J_R@EMAIL.MSN.COM]
>
<snip>

> I'm trying to determine if it
> is possible to use the same SQR files to generate reports for all
> versions of DB1. I have to avoid using multiple copies of the SQR files,
> so
> I can't just make a copy of the SQR file and change the name of the
> database
> in the use statement.  Is it possible to use a variable in the use
> statement
> such as  use {variable name}  so that depending on which ever database the
> user logs on to, the correct database name will be supplied to the SQR
> file
> that generates the particular report the user wishes to print.  Any help
> to
> this question is greatly appreciated.
>
> Bill Reestman
> b_j_r@msn.com