Installing sybsyntax

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”.