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

Description:
We need to put block on a few hundreds patrons: to block them check out, renew and put holds on.

Is there a way to do it automatically? Later we will delete those patrons from the system or unblock them.

Can I run sql to update z305 tables on ABC50 ... or how I do it?

Resolution:
There is no Service for doing this.

The following SQL can be used in the ADM library. You would need to supply the appropriate "where" clause:

SQL> update z305 set z305_loan_permission = 'N', z305_renew_permission = 'N', z305_hold_permission = 'N' where ...

You should do p_file_03 to back up the z305 table prior to running such SQL.

• Article last edited: 10/8/2013