SARose
asked on
How to access DB2 tables using JCL
In our organization, many data analysts used JCL to identify MVS text files (z/OS Version 1.4., soon to be upgraded to z/OS Version 1.7) to be read into SAS. As part of an information system upgrade, those files are being converted to DB2 tables. Most of us don't have the time to learn DB2 or SQL. We heard it was possible to use either a "DB2 utility" or QMF to access the DB2 tables, select variables, put them out as a text file, then read the text file into SAS. Can anyone advise me as to the quickest, easiest way to do this? We don't have a SAS/Access license to read the DB2 tables directly into mainframe SAS. I know that DB2 and QMF can be accesses through TSO. Perhaps that's a way to select variables and put them out as a text file that can be read into SAS. In that case, can you recommend a QMF quick start tutorial? Any help would be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Now SUFI comes "free" with DB2 and you can use it through TSO, but requires SQL knowledge.
I would suggest that you talk to the system programmers that are going maintain DB2 and/or ask the application development group. They should be able to create simple programs that can do what you want, in fact they may be able to filter down the data so that you only get the rows/records you are interested it.
I am not really a DB2 person, but I don't know of a utility that will allow you to select columns and put into a sequential file, other than a complete table unload, but if the data you want is spread across multiple table, you need to dump each table and may end up with a lot more data than you want.