For each sybsyntax installation script you want to execute:
Determine the type (raw partition, logical volume, operating system file, and so on) and location of the device where you plan to store the sybsyntax database. You will need to provide this information later.
Make a copy of the original script. Be sure you can access this copy, in case you experience problems with the edited script.
Use a text editor to edit the script, if necessary, to change the default device from the master device to the device created in step 1. For information on the default device, see “Default device for the sybsyntax database”.
Comment out the following section, which specifies the default device:
/* create the database, if it does not exist */ if not exists (select name from sysdatabases where name = "sybsyntax") begin /* create the sybsyntax table if it doesn’t exist */ /* is the space left on the default database devices > size of model? */ if (select sum (high-low +1) from sysdevices where status & 1 = 1) - (select sum(size) from sysusages, sysdevices where vstart >= sysdevices.low and vstart <= sysdevices.high and sysdevices.status &1 = 1) > (select sum(sysusages.size) from sysusages where dbid = 3) begin create database sybsyntax end else begin print "There is not enough room on the default devices to create the sybsyntax database." return end end
After you have commented out this entire section, add a line like this to the script:
create database sybsyntax on device_name
where device_name is the name of the device where you want to install sybsyntax.
Execute the script with a command like the following:
isql -Usa -Ppassword -Sservername < $SYBASE/$SYBASE_ASE/scripts/ins_syn_sql
where sa is the user ID of the System Administrator, password is the System Administrator’s password, and servername is the Adaptive Server where you plan to install the database.
If you have set the DSQUERY environment variable to the servername, you can replace the server name with DSQUERY. For example:
isql -Usa -Ppassword -S$DSQUERY < $SYBASE/$SYBASE_ASE/scripts/ins_syn_sql
To ensure that you have installed the sybsyntax database and that it is working correctly, use isql to log in to the server on which you installed the database, and execute sp_syntax. For example:
isql -Usa -Ppassword -Sservername 1> sp_syntax "select" 2> go
Adaptive Server displays a list of commands that contain the word or word fragment “select.”