If you have IMS installed, you can use rexx to read the database and create sql statements.
ITschak *| **Itschak Mugzach | Director | SecuriTeam Software **|** IronSphere Platform* *|* *Information Security Continuous Monitoring for Z/OS, zLinux and IBM I **| * *|* *Email**: i_mugz...@securiteam.co.il **|* *Mob**: +972 522 986404 **|* *Skype**: ItschakMugzach **|* *Web**: www.Securiteam.co.il **|* בתאריך יום ו׳, 17 במאי 2024 ב-19:53 מאת Andrew Wilkinson < 000004f504c2b946-dmarc-requ...@listserv.ua.edu>: > Jason,Please excuse the terrible formatting from my phone.Does the DBD > describe every byte of every segment?If so, you won't need the > copybooks.Also you will need to reformat the IMS unload file before > reloading into DB2, at the very least because of keys cascading from parent > segment(s).You do need an IMS expert to do this cleanly.Cheers,Andrew > -------- Original message --------From: Jason Cai <ibmm...@foxmail.com> > Date: 17/05/2024 09:21 (GMT+00:00) To: IBM-MAIN@LISTSERV.UA.EDU, Andrew > Wilkinson <andrew_john_reid_wilkin...@talktalk.net> Cc: Jason Cai < > ibmm...@foxmail.com> Subject: Re: Assistance with Converting IMS DB to > MySQL DB Dear Andrew,Thank you for your suggestion. I have some thoughts on > the IMS segment layout and defining SQL columns, and I’d like to confirm > with you:If I have the DBD (Database Description), is it sufficient to > correctly define the SQL columns? Or do I need the application copybook in > addition to the DBD?If the SQL columns are defined correctly, is it > possible to do the following:a. Unload Data from IMS using PGM=DFSURGU0b. > Define DB2 Tablesc. Load Data into DB2 using PGM=DSNUTILBThe above are some > of my ideas, and I’m not sure if they are correct. I hope to get your > guidance. Thank you very much for your help!Best regards,Jason Cai > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
