• Article Type: General
• Product: Aleph
• Product Version: 20
• Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

What is z05 and when can it be used?

Resolution:
z05 is the table in which result sets are saved.

If a client receives wrong results for his query, we need to check how the search was created, how the query was built. This is especially relevant if there is a cross search, or another complicated search.
In this case we check Z05 which is the search set number.

This check is done using:
1. util f 4 in vir01 (type Z05): here we get the Z05_REC_KEY which is the search set number

Util F 4/Z05:
-000272-3799 - -LOC -wti = (te-000000002-000000002-000000000-20050421

272 is the search set number. This is the z05_REC_KEY.
LOC is the library in which we searched
WTI is the search method

2. In SQL: to see the exact query.
To see this search set in a better way, we look in the SQL mode:

Type S+ vir01
Then type desc Z05
Then:

select Z05_REQUEST from z05 where Z05_REC_KEY='000272';
**** Hit return to continue ****

Z05_REQUEST
--------------------------------------------------------------------------------
wti = ( technology and culture )

1 row selected.

These Z05 records are temporary and every once in a while deleted.