Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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
12.0k396166
accept rate: 37%

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
32.5k5417271050
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:

×261

question asked: 25 Nov '14, 08:23

question was seen: 1,263 times

last updated: 26 Nov '14, 07:28