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 Sybase products are included with your server:
Script |
Product |
---|---|
ins_syn_cl |
Open Client Client-LibraryTM |
ins_syn_esql |
Embedded SQLTM |
ins_syn_os |
Open Server |
ins_syn_sql |
Transact-SQL |
All Adaptive Server installations include the ins_syn_sql script, which includes syntax information for Transact-SQL, the system procedures, and the Sybase 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 Sybase 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.