Hello Everyone,

I have a copy book from which i need to generate Teradata DDL, Is there any parsers/tools available?

I have to convert more than 1000 copybooks, i am a newbie to mainframe. Pls help me, Thanks.

Without knowing what Teradata DDL looks like, what I can say is the analysis of a copybook is VERY complicated. Consider such simple options as redefines and occurs within occurs.

I have a program that does just this, it's about 3000 lines of REXX code. Like I say, far from trivial

I have used the output from the copybook function in File Manager, or similiar product, to convert copybooks. It does much of the heavy listing computing redefines and occurs. I found it very useful for converting copy books to Easytrieve macros.

Hi Michael

I am working in a similar project.

Please send me your Rexx

Best Regards

Thanks

I have no problems sending you the code, but before I do, what EXACTLY do you expect it to do for you ? it's basically a script that facilitates counting the number of bytes

in a copybook (yes, I know you can get that from the compiler listing as well). You can also count the number of bytes between labels in your working-storage code (so you

could count part of a copybook or group variable).

In addition, it's also used to generate offsets etc so as to be able to trace the contents of a copybook with its contents dynamically.

>> i am a newbie to mainframe. <<

>> the analysis of a copybook is VERY complicated <<

And then: >> Please send me your Rexx << ????

--------------------------------

I'm sure that you won't have any comfort of looking at a complex function about cobol copybooks written in _any_ programming language. Have a look on the compiler listing. If you understand this you have all you need. Then have a look on >> copybook function in File Manager << (IBM tool) or the same function in compuware's FileAid ...