Question

Aleph 19 is changing the item process status from null to a blank space. Example queries from customer Aleph 19 installation:

SQL> select count(*) from z30 where z30_item_process_status is null;
8786982

SQL> select count(*) from z30 where z30_item_process_status = ' ';
82118

Is this how Aleph is supposed to be functioning? Do we have to update our existing Z30-records to Z30_ITEM_PROCESS_STATUS = blank?

Answer

Item records that were created and updated in Aleph 18 and lower and have empty process status have Z30_ITEM_PROCESS_STATUS = null.
Item records that were created and updated in Aleph 19 and higher and have empty process status have Z30_ITEM_PROCESS_STATUS = blank.

This is done by Oracle automatically and we are not aware of any problems in application because of this. You can leave the situation as it is.

Category: Cataloging (500)

Subject: Items (500)

• Article last edited: 10/8/2013