Can Z30_LINKING_NUMBER Contain Letters or Punctuation?
- 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