SAP SQL Anywhere

Question

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?

Accepted Answer

4

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 Smirnios
12.0k●3●96●166
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

flat view

Answer 2

0	See also: READ and PARAMETERS permanent link answered 26 Nov '14, 07:28 Breck Carter 32.5k●541●726●1050 accept rate: 20% flat view

SAP SQL Anywhere

Looking for functionality to run script in SQL Anywhere which is similar to....

Follow this question

Related questions