Re: Passing argument from plus33.

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Fri, 10 Sep 1999 11:17:16 -0400
Message-ID: <37D920FB.AEBEAD0@fmr.com>

Use &1 inside a SQL script. This in fact is a special kind of SQLPlus's substitution
variable.

Regards,
Karen Abgarian.

screwbai_at_my-deja.com wrote:

> I am running test.sql. I want it to spool the output to the directoy
> that I have as argument 1 in the pluss33 line. However it is unable to
> pick up the $1 variable inside the test.sql. Is it possible. What do I
> have to do. Thanks.
>
> plus33 -S login/passwd_at_dbs @test.sql E:/prod
> ^
> |
> test.sql: |
> |
> |---------------------------------|
> |
> SPOOL $1/run_qabatch.sh
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Sep 10 1999 - 10:17:16 CDT