Results 1 to 2 of 2
  1. #1
    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.
    Thank you.
    Anna - Verona (Italy)

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts