Install Online Help for Transact-SQL Syntax

The $SYBASE/$SYBASE_ASE/scripts directory contains scripts for installing the syntax help database, sybsyntax.

You can retrieve this data using sp_syntax. See the Reference Manual: Procedures.

The scripts directory contains one or more of the sp_syntax scripts shown in, depending on which SAP products are included with your server:

sp_syntax Installation Scripts

Script

Product

ins_syn_cl

Open Client Client-LibraryTM

ins_syn_esql

Embedded SQLTM

ins_syn_os

Open Server

inssynsq

Transact-SQL

All SAP ASE installations include the inssynsq script, which includes syntax information for Transact-SQL, the system procedures, and the SAP utilities. Execute this script to install the SQL portion of the sybsyntax database.

You can install any of these scripts, depending on the need for SAP information on your server. The first script you execute creates the sybsyntax database and the necessary tables and indexes. Any scripts that you execute after the first one add to the existing information in the database. If you reexecute a script, the previously installed rows of information are deleted from the table in the database and then reinstalled.

Warning!  The ins_syn_cl and ins_syn_os scripts conflict. If you execute both scripts, errors occur.