Re: "source" command problem

2001-11-29 Thread Paul DuBois
At 10:33 AM -0800 11/29/01, Shankar Unni wrote: >sherzodR wrote: > >>Well, Paul, i think he means using source in an .sql script. >>Yes you can, Shankar. I used it several times for several reasons :) >> >>And u can envoke your sql script the same as you use your other >>scripts. >> >>[EXAMPLE] >>

Re: "source" command problem

2001-11-29 Thread Shankar Unni
sherzodR wrote: > Well, Paul, i think he means using source in an .sql script. > Yes you can, Shankar. I used it several times for several reasons :) > > And u can envoke your sql script the same as you use your other > scripts. > > [EXAMPLE] > [...] > -- in source.sql file: > > source query.s

Re: "source" command problem

2001-11-28 Thread sherzodR
Well, Paul, i think he means using source in an .sql script. Yes you can, Shankar. I used it several times for several reasons :) And u can envoke your sql script the same as you use your other scripts. [EXAMPLE] -- in query.sql file: CREATE TABLE ( id INT, value CHAR(30) ) -- in source.sql

Re: "source" command problem

2001-11-28 Thread Paul DuBois
> > database,sql,query,table > > >I notice that "source" is only accepted at the *command line*. This >means that I can't source a script that sources another file. > >I guess "source" is implemented in some special way that prevents it >from being recursively used? > >Is there a way to do what

"source" command problem

2001-11-28 Thread Shankar Unni
> database,sql,query,table I notice that "source" is only accepted at the *command line*. This means that I can't source a script that sources another file. I guess "source" is implemented in some special way that prevents it from being recursively used? Is there a way to do what I want (ha