Solved

How do you execute a sql script from within ISQL?

Posted on 2004-03-31
2
1,317 Views
Last Modified: 2012-06-27
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
Comment
Question by:deluziod
2 Comments
 
LVL 10

Accepted Solution

by:
bret earned 125 total points
ID: 10725141
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
 

Expert Comment

by:blrsamir
ID: 10740430
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question