- Article Type: General
- Product: Aleph
- Product Version: 16.02
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?
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:
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).
- Article last edited: 10/8/2013