FairCom RTG COBOL Edition User's Guide

Step-by-Step Sqlizing Instructions

This section provides step-by-step instructions for sqlizing your data based on the Sqlize Tutorial (Driver\ctree.cobol\tutorials\sqlize\). It assumes you have already set up the environment where you will run the COBOL application using FairCom RTG.

You can obtain the current XDD structure from an existing table using ctutil -sqlinfo.

FairCom RTG provides tools to help you fine-tune your installation to overcome these problems. In particular, see Troubleshooting Data Conversion Errors.

You will find an abundance of useful information in this guide, such as FairCom RTG Errors, XDD File Schema, and Background Information about Sqlizing. Advanced users may want to consult API for SQL Conversion Error Checking.

Bring RTG SQL to your Existing COBOL Data

The process of sqlizing consists of three major steps for the end user (the tutorial below includes extra steps for clarity):

1. Extract the XDD from COBOL (step 2 in the tutorial below).
2. Sqlize it using ctutil (step 4 in the tutorial below).
3. Use SQL to access the database (step 6 in the tutorial below).

The SQLIZEEXAMPLE program prints out information about membership cards satisfying a partial card number request. The program itself can create the required file if the file does not exist, however it does not populate the file.

1. Compile the SQLIZEEXAMPLE.CBL program:
   iscc SQLIZEEXAMPLE.CBL
   
2. Extract the XDD from SQLIZEEXAMPLE.CBL by running xddgen:
   C:\FairCom\vx.x.x.RTG\winX64\Tools\cmdline\XDDGEN\xddgen.exe SQLIZEEXAMPLE.CBL
   
3. Create empty FairCom RTG files using either the COBOL program or the XDD.
   1. You can execute the COBOL program one time to create the COBOL files (.DAT and .IDX):
      iscc -ze SQLIZEEXAMPLE.CBL
   2. Or you can use the XDD to create the file, using ctutil -make:
      ctutil.exe -make CARDFILE CARDFILE.xdd
      
4. Sqlize it, using ctutil –sqlize and the XDD:
   ctutil.exe -sqlize CARDFILE CARDFILE.xdd ADMIN ctreeSQL -rule=rules.xml
   
5. Populate the table using the SQL script Tutorial.sql:
   isql.exe -s Tutorial.sql -u ADMIN -a ADMIN ctreeSQL
6. Run the COBOL program again and count the records. You can now use SQL to query the multi-record data.

A few tips:

• Use the ACUCOBOL compiler option ‑f4 to automatically generate an XFD file. In most cases, FairCom RTG can readily use this information to automatically sqlize the table upon creation.
• The FairCom RTG ctree.conf file allows automatic sqlizing with the <sqlize> configuration option as long as a valid COBOL XFD or FairCom RTG XDD file is available. Uncomment this in the provided ctree.conf file for Tutorial1.
• You’ll find compiler specific directives (*>>XDD WHEN) in the CARDFILE.FD source module. Review this module which provides a modestly complex usage of COBOL redefines, resulting in multiple SQL “tables” from a single COBOL table. Be sure to run xddgen over this module to create a valid XDD file.