| SQL script - Start command [message #368157] |
Fri, 15 September 2000 11:09  |
Chella
Messages: 25
Registered: September 2000
|
Junior Member |
|
|
I have a .sql file (Trans.sql) as follows;
spool TransEPOCREC.txt
SELECT TransCode|| ',' ||TransDateDays FROM tblMailBoxData
WHERE TransCode = 11;
spool off
The Trans.sql file is stored in say c:\bsp folder.
When I goto SQL> and type start c:\bsp\Trans.sql, it gives me error. Then I typed start Trans.sql and still it does not work.
Would anyone know why ? Should I store the .sql file in any particular folder ?
Help appreciated.
|
|
|
|
|
|
| Re: SQL script - Start command [message #368160 is a reply to message #368157] |
Mon, 18 September 2000 04:31  |
Chella
Messages: 25
Registered: September 2000
|
Junior Member |
|
|
Hi,
Thank U for your suggestion. I tried it as
start @c:\bsp\Trans.sql and still get an error saying 'Unable to Open file "@C:\BSP\Trans.SQL"'. Any other suggestions or am I missing something here ? Help appreciated.
Chella
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
