Using SQL Quick Bridge

CA IDMS SQL Quick Bridge (Quick Bridge) makes it easy for CA IDMS programmers and DBAs to define table procedures. Quick Bridge is a graphical user interface (GUI) tool, using client/server technology, and offers two methods to establish client/server communications with the mainframe: CA IDMS Server and EDBC for CA IDMS. The client runs under a Microsoft® Windows platform and the server runs under a mainframe operating system.
idms19
CA IDMS SQL Quick Bridge (Quick Bridge) makes it easy for CA IDMS programmers and DBAs to define table procedures. Quick Bridge is a graphical user interface (GUI) tool, using client/server technology, and offers two methods to establish client/server communications with the mainframe: CA IDMS Server and EDBC for CA IDMS. The client runs under a Microsoft® Windows platform and the server runs under a mainframe operating system.
The Windows client uses a series of intuitive dialogs that prompt you for information that is required to define a table procedure specification that is based on records and sets relationships defined in a non-SQL database. The generated table procedure specification creates the SQL table procedure definition; system definitions, and source for the COBOL program that you can upload and store in a CA IDMS dictionary.
The generated COBOL program provides a functional data access approach using CA IDMS DML. Quick Bridge generates all basic processing logic in a clearly structured, easily readable program. You can modify the program to fine-tune the database navigation or to add additional processing.
This article includes the following topics:
2
2
Prerequisite
To use Quick Bridge, you should be a CA IDMS DML programmer or database administrator. In addition, you should be familiar with SQL concepts and Windows. Additional knowledge of ODBC and client/server communications is helpful.
Supported Structures
Quick Bridge supports the following non-SQL database structures:
  • Multi-level record structures
  • Bill-of-material structures
  • Repeating element groups using the OCCURS clause
  • The lowest level of a group-level field
  • One record type of a multi-member set relationship
System Requirements
This section describes the system requirements for the client and server.
Client
On the client, you need CA IDMS Server Release 17.0.  Hard disk requirements vary, depending on which components you install. The installation program tells you specific hard disk requirements for the components.
Server
On the server, you need to enable CA IDMS SQL and CA IDMS Server on a supported release of CA IDMS. You also need a COBOL compiler.