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.sql
# or
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]
[...]
-- in
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 (have
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 (have
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