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

Description:
We wanted to remove “in storage” items we had over the summer. Some of these In Storage items are attached to a separate 852. In that case, the 852 would have to be deleted also.

The In Storage items that share an 852 (1 copy in STFX General Collection, 1 copy In Storage), the “In Storage” item only, would have to be deleted.

From SQL, I could do a delete from z30 where Z30_ITEM_PROCESS_STATUS = 'ST' AND z30_sub_library like 'SFX%'. but I still need to remove the 852 item.

How can I do this? Is there anything else that needs to be done for this request?

Resolution:
If the only 852's with the "SFX.." sublibrary code are these which you want to delete, then you could use the p_manage_21 global change, running in the NOV60 library, to delete them (where 852 $$bSFX? )

Otherwise, you would need to do the following:

1.
SQL-NOV50> set heading off
SQL-NOV50> set pause off
SQL-NOV50> spool hol_numbers
SQL-NOV50> select Z30_HOL_DOC_NUMBER_X from z30 where Z30_ITEM_PROCESS_STATUS = 'ST' AND z30_sub_library like 'SFX%' minus select Z30_HOL_DOC_NUMBER_X from z30 where Z30_ITEM_PROCESS_STATUS ^= 'ST';

(This assures that only HOL records whose items are *all* ST items will be selected.)

2. Edit the hol_numbers file produced in step 1 to append "NOV60" to each line. (This is described in KB 8192-1591.)

3. Use the file produced in step 2 as input to the p_manage_21 global change (-- so the change will be limited to just these HOL records).