Tom, please share your email here. I have a Rex program that we developed ten years ago that will scan db2 catalog and generate the code to define and load the unloaded data to any sql db.
Best ITschak בתאריך יום ד׳, 8 בפבר׳ 2023 ב-20:14 מאת Tony Harminc <t...@harminc.net>: > On Wed, 8 Feb 2023 at 12:11, Tom Longfellow > <000003e29b607131-dmarc-requ...@listserv.ua.edu> wrote: > > > > The death warrant on our DB2 for z/OS has been issued. > > > > The people with decades of data stored in the tables are asking the > obvious questions. How do we see into our ancient history as we have > always done? My answer is simple: you can't. > > > > The all knowledgeable planners have come up with the idea of Extract it > into CSV files and walk away. I have many concerns about this process > that I will not go into now. > > > > As a good little worker Bee, I am trying to do what I am told. Here is > where the fun begins. My good friend Google (and IBM) says 'Use IBM Data > Studio to perform the Extract to CSV utility function. My installed > version of IBM Data Studio (V4.1.3) does NOT have that option in the menus > displayed by the documentation. > > > > Does anyone have a workable way to Extract DB2 Tables to CSV files? > > Surely SQLite would be a better match to DB2 than would CSV files. The > price is right (same as CSV files), you don't need to set up a server > in the usual sense, and it's probably the most used SQL database on > the planet. I'd think you should be able to pretty much copy entire > tables from DB2 to SQLite without fancy tools. > > Tony H. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- ITschak Mugzach *|** IronSphere Platform* *|* *Information Security Continuous Monitoring for z/OS, x/Linux & IBM I **| z/VM coming soon * ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
