Installing sybsyntax

The sybsyntax installation script installs the database and the necessary tables and indexes.

1. 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.
2. Make a copy of the original script. Be sure you can access this copy, in case you experience problems with the edited script.
3. 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.
   Comment out this 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

4. 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.
5. Execute the script:

   isql -Usa -Ppassword -Sservername < $SYBASE/$SYBASE_ASE/scripts/inssynsq

   where sa is the user ID of the system administrator, password is the system administrator’s password, and servername is the SAP ASE where you plan to install the database.

   If you have set the DSQUERY environment variable to servername, you can replace the server name with $DSQUERY.

6. 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:

   isql -Usa -Ppassword -Sservername 
   
   1> sp_syntax "select" 
   2> go 

   SAP ASE displays a list of commands that contain the word or word fragment “select.”