Create Cobol copybook from a DB2 table unload.

ywheeler · New User Joined: 10 Nov 2006 Posts: 19 Location: New York

My question, is it possible to create a file layout from an unload? When I run an unload of a table using a DB2 unload utility, the resultant files embed a filler byte for each 'nullable' field (so that a subsequent Db2 load utility will know when a field should be valued as null in the table being loaded). Is there something which can be added to the unload so when the data is unloaded it would also create a file layout?

Anuj Dhawan · Posted: Thu Jun 17, 2010 9:40 pm

DCLGEN. DCLGEN under DB2I?

dbzTHEdinosauer · Posted: Thu Jun 17, 2010 9:42 pm

What is wrong with the INCLUDE member
you use when defining the TABLE in a program,
that is generated as part of the DCLGEN process?

the unload will not generate a file layout of the table
only a file layout of the unload file.

if you want to process the file layout of the unload file with a REXX or SAS script,
that can be done.
but since it already exists,
why go to the extra trouble?

ywheeler · New User Joined: 10 Nov 2006 Posts: 19 Location: New York

In this particular task the unload files will not be used in a Cobol program. I'm looking for a process that can convert SYSPUNCH cards of the unload utility into file layouts ( preferrably in the format of a cobol copybook, since the recipient is more comfortable mapping the file using such copybooks).

Anuj Dhawan · Posted: Fri Jun 18, 2010 4:16 pm

I do not think if there are any vendor product to do this, however, you may try write a quick REXX for this...