How do you pass parameter when running a sql script

How do you pass parameter when running a sql script

 

  

> Hi Gurus,
> It is abit fustrating that IBM does not provide infos about things...I am
> from Oracle background.
> How do you pass certain parameter to a sql script being called by DB2 ??
>
> example:
> connect to <dbname> user <username> using <password>
>
> I want to pass these 3 parameters to my sql script:
>
> ### script ##
> connect to %1 user %2 using %3 ;
> ...
> more sql statements
>
>
> ## end of script ###
>
>
> This is urgent, please advice.
> Regis
>
>
>
>
>
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page