OraFAQ Forum: Server Utilities » SQL script

Home » RDBMS Server » Server Utilities » SQL script - Start command

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: SQL script - Start command [message #368159 is a reply to message #368157]

Fri, 15 September 2000 12:11

Isar
Messages: 3
Registered: July 2000

Junior Member

Chella, try @ sign before the path
eg: @c:\bsp\Trans.sql

Report message to a moderator

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

Report message to a moderator

Re: SQL script - Start command [message #368304 is a reply to message #368157]

Tue, 07 November 2000 11:18

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

Report message to a moderator

Previous Topic:	sqlldr error message
Next Topic:	Oracle Database Backup in Network Drive - V.V. Urgent !!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 23:04:56 CDT 2025