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

Successful Execution Requirements and Controls

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

• The database may not be open for update anywhere.
• The database may or may not be open in any MUF for read.
• The database may or may not have any table in unloading status.

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

• The database may be open for update but must have no users.

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

• 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 Controls when MULTUSE=NO and either SEQ=NAT or SEQ=PHY,UPDATE=YES, Simplify YES, and MUF enabled

• The database will be opened for update if not already.
• All areas will be closed if open.
• The utility will execute with every ACCESS database or area status.
• The utility sets protection to block other incompatible DBUTLTY functions.

Environmental Requirements when SEQ=PHY,UPDATE=NO, Simplify NO, or MUF down

• 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 SEQ=PHY,UPDATE=NO, Simplify YES, and MUF enabled

• The database may be open for update or will be opened.

Environmental Requirements when MULTUSE=YES

• The database may or may not be open for update in the connected MUF
• The database may not be open for update in another MUF 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.
• When MULTUSE=YES, this function will not be allowed against a Data Sharing MUF if more than one is executing.

Environmental Controls when MULTUSE=YES

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