c-treeRTG COBOL Edition User's Guide

Sqlize: Persist XDD to Data File and Link to SQL Dictionary

After creating an XDD, the information in that file will need to be persisted in the data file and linked to the FairCom DB SQL dictionary.

Use the ctutil -sqlize command to make an existing data file accessible from SQL by storing the XDD in the file and linking the file name to the FairCom DB SQL dictionaries.

After You Have Sqlized

After you have stored the XDD in the data file, you have finished sqlizing and you are ready to take it for a test spin. Experiment with some sample data to see if the process yielded the expected results. Be aware of two factors that may affect the results:

• Some COBOL fields do not translate well to SQL. For example a text field may be used to store a date in a human-readable format that has no meaning to SQL.
• Some COBOL programming practices, such as REDEFINES, do not lend themselves to relational access.

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

c-treeRTG 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 c-treeRTG Errors, XDD File Schema, and Background Information about Sqlizing. Advanced users may want to consult API for SQL Conversion Error Checking.