Previous Topic: Add More ColumnsNext Topic: Upload a Table Procedure to CA IDMS


Generate a Table Procedure Specification

After you define and save a table procedure specification, you can generate it. Quick Bridge creates files with this default naming convention:

tps_file_name.file_extension

where tps_file_name is the name that you used to save the table procedure specification file and file_extension defines the file contents:

File Extension

Description

.SQ1

CREATE TABLE PROCEDURE syntax to load in the CA IDMS system catalog

.SQ2

CREATE TABLE syntax to load in an Ingres database with Ingres 1.x syntax

.SQ3

CREATE TABLE syntax to load in an Ingres II database with Ingres 2.x syntax

.SGN

ADD PROGRAM system generation syntax to define the COBOL program to the CA IDMS system

.COB

The COBOL program that defines that table procedure

Examples of the .SQ1, .SQ2, and .SGN files appear in Appendix A.

To generate a table procedure specification

Select Generate from the File menu. Quick Bridge displays a message box when it is done generating the table procedure specification.