Home » RDBMS Server » Server Utilities » SQL script - Start command
SQL script - Start command [message #368157] Fri, 15 September 2000 11:09 Go to next message
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 #368159 is a reply to message #368157] Fri, 15 September 2000 12:11 Go to previous messageGo to next message
Isar
Messages: 3
Registered: July 2000
Junior Member
Chella, try @ sign before the path
eg: @c:\bsp\Trans.sql
Re: SQL script - Start command [message #368160 is a reply to message #368157] Mon, 18 September 2000 04:31 Go to previous messageGo to next message
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
Re: SQL script - Start command [message #368304 is a reply to message #368157] Tue, 07 November 2000 11:18 Go to previous message
holly lee
Messages: 1
Registered: November 2000
Junior Member
Would you please show me the instruction of how to start SQL server profiler 7.0
Thank you very much,
Holly
Previous Topic: sqlldr error message
Next Topic: Oracle Database Backup in Network Drive - V.V. Urgent !!!!
Goto Forum:
  


Current Time: Sat May 21 04:09:22 CDT 2022