Verifying access to native VSAM

Edit online

Verify native VSAM data access by creating a sample VSAM file and a corresponding virtual table and running a query that accesses the VSAM data.

Procedure

  1. Create the sample VSAM file on the mainframe that hosts the Data Virtualization Manager server.
    Run the AVZGNSTF member in the hlq.SAVZCNTL data set to allocate and load the sample VSAM file.
    The job should complete with a condition code of 0.
  2. Create the staffvs virtual table, and run a query that returns a result set.
    Run the AVZIVVS1 member in the hlq.SAVZCNTL data set to perform a batch extract of the sample VSAM file listing and create a virtual table that is used to format the result set that is returned from the VSAM file.
    The job should complete with a condition code of 0.
  3. Verify that the SQL results contained in the AVZIVVS1 member are valid.