Copybook to DataStage schema file

leomauer · Post by **leomauer** » Wed Feb 17, 2010 8:21 am

Does anybody know a UNIX command line utility that allows to convert COBOL copybook to DataStage schema files?

DSguru2B · Post by **DSguru2B** » Wed Feb 17, 2010 9:27 am

I am not sure if one exists and if it does then pardon my ignorance. I know there are some softwares out there that will read a copy book and convert it into xml. You will have to cook something up. Would'nt be hard to create a shell script that achieves this.

suryapkakani · Post by **suryapkakani** » Wed Feb 17, 2010 11:50 am

Found this on search http://sourceforge.net/projects/cb2xml/. A java parser job can be used to populate the required.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 17, 2010 1:37 pm

Import the COBOL copybook into DataStage. Then open the table definition, go to the Layout tab, open the Parallel option and (right click to) save the record schema in a file. Voila!

leomauer · Post by **leomauer** » Wed Feb 17, 2010 6:48 pm

ray.wurlod wrote:Import the COBOL copybook into DataStage. Then open the table definition, go to the Layout tab, open the Parallel option and (right click to) save the record schema in a file. Voila! ...

I know it is that simple. Unfortunately I need to do it dynamically before the job runs. I use this schema file in the job. It is not xml I am converting to, but really a schema file.
Any idea? I am writing DataStage job to do it, but there is too many variations in copybook syntax that it is going to be difficult.