Thread: SQL query and TSO dataset
06-02-07, 04:45 #1Registered User
- Join Date
- Apr 2007
Unanswered: SQL query and TSO dataset
I have to compare data from an SQL query with data in a TSO dataset.
So I have to perform many operations:
1) importing TSO dataset in Excel
2) adjusting dataset columns in Excel
3) running the SQL query
4) saving the query output in Excel
4) joining in Access dataset and query results.
Is there a way to avoid all these steps and simplify and fasten this process?
The dataset takes data from db2 tables and make calculations, yielding
results that I have to compare with my query.
Anna - Verona (Italy)
06-02-07, 07:27 #2Registered User
- Join Date
- May 2003
You need to specify in your questions that you are using DB2 for z/OS (or OS/390). Otherwise people will assume you are using DB2 for Linux, UNIX, Windows, which is a different product.
Your best bet might be to load the data from the TSO dataset into a DB2 a table and then compare it against the other table (if you use save data in QMF for TSO it will create a table with the results of our QMF query) using SQL statements (if you are good at SQL). Ask your DBA if they can create a new table for you and load the data from the TSO dataset into it (in the same DB2 subsystem as the table you want to compare it against).M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390