I have only a little home brew utility - better said an awk script (see
which translates a very simple Copy Book Structure (without REDEFINES) a
creates the corresponding SQL Create Statement
We use in tables which are processed by COBOL basically only CHAR and
For example if we have an copy book like this
* COBOL Copy Book
05 FOO PIC X(24).
05 BAR PIC XXX.
05 FOOBAR PIC 99.
FOO BAR BAZ
05 SPAM PIC S9(16) COMP-3.
05 EGGS PIC S9(04)V9(2).
05 SPAM-AND-EGGS PIC S9(07)V999 COMP-3.
then the script converts it into
create table FOOBAR_AREA (
Unfortunatelly it doesn't run on iSeries, but on the PC, because on the
iSeries I don't have the current awk version, only an old one.
If you are interested I can send you the source. Maybe you can use it as
is , or enhance it for your needs, or only for inspiration, how to
programm the better utility self :-)
The processing looks like this - see the picture
[COBOL400-L] Convert COBOL record layout specs to PF or DDL specs?
We have a client who supplied us with COBOL record layout specs for a
rather large layout, and I was wondering if anyone has possession of or
seen a utility that will convert such specs into SQL DDL or PF specs
I go and invent that wheel.
As an Amazon Associate we earn from qualifying purchases.