Try http://www-3.ibm.com/software/data/db2/library/

> -----Original Message-----
> From: Regis Biassala [SMTP:Regis.[Email Address Removed] Sent: Thursday, January 16, 2003 4:44 PM
> To: [Email Address Removed] Subject: 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.
> **********************************************************************
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> To unsubscribe, e-mail: db2udbdba-[Email Address Removed] For additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page