Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How do you execute a sql script from within ISQL?

Posted on 2004-03-31
2
Medium Priority
?
1,875 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
bret earned 500 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Whoever said that “a picture is worth one thousand words” observed a fact that can dramatically affect your marketing success. Most people tend to learn visually, so many publishers commonly acknowledge the effectiveness of visual learning by using…
Article by: Shawn
IT teams define success as solving problems quickly. To enable ITSM modernization we have to think of adopting the tools and methods that will enable resolution of ITSM issues more quickly.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

730 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