Re: Calling an sqt routine from an sqt routine

[Arun Kumar <arunkumar13@YAHOO.COM>]

Andrew,
you could pass the connection parameters and the input
parameters as a part of the commandline parameters so
that you dont have manually enter them.
A typical commandline would look like this

\...\sqrwt.exe ...\sqr\test.sqt scott/tiger@prod
param1 param2 etc.,


--- Andrew Rivers <andrew.rivers@CWCOM.NET> wrote:
> Hi
> I have a requirement to use call an sqt routine from
> an sqt routine.
>
> Fine - I can use the call statement with sqrwt.exe
> and include the sqt program as the argument.
>
> The problem is that in addition I need to log onto
> the database for the called sqt routine.
> The database log on dialog box is displayed - I then
> manually enter the database connection strings and
> the called sqt routine runs.
> I also need to include the database connection
> string as an argument when the sqt routine is called
> using the call statement.
>
> Further, the first sqt routine takes an input.
> I need to pass this input to the called routine in
> the call statement - so another argument will need
> to be passed.
>
> I have tried everything that I can think of - I'm
> close but just cannot quite make it...
>
> If anyone has any ideas or suggestion that I caoud
> try then I would be most grateful for suggestions...
>
> Andrew


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/