Solved

How do you execute a sql script from within ISQL?

Posted on 2004-03-31
2
1,211 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sybase license issue 6 535
How do I get Sybase ASE to throw an error that Java can catch? 4 542
performance measure of  running SSIS package 4 199
Cluster Resource error 3 61
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

776 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