p_ret_01 for sublibrary/collection sdn/over in sys60 gets no results

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
Every time I run p_ret_01 on the sys60 library the report comes back empty. I've run the report a few times and havent been able to figure out the right combination of search criteria to get the item I need.

Here are the parameters from the most recent run:

setenv p_active_library "SYS60"
setenv p_file_in ""
setenv p_file_out "andysys60ret01test2"
setenv p_doc_number_from "000000000"
setenv p_doc_number_to "999999999"
setenv p_cataloger ""
setenv p_level "00"
setenv p_open_date_from "00000000"
setenv p_open_date_to "99999999"
setenv p_update_date_from "00000000"
setenv p_update_date_to "99999999"
setenv p_alpha ""
setenv p_sw_or_and "AND"
setenv p_sw_or_and_2 "NOT"
setenv p_code "852"
setenv p_sub_code_a "b"
setenv p_text_from_a "sdn"
setenv p_text_to_a "sdnz"
setenv p_sub_code_b ""
setenv p_text_from_b ""
setenv p_text_to_b ""
setenv p_code_2 "852"
setenv p_sub_code_a_2 "c"
setenv p_text_from_a_2 "over"
setenv p_text_to_a_2 "overz"
setenv p_sub_code_b_2 ""
setenv p_text_from_b_2 ""
setenv p_text_to_b_2 ""
setenv p_code_3 ""
setenv p_sub_code_a_3 ""
setenv p_text_from_a_3 ""
setenv p_text_to_a_3 ""
setenv p_sub_code_b_3 ""
setenv p_text_from_b_3 ""
setenv p_text_to_b_3 ""
setenv p_item_date_from "00000000"
setenv p_item_date_to "99999999"

[ <Jerry Specht > ]
[ <Jerry Specht > ]

Resolution:
The field code is a 5-character field. If you want it to look at all 852 fields, regardless of their indicator values, you need to specify "852##". This is described in KB 8192-10503.

• Article last edited: 10/8/2013