[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2297
  • Last Modified:

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> ????
0
deluziod
Asked:
deluziod
1 Solution
 
bretCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now