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

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