|
-
Hello,
Thanks a lot for the reply. It's OK for the solution.
Another question :
I would like to avoid to 'hard code' with the Spool command the file path. Is it possible to generate the file in the directory of the first script. In other word :
Suppose that my first script (script_0.sql) is the following :
Set linesize 120
...
...
Spool CURRENT_DIRECTORY\Query_result.txt
@CURRENT_DIRECTORY\script_1.sql
Spool off
I would like to replace what I called CURRENT_DIRECTORY by something in order have script_1 and result in directory in which script_0 was stored (Machine independant).
Thanks
Sofiane
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|