I am working at new place where they have a lot of Queries which works as series one after another, doing selection, writing to outfile.
Then next query uses this previous' query outfile, join with something writes to the next outfile etc.
To analyze this numerous queries, I used RTVQMQRY command to create a Source to learn how the QUERIES work (what is an Input file, what is Outfile, what is the selection etc.)
But this retrieved source consists only SELECT Statement without mentioning Outfile name.
Actually, the query makes select and insert to Outfile, but the source that I retrieve, doesn't have this Insert Statement.
Is it exist any way to know OUTFILE without going to WRKQRY, display the query, going to option 3, etc?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!