Borrower ID's incorrect; last-bor-id and last-bor-id2 have incorrect values

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

Description:
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?

Resolution:
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:

s+ cun50
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.