Sybase provides SQL scripts that allow you to create a sample database and system tables on DB2. The installation program installs the scripts in the scripts subdirectory.
The scripts subdirectory is at $SYBASE/$SYBASE_ECON/scripts (UNIX) and %SYBASE%\%SYBASE_ECON%\scripts (Windows).
The scripts are as follows:
The pubsdb2.sql script creates sample PUBS tables that simulate the PUBS database provided with ASE. By installing PUBS tables on DB2, you can more easily test the transfer process between ASE and DB2. These tables are not required for DirectConnect for z/OS setup, but Sybase recommends installing them to assist Sybase Technical Support.
The cspdb2.sql script creates tables for catalog stored procedures (CSPs). These tables are required for DirectConnect for z/OS setup with DB2.
Use the isql utility to run the scripts. Sybase recommends that you complete all of these tasks from the platform server before you attempt to install Open Client/DB-Library files on any client machines.
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |