Previous Topic: Installation of the PC Client ComponentNext Topic: Creating Table Procedure Specifications

Introduction › Install Quick Bridge › Installation of the Mainframe Component

Installation of the Mainframe Component

The mainframe component requires the installation of the SQL schema CAAV, the table procedures CAAV.GETREC (CAAVLREC) and CAAV.MODULETEXT (CAAVMTXT).

  1. Review the READMEMF.TXT file in the MAINFRAM folder. It may contain instructions for specific mainframe releases or environments.
  2. Upload all the files of the MAINFRAM directory to a mainframe source library. The files, which are coded in ASCII must be translated to the mainframe codeset EBCDIC.
  3. Process the SQL definitions contained in CAAVQBSD.SQL with IDMSBCF. No configuration of CAAVQBSD.SQL is required, but of course an appropriate catalog must be specified. For more information about the IDMSBCF utility, see the CA IDMS Command Facility.
  4. The COBOL sources for the table procedures are CAAVLREC.COB and CAAVMTXT.COB. These programs must be compiled and linked in a CA IDMS load library as described in the CA IDMS DML Reference – COBOL.
  5. Users with an environment that supports fully reentrant COBOL programs in CA IDMS (IBM COBOL II) should use the CAAVSGNR.SGN member as input to RHDCSGEN to update their IDMS system definitions with the table procedure programs. Other users must use the CAAVSGNQ.SGN member. Generate and recycle your IDMS system. For more information about the sysgen utility RHDCSGEN, see CA IDMS System Generation.
  6. Add an SQL schema for each dbname that will be accessed by Quick Bridge.

    Because Quick Bridge accesses the dictionaries that hold the non SQL schema, subschema, and record definitions through SQL, appropriate SQL schemas must be defined for each dbname containing these dictionary segments.

    For example, if the DBNAME APPLDICT contains the Quick Bridge SQL definitions and will be specified in the ODBC datasource definition, the following SQL syntax will make this dbname accessible by Quick Bridge:

    CONNECT TO APPLDICT;
CREATE SCHEMA APPLDICT FOR NONSQL SCHEMA SYSDIRL.IDMSNTWK DBNAME APPLDICT;

    SYSDIRL is the name of the dbname that has been processed with IDMSDIRL and that contains the IDMSNTWK schema. APPLDICT contains the non SQL schema's, subschema's, and records that Quick Bridge will be using.

    If other dictionary needs to be made accessible within the same ODBC datasource, additional schema's will need to be created in the same manner.