RE: COBOL File Specs to DDS or SQL

Would you be willing to send the cobol specs for the record layout? This could be a fun project.
I would be happy to attempt to create the dds or the sql statements.


Paul

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DrFranken
Sent: Thursday, August 16, 2012 8:54 AM
To: Midrange Systems Technical Discussion
Subject: Re: COBOL File Specs to DDS or SQL

Found out there are 'more files' likely following this one thus making the program approach even more desirable.

I Personally don't have the specs but they are generic COBOL. And being COBOL they are not in columns and are indented seemingly randomly. Since the subfields have 'redefine' those can easily be ignored I think.

Was hoping someone maybe had a program they've done this with. :-)

- Larry

On 8/16/2012 9:49 AM, John Yeung wrote:

It's absolutely doable, and I agree that a programmatic approach is
the way to go. I don't know COBOL, though. Maybe if you could give a
sample of the specs you're talking about?

Rob's suggestion of just letting COBOL handle it certainly would be
the first and most obvious choice. If that doesn't work, I strongly
suspect it would be rather easy to parse the specs in any high-level
language (doesn't even have to be on the i) and generate the desired
DDS or SQL.

John

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.