RE: [sqr-users] Executing a Stored Procedure on a different database

["Mac Sandridge" <mes3@emcc.net>]

> The way our production environment is setup the command line is
> built from
> a standardize kornshell.  It is possible for me to do by deviating from
> this put I'll have to pull some strings.  First I would like to explore
> other ways perhaps using a compiler directive to read the environment
> variable and make the substitution.
>
> Any reason way the use of the square brackets substitutions doesn't work
> like it does in a begin-sql paragraph.  Is this issue related to why the
> square bracket substitution doesn't work in begin-select paragraphs.

Ok, do you connect to the database on the command line?  You do not have to
specify the server or database if you do.  We made all of our calls to
"SPName" for our stored procedures compiled on several different Databases
and/or servers.  For example:

    execute @#_gnvCPAProcReturnStatus=hsp_sel_hcpa_common_agent_info

for calling a stored procedure.  We call the SQR with -vSERVER -dbDATABASE
parms to force the server and database connection.

I hope this helps!

Mac

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users