z30_item_process_status in Aleph 19 and up
- Article Type: Q&A
- Product: Aleph
- Product Version: 19.01
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