EXTRACT (Extract Data Table) › EXTRACT › Successful Execution Requirements and Controls

Successful Execution Requirements and Controls

Environmental Requirements when MULTUSE=NO and either SEQ=NAT or SEQ=PHY,UPDATE=YES

• The database may not be open for update anywhere.
• The database may or may not be open in any Multi-User Facility for read.
• The database may or may not have any table in unloading status.

Environmental Controls when MULTUSE=NO and either SEQ=NAT or SEQ=PHY,UPDATE=YES

• The database will be opened for unloading status.
• The utility has no knowledge about current ACCESS database or area status.
• The utility sets no ACCESS database or area status.

Environmental Requirements when SEQ=PHY,UPDATE=NO

• The database may or may not be open for update or read or unloading anywhere.
• The database will not be opened for read or update or unloading.
• This option has no requirements, it provides no protection.

Environmental Requirements when MULTUSE=YES

• The database may or may not be open for update in the connected Multi-User Facility
• The database may not be open for update in another Multi-User Facility or Single User job.
• The database may not have any table in unloading status.
• The database ACCESS must be set OPTIMIZE and WRITE/READ/UTLTY.
• The area ACCESS must be set WRITE/READ/UTLTY.
• The area may have no table in an open URT with UPDATE=YES.
• The area may not have any other MULTUSE=YES utility executing.

Environmental Controls when MULTUSE=YES

• The database will be opened by Multi-User Facility for update.
• The database will have no unloading status set.
• The utility sets ACCESS area READ (utility set).
• The utility sets EXTRACT executing this Multi-User Facility this database or area.