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."
      where device_name is the name of the device on which to install sybsyntax.
    • After you have commented out this entire section, add this line:
      create database sybsyntax on device_name
  4. 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:
    isql -Usa -Ppassword -S$DSQUERY < %SYBASE%\%SYBASE_ASE%\scripts\inssynsq
  5. 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”.