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")
         /* 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)
             create database sybsyntax
             print "There is not enough room on the default 
             devices to create the sybsyntax database."
  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.”