- Article Type: General
- Product: Aleph
- Product Version: 14.2
Temp Borrower ID's are incorrect. The util g/2 parameters last-bor-id and last-bor-id2 have incorrect values. How can a determine the proper values and reset them?
The last-bor-id is used in assigning the ALEPH user id (the z303_rec_key). Its value would depend on what prefix you use. If you have no prefix, then this SQL will give you the highest value:
SQL-CUN50> select max(z303_rec_key) from z303;
If you have a prefix of 'ABC', then you would do this:
SQL-CUN50> select max(substr(z303_rec_key,4,9)) from z303 where substr(z303_rec_key,1,3) = 'ABC';.
You would then set last-bor-id = this value in util g/2.
- Article last edited: 10/8/2013