Convert COBOL copybook to Tedata DDL

CUSTOM COBOL ROUTINES (Freeware)

FEATURES

1. Build PRIMARY INDEX by search for first key work "-KEY" in COBOL copybook column or compound columns
2. Support for OCCURS and remove REDEFINES clause
3. Handle COMP field (Binary), numeric display, COMP-3 data type...
4. Add COMPRESS to all none-key fields
5. Handle long file name or field name
6. Provide execution log
7. Detect long table/field name (over 30 characters)
8. Handling FILLER

OVERVIEW

These handy COBOL runtime routines will convert COBOL copybooks to Teradata DDLs. It will be very useful tool to assist Teradata DBA migrate thousands of COBOL copybooks to Teradata DDLs. Best of all it is a FREE utility.

SYSTEM REQUIREMENT

• DOS or any Microsoft Windows.
• Open-source IDE COBOL (download here)

Note: DOSBox is a DOS emulator that allows this COBOL runtime to be executed under any Windows OS. Download DOSBox here

SETUP

• Download and install freeware IDE COBOL on your C: drive
• Create a folder \copybook under C:\idecobol
• COBOL runtime modules require to convert copybook to DDL PCPY2DDL.INT and CCPY2DDL.INT