In order to work with an Adaptive Server database in InfoMaker, you or your system administrator should install certain stored procedures in the database before you connect to Adaptive Server from InfoMaker for the first time.
You must run the InfoMaker stored procedure scripts only once per database server, and not before each InfoMaker session. If you have already installed the InfoMaker stored procedures in your Adaptive Server database before connecting in InfoMaker on any supported platform, you need not install the stored procedures again before connecting in InfoMaker on a different platform.
A stored procedure is a group of precompiled and preoptimized SQL statements that performs some database operation. Stored procedures reside on the database server where they can be accessed as needed.
InfoMaker uses these stored procedures to get information about tables and columns from the Adaptive Server system catalog. (The InfoMaker stored procedures are different from the stored procedures you might create in your database.)
InfoMaker provides SQL script files for installing the required stored procedures in the sybsystemprocs database:
Script |
Use for |
|---|---|
PBSYC.SQL |
Adaptive Server databases |
PBSYC2.SQL |
Adaptive Server databases to restrict the Select Tables list |
The stored procedure scripts are located in the Server directory on the InfoMaker CD-ROM. The Server directory contains server-side installation components that are not installed with InfoMaker on your computer.
