Online processing in extract option

The Extract Options screen displays when you select option 3 from the Extract/Load Menu. It presents the legacy extract options available to you.

Extract Options screen

Specify DB2 Table Area

Entries are required.

Location ID

Location of the Db2 table.

Creator

ID of the person who created the Db2 table. Enter an asterisk (*) for a selection list.

Table Name

Name of the Db2 table, synonym, view or alias from which data is being extracted. Enter an asterisk (*) for a selection list.

Optional Area

Database

Name of the database. Use to limit selection list.

Tablespace

Name of the tablespace. Use to limit selection list.

Specify Selection Criteria Information Area

Selection Criteria Usage

Specify whether you want to use a previously saved selection criteria dataset. Selection criteria consists of conditions to limit and order column selection and/or row selection based on column values.

Specify the letter that represents the activity you want to perform:

T	Create Temporary extract selection criteria. The Criteria Display Format field determines the format used for the criteria.
M	View or modify existing saved extract selection criteria. The criteria contained in the selection criteria dataset is displayed in the format specified by the Criteria Display Format field.
E	Execute existing saved extract selection criteria. The criteria is not displayed.
N	Do not apply extract selection criteria. All rows for the object are extracted.

Criteria Display Format

Specify whether selection criteria is to be entered on the Template, or as native SQL. This field only applies when the Selection Criteria Usage field is T (Temporary), or M (Modify).

Specify the letter that represents the activity you want to perform:

T	Selection criteria is processed using the Template. If the SQL is unable to be parsed for display on the Template, then a pop-up window displays stating that the SQL cannot be parsed and you asking if you want to view the native SQL.
S	Selection criteria is processed in Edit using native SQL.

Criteria Dataset Name

If you specify M (Modify) or E (Existing) Selection Criteria Usage, specify an existing sequential or partitioned dataset with RECFM=FB and LRECL=80. File-AID for Db2 prefills this field with the name of the last specified selection criteria dataset.

If you specify T (Temporary) Selection Criteria usage, a temporary data set (hlq.userid.SYSyyddd.Thhmmss.SHOW.SQL) containing the SQL source is created. An ISPF edit session is initiated, enabling you to edit the SQL. If you want to save the SQL source, you must use the ISPF CREATE or COPY command to a permanent data set before exiting the edit session. The temporary data set will be deleted when returning to the Extract Options Screen.

Member

Specify the member of the data set you want to use. The field is prefilled with the last specified member name. If you leave this field blank or specify an asterisk (*), File-AID for Db2 displays the Member List for the data set. Specify a pattern, for example PART*, to narrow down the member list to the matching member names. The asterisk (*) is the only valid pattern character.

Specify Extract Options Area

Processing Mode

Enter the desired processing mode.

1	Enter 1 for online processing.
2	Enter 2 for batch processing. See Batch-processing-in-extract-option for further information.

Formatted Print Report

YES	Enter Yes to receive a printed report of the extract. The printer and output data set characteristics are specified on the Print Options screen in User Parms, Option 0.7 from the Primary Option Menu. See Print-Options for more information.
NO	Enter No if you do not want to receive a report.

Maximum Rows to Select

Enter a numeric value for the maximum number of rows to be extracted. Enter an asterisk (*) to select all rows.

Extract Null Indicators

YES	Default. Enter Yes to include null indicators in the extract data set. The null indicators appear as two bytes of low values for each null column in the table. They appear at the beginning of each record. If null indicators are included in the extract data set, the record length of the output data set is larger than if null indicators are not included.
NO	Enter No if you do not want the extract data set to include null indicators.

Use Uncommitted Read

Allows an application to bypass acquiring the locks that ensure no other user is updating the data being read. Bypassing the locks causes the application to run faster. The field is prefilled with the last specified value (YES or NO) or as specified with the UNCOMMITTED_READ_DEFAULT parameter of the Db2 Environment PARMLIB member. For more information, see UNCOMMITTED_READ_DEFAULT in the Db2 environment.

Warning

If you choose the Use Uncommitted Read option, and the application fails and backs out the updates, then the rows read by the application using uncommitted read could be invalid.

NO	Default. Enter NO if you do not want the application to bypass acquiring the locks which ensure that no other user is updating the data being read.
YES	Enter YES if you want the application to bypass acquiring the locks which ensure that no other user is updating the data being read. If you enter YES, the rows read by the application using uncommitted read could be invalid.

Selection Criteria Member List

The Selection Criteria Member List displays if you left the Selection Criteria Member field blank (or entered a *) on the Extract Options screen. It provides a list of all members of the specified Selection Criteria dataset.

Selection Criteria - EXTRCRIT

Sel

Enter the S line command to select one of the listed members as your selection criteria.

Member Name

Lists all member names of the selection criteria dataset.

Extract Table List

The Extract Table List window displays when an asterisk was entered in either the Creator field or the Table Name field of the Extract Options screen. It presents a list of tables, views and aliases (see the following figure).

Extract Table List Window

Cmd

Enter S to select a table to be extracted. The Extract Selection Template screen displays when you press Enter.

Creator

Displays the creators of the tables, views, or aliases.

Table

Displays the names of the tables, views, aliases, history, or archive tables.

Type

Indicates either TABLE, VIEW, ALIAS, HIST, or ARCHV.

EXTRACT Selection

The EXTRACT Selection Template screen (Extract Selection Template) displays after you complete the Extract Options screen (Extract Options Screen). The screen is used to identify the columns to be extracted, indicate the order of extraction, and to provide selection criteria for extraction of specific rows of data.

If you are using an existing Extract Criteria Dataset the SEL column is already prefilled with the selections from the Extract Criteria Dataset. You can then either accept or modify them as desired.

Important

You achieve “Full Table Extract” by NOT selecting any columns in the SEL column when entering the EXECUTE command.

If triggers exist on the extract table, the message ‘Triggers not activated’ displays in the upper right-hand corner of the EXTRACT Selection Template screen.

Extract Selection Template

Table Name

Creator ID and name of the Db2 table, synonym, view or alias from which data is being extracted.

Max Rows to Select

Enter the maximum number of rows to be extracted.

SEL

Enter S next to the columns from which you want data extracted.

Key/Index Indicator

(Untitled 1 byte field) Indicates P Primary key, F Foreign Key, or I High Order Index key (if not Primary or Foreign) for the column as an aid for users to create SQL that will perform well.

COLUMN NAME

Displays the names of the columns in the table, view, or alias.

TYPE(LEN)

Displays the type and length of data in each column.

Distinct types are identified by their names.

Important

Columns with type LOB or distinct based on LOB do not appear on the template selection screen as they cannot be extracted.

ORDER

Specify an integer to define how the extracted rows should be sorted in the unload data set, based on the data content of the columns. Entering 1 indicates the primary sort column.

A/D

Indicate whether ordered columns are to be sorted in ascending (A) or descending (D) order. If neither is specified, A is the default.

WHERE

Enter WHERE clauses to limit row selection. The WHERE field can be scrolled left and right. To scroll the WHERE field to the right, place the cursor in the WHERE field and press PF11. To scroll to the left, place the cursor in the WHERE field and press PF10. Scrolling allows you to view up to 256 characters.

The following delimiters can be used in the clauses:

>	OR	< >
<	> =	BETWEEN
=	< =	IN
¬ =	¬ >	LIKE
AND	¬ <	NOT

Special considerations for distinct (UDT) data type columns: File-AID for Db2 generates the appropriate CAST function for simple WHERE clauses that contain just one of the following operators:

>	> =	< >
<	< =	¬ <
=	¬ =	¬ >

For all other WHERE clauses, you must enter the CAST function manually.

Press END (PF3) to return to the Extract Db2 - Driving Object panel.

Executing or Saving Template, or Viewing/Editing SQL

After the appropriate selection criteria has been provided, you can execute or save the Template Selection Criteria, or view/edit the SQL. You can also view an alternate display of the template.

Use EXEC to Continue

Type EXECUTE on the command line and press Enter, or press the associated PF key to process the request. The Extract Table screen displays.

SQL to View/Edit SQL Source

Type SQL on the command line, and press Enter. File-AID for Db2 generates all SQL for the current function and places the SQL statements into a data set.

If you specify M-Modify or E-Existing Selection Criteria Usage, this data set must be an existing sequential or partitioned dataset with RECFM=FB and LRECL=80. The data set name is specified on the options panel in the Selection Criteria Dataset Name field. View/edit the data set, and then press END (PF3) to save any changes and exit the window.

If you specify T-Temporary Selection Criteria usage, a temporary data set containing the SQL source is created. An ISPF edit session is initiated, enabling you to view/edit the SQL. If you want to save the SQL source, you must use the ISPF CREATE or COPY command before exiting the edit session.

SAVE

Type SAVE at the command line and press Enter. The Selection Criteria Dataset Specification window (see the following figure) displays. This allows you to save the current Template Selection Criteria to a data set.

Selection Criteria Dataset Specification Window

Dataset

Specify the name of the data set you want the selection criteria to be saved to. File-AID for Db2 prefills this field with the name of the last specified selection criteria dataset name.

Member

Specify the member of the data set you want to save the selection criteria to.

Press END if you do not want to save the current selection criteria to a data set. You are returned to the EXTRACT Selection Template.

SIZE

The SIZE command provides an alternate display of the Extract Selection Template which allows 58 positions of the WHERE clause to be displayed, and does not include all of the lines on the original display. The alternate display is designed to maximize the amount of rows displayed on the panel, so that you have a larger area to build a WHERE clause.

Type SIZE at the command line and press Enter. A panel is displayed (see the following figure) with only the Column name and WHERE columns displayed. Enter SIZE again to return to the original display of the Extract Selection Template.

Alternate Display of Extract Selection Template

Selection Template Not Prefilled

The Selection Template screen cannot be prefilled when there is an error processing the selection criteria. These errors could include:

A mismatch between the table name in the SELECT statement of the Extract Criteria data set and the one specified in the Table field of the Extract Options screen.
The specified criteria does not contain a valid SELECT statement.
The data set is empty.

Selection Template Not Prefilled

Now you have several choices:

Select option 1 to execute the SQL of the existing Selection Criteria Dataset. If it contains a valid SELECT statement you can then extract the table specified in the selection criteria.
Select option 2 to view and edit the SQL of the existing Selection Criteria Dataset before executing it. If the data set or data set member is empty or non-existing you can insert a SELECT statement in the Edit SQL Selection screen. See also SQL Entry and Edit SQL Select. You then extract the table specified in the SELECT statement.
Specify option 3 to cancel and return to the Extract Options screen where you can:
- Select a different creator and table combination that match the table name of the Extract Criteria.
- Specify NO in the Use Existing Criteria field.
- Specify a different Extract Criteria data set member combination that matches the creator and table combination.

SQL Entry

The SQL Entry Panel (see the following figure) displays after you have return from being in SQL mode. The panel prompts you for the name of a input criteria data set and a member name. The data set can have a previously saved SELECT statement or it can be empty, allowing you to enter a new SELECT statement. If the data set contains more than one SELECT statement, only the first statement is executed.

SQL Entry Panel

Specify Input Dataset Name Area

Criteria Dataset Name

Name of the data set in which the SQL query resides or will reside. Prefilled with the Edit Criteria dataset name.

Member

Specify the desired member.

Specify Processing Options Area

Maximum Rows to Select

Maximum number of rows to be extracted from the table, view, or alias. An asterisk in the field indicates all rows are to be extracted. Only the first SELECT command in a data set is executed.

Edit SQL

Specify whether you want to edit the SQL before it is executed.

If the value of the Edit SQL field is YES, pressing Enter displays the Edit SQL Selection screen. If the value of the Edit SQL field is NO, pressing Enter executes the SQL statement immediately.

Edit SQL Select

The Edit SQL Select screen displays when you enter the name of the data set containing your SQL SELECT statement and YES in the Edit SQL field on the SQL Entry Panel. On this screen you can enter a new SELECT statement or alter the existing one. The statement should be in standard SPUFI format. Save the statement by pressing END and then press Enter from the SQL Entry Panel to proceed to the Extract Table screen (Extract Table Screen).

Edit SQL Screen with Sample Select Statement

Extract Table

The Extract Table screen is displayed once you identify the extract table and the extract criteria. Use it to specify the extract and control card output data sets. If you want to create a record layout of the extracted data, use this screen to specify the data set name and the language in which you want it created (COBOL or PL/I).

Important

If you create a record layout of the extracted data in COBOL, the layout name will be missing the table creator in the COBOL layout 01 level.

File-AID for Db2 prefills the data set names with fully-qualified data set names constructed from the user’s ID and the object name. These data set names may be modified, if necessary. The following figure shows a sample screen.

Extract Table Screen

Specify Extract Dataset Format

Extract Dataset Format

Specify whether the data should be extracted in standard Db2 or delimited file format. You must enter either a 1 or 2, or you receive the error message “Invalid value”.

Enter a 1 for standard file format.

Enter a 2 for delimited file format.

Important

Extracted data in delimited file format cannot be loaded using File-AID for Db2’s Load utility (see also Load Dataset).

Change Delimited Options

Specify whether you want to change the current delimited file format options or not. You must enter either Yes or No when you specify delimited format. Enter Yes to view and change the current options (see Delimited Format Options). Yes is only valid for delimited file format. Enter No if you do not want to change the current delimited options or if you want the standard extract data set format.

Specify Disguise Information

Disguise Extract File

Specify whether or not to disguise data in for this extract file.

Data Disguise requires installation of File-AID/Data Solutions Release 4.1 or higher. Before submitting an extract request with data disguise, you must specify the disguise criteria using Option 7, Data Disguise.

Yes	The extracted data will be disguised according to the disguise criteria specified in the Disguise Control File. When the Extract Confirmation screen displays, the message DISGUISED will display on the unload data set (see Extract Confirmation Screen).
No	Don’t disguise any data for this extract.

Disguise Control File

Specify the name of the Disguise Control File that contains the disguise criteria for this extract. Disguise Control Files can be created in Option 4, Control - Allocate Control Disguise File. The disguise criteria is specified using Option 7, Data Disguise.

Hints

- Before you submit the disguise job, make sure that the Disguise Control File includes the desired disguise criteria for the object included in the extract file.
- It is also recommended that the relationship information in both the extract and Disguise Control File matches.
- Also, when using disguise rules with complex criteria, the criteria must be based upon the object that is being extracted.

Create audit trail

Specify whether or not the File-AID/Data Solutions disguise process should produce an audit trail report for each object whose data is subject to be disguised.

Yes	Create audit trail reports using File-AID/Data Solutions audit trail exits. Note that the File-AID/Data Solutions audit trail exits determine if a report is created and what is reported.
No	Don’t create audit trail reports.

Audit trail prefix

Specify the prefix for the File-AID/Data Solutions audit trail reports for this extract. Prefix plus USERID can be up to 14 positions, the remainder of the data set name will follow the above mentioned naming convention. If prefix is blank, only the USERID will be used. Any value specified will be appended to the USERID. Precede the prefix value with a single quote (‘) to use the value without the USERID.

Specify Output Datasets Area

DSN Qualifier

The qualifier that replaces the asterisk (*) in the above data set names.

Extract Dataset

The name of the data set which will contain the extracted data. The second level qualifier is an asterisk (*) that will be replaced with the table name specified below. The data set may be either sequential, partitioned, new or existing. If the data set exists, its LRECL must be greater than or equal to the calculated record length of the output data record. If its LRECL is less than the required minimum or its DSORG is invalid, a warning window (Extract Warning Window) displays asking you whether you wish to DELETE and Reallocate the data set or NOT.

If the data set is new, Extract Dataset Allocation Screen is displayed. It may be allocated as either sequential or partitioned. The default is to create the data set as sequential.

Member

If the file is a partitioned data set, enter an existing or new member name. Enter an asterisk (*) to select a member from a member list.

Control Card Dataset

The name of the data set which will contain information about the structure of the data. The second level qualifier is an asterisk (*) that will be replaced with the table name specified below. The data set may be either sequential, partitioned, new or existing. The report displayed in Detailed Load Report: Control Card Input shows an example of control card data.

If the data set is new, Control Card Datset Allocation Screen is displayed. It may be allocated as either sequential or partitioned. The default is to create the data set as sequential. with an LRECL of 80. The LRECL cannot be changed.

Member

If the file is a partitioned dataset, enter an existing or new member name. Enter an asterisk (*) to select a member from a member list.

Important

Control Card Dataset will not be created for delimited extract file format.

Create Layout File

Enter YES to generate a COBOL or PL/I record layout when File-AID for Db2 performs the extract. If you enter YES, you must supply values for the LAYOUT DATASET and LANGUAGE fields. Valid only with standard extract format.

Layout Dataset

The name of the data set which will contain a COBOL or PL/I record layout based on the extract dataset. The second level qualifier is an asterisk (*) that will be replaced with the table name specified below. The data set may be either sequential, partitioned, new or existing.

If the data set is new, Record Layout Dataset Allocation Screen is displayed. It may be allocated as either sequential or partitioned. The default is to create the data set as sequential with an LRECL of 80. The LRECL cannot be changed.

Important

When File-AID for Db2 creates a COBOL record layout, an underscore (_) in any object name is converted to a dash (-).
Prior to Db2 Version 8, the COBOL 01 level had the creator.table name. With Db2 Version 8, the creator name was dropped since the creator.table name can be more than 30 characters long. (For Release 4.8 and higher: The COBOL layout 01 level has only the table name, due to the maximum creator and table length combined is too long.)

Member

If the file is a partitioned dataset, enter an existing or new member name. Enter an asterisk (*) to select a member from a member list.

Language

Enter a 1 for COBOL to generate a COBOL record layout. Enter a 2 for PL/I to generate a PL/I record layout.

Delimited Format Options

The Delimited Format Options screen displays once you specified YES to the Change Delimited Options prompt on the Extract Table Screen or specified D to the Add Selection Criteria prompt on the Extract DB2 - Driving Object screen. This screen shows the current options for the delimited extract file format. Use it to modify the options as needed to later download the extracted data. The modified options are saved until they are changed again. The following figure shows a sample screen with prefilled options.

Delimited Format Options Screen

Specify Delimited Format Options

Quotation Marks

Specify which quotation marks, single (’) or double (“) should be used in the delimited file format. Double quotation marks are the initial default. Enter a 1 for single quotation mark. Enter a 2 for double quotation mark.

Column Delimiter

Specify which character should be used as the column delimiter. The column delimiter marks the end of the previous and the beginning of the next column. Any displayable character, including blank character, is acceptable. Comma (,) is the initial default.

Use Quotes on Character Data

Specify whether character data will be enclosed by quotation marks. When set to YES (initial default), the output looks like “JONES”,”MARY”. Numbers containing special characters, for example date fields, are considered character data. For example, if set to YES the date field could look like this “1995-09-29”. When set to NO output would look like this: JONES,MARY or 1995-09-29.

Important

VARCHAR columns are expanded to their maximum length and padded with blanks.

Use Quotes on Numeric Data

Specify whether numeric data will be enclosed by quotation marks. When set to YES, the output looks like “12345”,”6789”. There should not be any decimal points specified for fixed or floating point decimal columns. When set to NO, the output looks like 12345,6789. NO is the initial default.

Extract Column Names

Specify whether column names will be included as the first row in the extract file. Column names follow the same format as for Character data. An example is “EMPLOYEE_ID”,”LASTNAME”,”FIRSTNAME” etc. If YES, the extract file includes all column names regardless how many columns are extracted. The initial setting is NO.

Date Format

Specify the format to mask date data. Any valid date format is acceptable, for example YYYY/MM/DD, DD.MM.YYYY, or MM/DD/YY. The initial date format is the same as the installation default for date format.

Extract Warning Window

The Extract Warning window (see the following figure) displays if the LRECL of the extract dataset you specified on the Extract Table screen (Extract Table Screen) is less than the required minimum for this table or if its DSORG is invalid. File-AID for Db2 will delete the existing extract dataset and re-allocate it with the required allocation values.

Extract Warning Window

Proceed

Enter Y and File-AID for Db2 will delete the existing extract dataset, then present the Extract Dataset Allocation Screen to re-allocate it with the required allocation values.

Enter N and File-AID for Db2 will NOT delete the existing extract dataset. You can then specify a different extract dataset name.

Extract Dataset Allocation

The Extract Dataset Allocation screen (see the following figure) displays if the extract dataset you specified on the Extract Table screen (Extract Table Screen) does not exist. When you have completed your entries, press Enter.

Extract Dataset Allocation Screen

EXTRACT DATASET

Name of the output extract dataset prefilled from the previous screen. May not be changed.

MEMBER

Member name of the output extract dataset. Prefilled if entered on the previous screen. May not be changed.

VOLUME SERIAL

Name of the disk pack where the data set will reside.

GENERIC UNIT

Site-defined device type (SYSDA, for example).

Important

Space attributes are set to defaults defined during installation.
If you are extracting to tape in batch mode specify the site specific valid tape unit in this field. The initial default value is CART.
If you have only access to a different tape unit you cannot change the required FITAPE variable tape unit name to the one you can access until you edit the resulting JCL.

SPACE UNITS

The type of space unit used to define the data set. Valid entries are TRKS (tracks) or CYLS (cylinders).

PRIMARY QUANTITY

Number of space units allocated for the data set.

SECONDARY QUANTITY

Amount of space allocated for the data set if it exceeds the primary quantity.

DIRECTORY BLOCKS

Enter the number of directory blocks for the data set. The default is zero (sequential). If a member name is specified on the Extract Table screen (Extract Table Screen), a value greater than zero should be entered. If no member is specified on the Extract Table screen and the number of directory blocks is changed to a value greater than zero, File-AID for Db2 creates a member named “TEMPNAME” in the unload data set.

RECORD FORMAT

(Display only) Indicates how the data in the data set is structured: fixed blocked or variable blocked.

RECORD LENGTH

(Display only) File-AID for Db2 calculates the record length of the extract dataset based on the columns selected.

BLOCK SIZE

Size of each block of data. This value may be modified for more efficient use of disk space, or to comply with your site’s standards. If you enter a block size that is less than the record length, File-AID for Db2 sets a block size that is the same as the record length.

Control Card Dataset Allocation

The Control Card Dataset Allocation screen, displays if the control card dataset you specified on the Extract Table screen (Extract Table Screen) does not exist.

Control Card Dataset Allocation screen

CONTROL CARD DATASET

The name of the control card dataset. This name is prefilled from the Extract Table screen (Extract Table Screen). May not be changed.

MEMBER

Member name of the control card dataset, prefilled from the previous screen if entered. May not be changed.

VOLUME SERIAL

Name of the disk pack where the data set will reside.

Important

Space attributes are set to defaults defined during installation.

GENERIC UNIT

Site-defined device type (SYSDA, for example).

SPACE UNITS

The type of space unit used to define the data set. Valid entries are TRKS (tracks) or CYLS (cylinders).

PRIMARY QUANTITY

Number of space units allocated for the data set.

SECONDARY QUANTITY

Amount of space allocated for the data set if it exceeds the primary quantity.

DIRECTORY BLOCKS

RECORD FORMAT

(Display only) Indicates how the data in the data set is structured: fixed blocked or variable blocked.

RECORD LENGTH

Maximum record length. This value defaults to 80 and cannot be updated.

BLOCK SIZE

The size of each block of data in the data set. This value may be changed for more efficient use of disk space, or to comply with site standards.

Record Layout Allocation

The Record Layout Dataset Allocation screen displays if the record layout dataset you specified on the Extract Table screen (Extract Table Screen) does not exist.

Record Layout Dataset Allocation Screen

RECORD LAYOUT DATASET

The name of the record layout dataset. This name is prefilled from the Extract Table screen (Extract Table Screen) and may not be changed.

MEMBER

Member name of the record layout dataset, prefilled from the previous screen if entered. May not be changed.

VOLUME SERIAL

Name of the disk pack where the data set will reside.

Important

Space attributes are set to defaults defined during installation.

GENERIC UNIT

Site-defined device type (SYSDA, for example).

SPACE UNITS

The type of space unit used to define the data set. Valid entries are TRKS (tracks) or CYLS (cylinders).

PRIMARY QUANTITY

Number of space units allocated for the data set.

SECONDARY QUANTITY

Amount of space allocated for the data set if it exceeds the primary quantity.

DIRECTORY BLOCKS

RECORD FORMAT

Indicates how the data in the data set is structured: fixed blocked or variable blocked.

RECORD LENGTH

Maximum record length. This value defaults to 80 and cannot be updated.

BLOCK SIZE

The size of each block of data in the data set. This value may be changed for more efficient use of disk space, or to comply with site standards.

Extract Confirmation

The Extract Confirmation screen (Extract Confirmation Screen), displays after the unload, control card, and layout data sets are established. If all the data sets exist, the Extract Confirmation screen displays immediately after the data set names have been entered on the Extract Table screen (Extract Table Screen).

The Extract Confirmation screen displays the name of the table from which the data will be extracted, as well as the output extract format, names and status of the unload, control, and layout data sets. All fields on this screen are protected and cannot be modified.

To begin the extract process, press Enter. The message Extract in Progress displays. To terminate processing, press END.

Extract Confirmation screen

Table Name

Name of the table being extracted.

Output Extract Dataset Format

Identifies the output extract dataset format, either Standard or Delimited.

Output Extract Dataset

Name of the output extract dataset.

DISGUISED

If disguise is requested during the extract process, the message DISGUISED is displayed next to the output extract dataset to indicate that the file will be disguised.

Status

Status of the extract dataset: NEW or OLD.

Output Control Card Dataset

Name of the output control card dataset. Only for standard extract format.

Status

Status of the control card dataset: NEW or OLD.

Output Layout Dataset

Name of the output record layout dataset, if provided. Only for standard extract format.

Status

Status of the record layout dataset: NEW or OLD.

When you press Enter on the Extract Confirmation screen, the message Extract in Progress displays.

Online Extract Summary

When online extract processing has been completed, a window displays in the center of the Extract Confirmation screen (see the following figure). This window indicates whether or not the extract was successful or unsuccessful, the number of records extracted, and whether or not the extract file is disguised.

Extract Confirmation Screen with Report Pop-Up

Extract was successful/unsuccessful

The extract process is successful if records are extracted. If a Db2 error is encountered, the extract is unsuccessful.

The extract process is also unsuccessful when the disguise initialization has failed.

Number of Records were extracted

The number of rows extracted from the target object.

Extract File is/is not disguised

The extract is disguised if records are extracted and disguise criteria is applied. If you have a Disguise Control File but no criteria defined, than the extract file is not disguised.

1 header record added to extract file

One header record with the name of the Disguise Control File has been added to the disguised extract file.

If you press END (PF3) from the Extract Summary Report the Extract Options screen (Extract Options Screen) is displayed. If you press Enter from the Extract Summary Report, the detailed extract report is displayed.

Detailed Extract Report

When you press Enter from the Extract Summary Report, the detailed extract report (Browse Detail Report) is displayed. This detailed report combines the disguise report, the File-AID/Data Solutions output report, and the File-AID for Db2 extract report. This detailed extract report resides in a temporary data set. The data set is discarded unless you save it using the appropriate ISPF commands (CREATE or COPY).

Important

If the detailed extract report is not displayed when you press Enter, this indicates that due to RACF/ACF2 restrictions, your site is not allowed to allocate a temporary data set with the USERID as the High Level Qualifier (HLQ). In this case, a value must be entered for variable TEMPORARY_WORKFILE_HIGH_LEVEL_QUALIFIER= in the File-AID for Db2 PARMLIB member (FAFDnnnn). For more information, see TEMPORARY_WORKFILE_HIGH_LEVEL_QUALIFIER in the File-AID for Db2 product configuration.

Browse Detail Report