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
629253044
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.9k377110
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
25.6k427586844
accept rate: 20%

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:

×198

question asked: 25 Nov '14, 08:23

question was seen: 380 times

last updated: 26 Nov '14, 07:28