cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
1,647

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 Solutions (1)

Accepted Solutions (1)

johnsmirnios
Advisor
Advisor

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

Former Member
0 Kudos

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?

johnsmirnios
Advisor
Advisor
0 Kudos

Yes, you can use READ within a script.

Former Member
0 Kudos

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

Thank you!

Answers (1)

Answers (1)

Breck_Carter
Participant
0 Kudos