How do you execute a sql script from within ISQL?

In Oracle's SQL/Plus you execute an external SQL script by entering:
SQL>  @mysql.sql.
How do you do this while in Sybase's ISQL?  Or can you?
1> ????
deluziodAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
bretConnect With a Mentor Commented:
You can use ":r <filename" to read a script into isql, then type "go" to execute it.

Note that the script itself should not contain any "go" statements, unlike a script that you would run through isql using the "-i <inputfile>" parameter.

-bret
0
 
blrsamirCommented:
if you are running sybase on UNIX you can try the following
1>:r <file name>
2>go

Rememember to exclude 'go' from the <file name>. You have to type it in explicitely at the isql prompt.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.