How to link z35 records to associated z30, z36, etc., records in SQL
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We have a problem (in SQL) linking z35 records to their associated z30's, z36's, etc. The problem is that the Z35-ITEM-SEQUENCE lacks leading zeroes while the Z30-ITEM-SEQUENCE and Z36-ITEM-SEQUENCE contain these zeros, for example, just "10" rather than "000010".
Resolution:
The following SQL can be used to build a key with a sequence number containing the necessary leading zeros:
Z35_REC_KEY || LPAD (Z35_ITEM_SEQUENCE,6,'0')
KB 16384-36721 has actual SQL showing this use of LPAD.
- Article last edited: 10/8/2013