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

Description:
As part of our workflow for creating automatic summary holdings statements, we would like to run the HSTMT fix on all HOL records with an Sxx field on a nightly basis. How is the best way to accomplish this?

Resolution:
The jobs which run fixes are p_manage_25 and p_manage_37. p_manage_25 operates only on a sequential file; p_manage_37 can operate on a sequential file, a from-to group of record numbers, *or* on the Oracle records themselves.

You could run p_ret_01 in the ABC60 to retrieve the doc numbers of records with an Sxx field and then use that as input to p_manage_37. Assuming not many records will be changed, the p_manage_37 should not take long. But p_ret_01 on the entire HOL file could take a while....

What you *could* do is to define a Z07H table in the ABC60 (with triggers so that a Z07H is written each time a Z07 is written). Then you could run an SQL script against this Z07H to extract the doc number. This will give you a file of record numbers updated that day, which could then be used as input to p_manage_37.

Or, you could include this fix in the tab_fix INS section so it is run each time the record is written.

(keywords: manage_37 manage_25 ret_01 p-manage-37 p-manage-25 p-ret-01)

• Article last edited: 10/8/2013