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
