DL/1 to DB2 conversion
Select messages from
# through # FAQ
[/[Print]\]

MVSFORUMS.com -> Application Programming

#1: DL/1 to DB2 conversion Author: misi01Location: Stockholm, Sweden PostPosted: Sat Feb 15, 2020 5:54 am
    —
Not sure if this is the best/correct place to put this, but here goes.

I've written a DL/1 to DB2 conversion application. Needless to say, it's not of the type that you can rest your head on the keyboard and everything's converted with 100% accuracy. I've written some documentation and placed it in Linkedin at https://www.linkedin.com/posts/michael-simpson-19503434_how-to-convert-a-dl1-program-to-db2-activity-6633852072611713024-O-3z?lipi=urn%3Ali%3Apage%3Ad_flagship3_groups_entity%3B9stgnoMxSMG22AvQ%2Bb0lOQ%3D%3D. (If you can't access this and assuming you're a member of Linkedin, try adding the group Mainframe (COBOL,JCL,DB2,IMS,CICS,VSAM,z/OS,Adabas/Natural) Experts
and view the link to my doc.

The long and the short of it is that you define a mapping file that shows how DL/1 segments/fields correspond to DB2 tables/columns. The application will convert your xxxTDLI calls to DB2 ones as well as changing any references to DL/1 segment fields to their equivalent DB2 columns. The code has been written so as to be flexible enough for you to be able define what type of SQL call you want generated.

If your company is even thinking of converting slowly but surely, send me a private message and, with an example of a Cobol DL/1 source code, I can illustrate how the before/after results would look.


Last edited by misi01 on Mon Feb 17, 2020 4:58 am; edited 1 time in total

#2:  Author: kolusuLocation: San Jose PostPosted: Sat Feb 15, 2020 9:24 am
    —
misi01,

Do you mind sending me the doc to kolusu at gmail?

Thanks

#3:  Author: misi01Location: Stockholm, Sweden PostPosted: Sat Feb 15, 2020 11:13 am
    —
I'll send it to you.

Couple of comments.

1 Would appreciate any feedback as to readability, understandability (newly invented word), structure etc
2 Because it contains a number of screen shots and isn't finished to my satisfaction please don't append it to the forum as yet (based on point 1)

#4:  Author: misi01Location: Stockholm, Sweden PostPosted: Fri Mar 06, 2020 5:44 pm
    —
I updated the documentation that can now be found here https://www.linkedin.com/posts/michael-simpson-19503434_documentation-regarding-converting-dl1-programs-activity-6641601923856248832-OppA



MVSFORUMS.com -> Application Programming


output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1

Powered by phpBB © 2001, 2005 phpBB Group