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

Problem Symptoms:
Though file-03 ("Export Database Tables") for the xxx50 z36h (Loan history) table seems to complete successfully and no errors appear in the $alephe_scratch log, no ./xxx50/files/z36h.seqaa file is created.

Cause:
The following SQL shows that the count of xxx50 z36h records is zero:

xxx50@ALEPH21> select count(*) from z36h;
**** Hit return to continue ****

COUNT(*)
----------
0

And the ./xxx50/tab/tab100 has the following setting:

CREATE-Z36H=N

Resolution:
If history records are desired for future loan transactions, set CREATE-Z36H=Y. {There is no way to have z36h records be created for past loan transactions -- though there' *is* a z35 (Event) record for each loan transaction, which has some of the same information as the z36h.}

Category: Circulation (500)

• Article last edited: 5/12/2014