The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hello,

I'm looking for a similar functionality in SQL Anywhere which you can find in Oracle....

In Oracle you can put all you script in a folder and have another script (in the same folder, lets call it X ). Then you just can to start (run) script X which calls the other scripts in a certain order.

> @UpdateScript.sql

The UpdateScript could contain something like this

@@AlterTables.sql
@@dropConstraints.sql
@@InsertScript.sql
@@addConstraint.sql
@@AddTables.sql

…. …..

So can this be done in a similar (easy) way in Sql Anywhere?

asked 25 Nov '14, 08:23

M%20G's gravatar image

M G
629243044
accept rate: 42%


If you are invoking the scripts from ISQL, you can use the READ statement: http://dcx.sybase.com/index.html#sa160/en/dbreference/read-statement.html*d5e63291

permanent link

answered 25 Nov '14, 08:36

John%20Smirnios's gravatar image

John Smirnios
8.7k377105
accept rate: 40%

I want to find a way to call several script from a script, so can you use the READ statement inside a script and get that functionality?

(25 Nov '14, 08:44) M G
Replies hidden

Yes, you can use READ within a script.

(25 Nov '14, 08:48) John Smirnios

I have tested the read statement and it's what I've been looking for

Thank you!

(25 Nov '14, 10:01) M G
permanent link

answered 26 Nov '14, 07:28

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×186

question asked: 25 Nov '14, 08:23

question was seen: 349 times

last updated: 26 Nov '14, 07:28