I have a view defined for a report that uses two distinct fields for a page index.When executing the /PRINT VIEW command against that view, I have not been able to successfully specify the two values I want to use in the SELECT Statement.
Example: VIEW1 consists of a page index of LASTNAME ZIPCODE
I want to PRINT the pages that contain all LASTNAME = "Jones" in ZIPCODE = "48301" from reports across a range of GENS.
LASTNAME and ZIPCODE are not defined as cross-report indices
In TSO, if I select a report, and place Jones 48301 in the index value and select VIEW1, I get the subset desired.In SARBCH, a command like/PRINT VIEW=(1,ADDRESS, )
SELECT 'JONES 48301' ID=ADDRESS GEN=1234
Does not generate the subset
I have not been able to find documentation on this in either the reference or user manual
My name is Roxanne and I am going to assist you going forward on your question. I opened a case for you 372310, and what I need is screen prints of your logical view information, or run SARBCH /LISTVIEW and send the details to the case along with a sample report.
I finally determined that for this to work, the SLECT Statement had to have the page index values concatenated, allowing for the full size of each index.So, in the above example of "Jones 48301", it was important to understand that the length of the last name field was 10 characters, making the correct SELECT statement "Jones 48301"