That'd be my thought. DB2 to flat file, then through (probably) REXX to CSV format, then download to the PC. Or get a REXX to read the DB2 tables directly, though that's probably slower; I'd think QMF would be faster for the first extract, assuming you have a lot of data to process. If you're not a REXXer but do know VBA or VBS, you can convert to CSV after you download the flat files, though that may be a little harder.
(So it can't possibly be a dumb answer, Lionel, if both you and I like it.) CSV...that might be a lot of data. Is Access an option, instead? More trouble to access (no pun intended) but it does a better job when the bytes are many. --- Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313 /* We see that many articulate secularists are well-meaning and law-abiding men....So we conclude...that their philosophies are just as good guides to action as Christianity. What we don't see is that they are not acting on their philosophies. They are acting, out of habit or sentiment, on an inherited Christian ethic which they still take for granted though they have rejected the creed from which it sprang. Their children will inherit somewhat less of it. -Joy Davidman, _Smoke on the Mountain_ (1955) */ -----Original Message----- From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Lionel B. Dyck Sent: Wednesday, February 8, 2023 12:23 May be a dumb answer but can't you migrate the data into a distributed database of some sort? -----Original Message----- From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Tom Longfellow Sent: Wednesday, February 8, 2023 11:12 AM 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? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
