Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    How to determine the values for PDS-KEY-TYPE in abc50

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

    Description:
    Current setting of PDS-KEY-TYPE=02

    Current information in abc50/tab/tab100

    !# PDS-KEY-TYPE
    !# Values: Default:
    !# Type: Text; Max Length: 20
    !# tab100 of library: Yes; tab100_<server_type>: No.
    !
    ! Defines the Z308-KEY-TYPE against which all PDS authentications
    ! are verified.

    Resolution:
    Your tab100 should have the following in the header:

    !# PDS-KEY-TYPE
    !# Values: Default:
    !# Type: Text; Max Length: 20
    !# tab100 of library: No; tab100_<server_type>: No.
    !
    ! Defines the Z308-KEY-TYPE against which all PDS authentications
    ! are verified. Multiple key types may be defined by using a comma
    ! separator, such as 00,01.
    ! Note that the 00 type is mandatory when the authentication is compared
    ! with ALEPH. In any case it is highly recommended to add the 00 type.
    !

    If you want to see what you are using in your database you can use the following sequence of commands. In this example usr_library is defined as USR00, you'll want to change that in this example to match what you have defined for usr_library.

    At the command prompt on the server enter:
    s+ usr00

    At the sqlplus prompt enter:
    select Z308_VERIFICATION_TYPE, count(Z308_VERIFICATION_TYPE) from z308 group by Z308_VERIFICATION_TYPE;

    And you should see results like the following:

    Z3 COUNT(Z308_VERIFICATION_TYPE)
    -- -----------------------------
    00 218251
    01 7154
    02 28
    0

    4 rows selected.

    This shows that the majority of our records are Z308_VERIFICATION_TYPE (Z308-KEY-TYPE) of 00. That's why it is important to use that in the tab100. More than likely, for this example, tab100 would contain:
    PDS-KEY-TYPE=00,01,02

    Change abc50\tab\tab100 to whatever Z308_VERIFICATION_TYPE values you find in your usr_library.


    • Article last edited: 10/8/2013