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

    Can Z30_LINKING_NUMBER Contain Letters or Punctuation?

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Can Z30-LINKING-NUMBER contain a value separated with a dot?.
    Example:.
    Z30-LINKING-NUMBER = DRA <ITEM_LINK> + "." + DRA <ITEM_SEQUENCE>.
    (where <ITEM_LINK> and <ITEM_SEQUENCE> will be 4-digit numbers left-padded with zeroes).
    Would it affect ALEPH functionality?

    Resolution:
    The Z30_LINKING_NUMBER is defined as "NUMBER (9)" to Oracle. This means that it is a maximum of 9 bytes and is intended to contain only numbers..
    When I did this SQL:.
    update z30 set z30_linking_number = '111.222' where z30_rec_key = ....
    The resulting z30_linking_number looked like this:.
    000000111.
    that is, the ".222" was omitted.

    • Article last edited: 10/8/2013