Moving the Z30-CIRCULATION-NOTE field to the Z30-NOTE-INTERNAL field as part of Alma migration
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
How to move the Z30-CIRCULATION-NOTE field to the Z30-NOTE-INTERNAL field as part of Alma migration.
Resolution
The following SQLs were used to do this. Note: they *must* be done in this order.
SQL> update z30 set z30_note_internal = ( rtrim(z30_note_internal) || '. ' || rtrim(z30_note_circulation) ) where Z30_NOTE_INTERNAL is not null and z30_note_circulation is not null;
SQL> update z30 set Z30_NOTE_INTERNAL = z30_note_circulation where Z30_NOTE_INTERNAL is null and z30_note_circulation is not null;
SQL> commit;
- Article last edited: 24-Jun-2020