Hello...

We have a script to migrate an ASE database from one (internal) version to
another. That script is really only actually a composite of several smaller
scripts run in sequence. Something like:
1. Drop Triggers
2. Drop SProcs
3. Drop Indexes
4. Drop Views
5. Perform Migrate DDL / DML
6. Create Views
7. Create Indexes
8. Create SProcs
9. Create Triggers

All the Drop and Create work exists in their own separate scripts (easier to
maintain).

Rather than copy-pasting the individual scripts into the master Migrate
script, I'd like to run them by referencing their individual script names.
SQL Anywhere lets me do it with:
READ drop_trggrs.sql
go
READ drop_sprocs.sql
go
READ drop_indxs.sql
go
..... etc.

Does Sybase ASE 11.9.2 (under Linux) have an equivalent capability and how
does it work?

Bonus Points: If it does, can the script with those calls-by-reference also
work under an ODBC-based ISQL editor?

Many Thanks...

"bonzo" <me (AT) my (DOT) com> wrote

Well, ASE (the server) doesn't have that capability, but various clients
do.

With ISQL, for instance, you can use the ":r <filename>" command to read in
a script file. I believe the SQSH utility also has similar capabilities.

-bret