None of the new logical bases I added to alephe/tab/tab_base.eng are working
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
We built two logical bases (Physical Library Equipment & the State Document Collection). The following is the parameters in tab_base.eng. After that, I ran p-manage-32, but none of the logical bases seem to be working. The State Document Collection is only identified by note field (MARC 590 field).
PHYEQ Physics Equipment USM01 EXU01 USM01 Y alldocuments not (wst=suppressed or wst=deleted or wst=circ-created) and WSL=PHYEQ
DOCS State Gov.Collection USM01 EXU01 USM01 Y alldocuments not (wst=suppressed or wst=deleted or wst=circ-created) and WRD=State Government Collection
Please give us further instructions.
Resolution:
Run the following report in USM01 (UTIL-H-1-10) which illustrates the recommended and current setup of the Z0102 column (column 8) of tab_base.eng:
Number of records per base and Z0102 recommended and current setup
Base | # Docs | Recommended| Current | Conflicts
--------------------+-------------+------------+------------+---------
DOCS |NEGATIVE BASE| No | Yes | *** Err ***
PHYEQ |NEGATIVE BASE| No | Yes | *** Err ***
“NEGATIVE BASE” in the “# Docs” column indicates that there are no records in the database that meet the search criteria (the Find command which you've defined in column 9 of tab_base.eng).
The formatting of the CCL statement in the alephe/tab/tab_base.eng table was 'off' - it looked like hard carriage returns were entered. I eliminated these carriage returns (using "SHIFT - J" in vi to join the lines).
! 1 2 3 4 5 6 7 8 9
!!!!!!!!!!!!!!!!!!!!-!-!!!!!!!!!!!!!!!!!!!!-!!!!!-!!!!!-!!!!!-!!!!!-!-!!!!!!!!!>
DOCS State Gov.Collection USM01 EXU01 USM01 Y alldocuments not (wst=suppressed or wst=deleted or wst=circ-created) and WRD=S
State Government Collection
PHYEQ Physics Equipment USM01 EXU01 USM01 Y alldocuments not (wst=suppressed or wst=deleted or wst=circ-created) and WSL=PHYEQ
Now when you execute UTIL-H-1-10 (in USM01) the "NEGATIVE BASE" message no longer appears.
Note that when you put exact text into tab_base.eng (i.e. "State Government Collection") if there is *any* variance of this text from one record to the next (e.g. one uses a capital letter; the next doesn't) the records that don't match "State Government Collection" verbatim will not be retrieved.
- Article last edited: 10/8/2013