Jason, in addition to all the previous comment, keep attention to the fact that it's not so unusual that programmers redefine fields into a DLI segment (or the entire segment itself) so fields can or can not be what they appear.
You should have ALL the old programs accessing DLI data and double check. Good luck. Max <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Privo di virus.www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> Il giorno ven 17 mag 2024 alle ore 20:46 ITschak Mugzach < 000005a7ced721d8-dmarc-requ...@listserv.ua.edu> ha scritto: > 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 > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
