In order to work with an Adaptive Server database in DataWindow Designer, you or your system administrator should install certain stored procedures in the database before you connect to Adaptive Server from DataWindow Designer for the first time.
You must run the DataWindow Designer stored procedure scripts only once per database server, and not before each DataWindow Designer session. If you have already installed the DataWindow Designer stored procedures in your Adaptive Server database before connecting in DataWindow Designer on any supported platform, you need not install the stored procedures again before connecting in DataWindow Designer 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.
DataWindow Designer uses these stored procedures to get information about tables and columns from the Adaptive Server system catalog. (The DataWindow Designer stored procedures are different from the stored procedures you might create in your database.)
DataWindow Designer 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 DataWindow Designer CD-ROM. The Server directory contains server-side installation components that are not installed with DataWindow Designer on your computer.
