Single panel extract driving object
Extract - Db2 driving object
The following figure is displayed when your profile specifies that the driving object for an extract is a Db2 table, or you enter the DB2 command in the Extract - MVS Driving Object screen.
Use this screen to specify a Db2 table to drive the extract.
Extract - DB2 Driving Object
OPTION ===> Scroll ===> CSR
TSOID01 Profile: FRSAMPQK
Primary commands: MVS driving object, EDIT JCL, GO to submit job
Specify table to drive extract process from:
SSID ===> DSN
Location ===> (* or pattern for selection list)
Creator ===> FRSAMP (* or pattern for selection list)
Table Name ===> (* or pattern for selection list)
Specify Extract Options:
Edit Object Selection Criteria ===> N (Y = Yes; N = No) *Defined*
Maximum Rows to Select ===> (* for all rows)
Use Uncomitted Read ===> (Y = Yes; N = No)
Extract IMPLICITLY HIDDEN columns ===> N (Y = Yes; N = No)
SELECT FROM Temporal Table ===> (Y = Yes; N = No) *None*
Specify Extract "TO" File Information:
File name ===> FRSAMP.EXTRACT
Format Unicode Data ===> (1 = Extract as Unicode; 2 = Convert Unicode)
Edit Data Privacy Spec ===> (Y = Yes; N = No) *DCF*
Relationship Information:
File name or pattern ===> 'TSOID01.FRSAMP.RELATION'
The *Current Values* indicators to the right of certain extract option fields are display fields only and are updated upon return from each of the extract options to reflect the current status and value for the option.
The body of this screen consists of the following fields:
Specify Table To Drive Extract Process From Area:
Use the fields in this area to specify the Db2 table for which you want to retrieve relationship information from the relationship file so you can extract related data. When specifying patterns in the fields, File-AID/RDX searches the relationship file and presents selection lists.
SSID
Displays the current Db2 subsystem ID as specified in your profile. Type over this field to connect to a new Db2 subsystem. If you leave the Location field blank, the table you specify to drive the extract must exist in the Db2 subsystem displayed here.
Location
Specify the location ID of the table you want to drive the extract if it resides in a remote Db2 subsystem. The location you enter must be defined in the Db2 system catalog table, SYSIBM.LOCATIONS.
Leave this field blank if the table you want to drive the extract is in the Db2 subsystem in the SSID field.
Creator
Specify the authorization ID of the owner of the table, view, synonym, or alias that you want to drive the extract process. You can enter a pattern in this field. Valid pattern characters are %, _, and * (see Pattern Characters). If you specify a pattern, File-AID/RDX searches the Db2 catalog and displays matches in a Table List pop-up window.
Table Name
Specify the name of the table, view, alias, or synonym that you want to drive the extract process. For more information about how File-AID/RDX supports view, aliases, and synonyms in Extract, see Use of Db2 Views and Use of Aliases and Synonyms. For more information on how File-AID/RDX determines what relationship definition to use for the driving object, see Relationship Listing Window for Db2 Objects.
You can enter a pattern in this field. Valid pattern characters are %, _, and * (see Pattern Characters). If you specify a pattern, File-AID/RDX searches the Db2 catalog and displays matches in a Table List pop-up window.
Specify Extract Options Area:
Edit Object Selection Criteria
Enter Yes so you can specify selection criteria for the driving table. File-AID/RDX will display the Db2 Object Selection Criteria screen when you press Enter. However, if the extract request is a single Db2 table extract with Selective Columns and/or Delimited extract file, the Object Selection Criteria - Selective Columns screen shown in Object Selection Criteria - Selective Columns displays.
Enter No to extract all rows from the driving table.
Current Values displays *Defined* if selection criteria has already been defined.
Maximum Rows to Select
Specify the maximum number of rows you want to extract from the driving object. Enter an asterisk (*) to retrieve all rows that meet selection criteria. This value is applied after the selection criteria for the driving object has been applied.
Use Uncommitted Reads
Specify whether File-AID/RDX should extract data from Db2 objects that include Uncommitted Reads or not.
The field is prefilled with the specified UNCOMMITTED_READ_DEFAULT configuration parameter value (Yes or No) of the Db2 Environment PARMLIB member or with the current profile value (Yes or No) if UNCOMMITTED_READ_DEFAULT is set to blank (default, see also UNCOMMITTED_READ_DEFAULT in the Db2 environment).
Extract IMPLICITLY HIDDEN columns
Specify whether File-AID/RDX should extract data from Db2 columns that are defined as IMPLICITLY HIDDEN. When this option is set to Y, the resulting File-AID/RDX extract file will include the data from IMPLICITLY HIDDEN columns.
SELECT FROM Temporal Table
Enter Yes if you want to specify or modify a time-period and date/timestamps for Temporal Tables or Temporal Views. File-AID/RDX will display the SELECT-FROM-Temporal-Table-panel screen when you press Enter. Temporal table support requires Db2 Version 10 or more recent. Starting with Db2 Version 11, temporal support allows period specifications and period clauses to be specified for views. The same rules apply for views as do for tables.
Enter No (default) if you don’t want to display the SELECT-FROM-Temporal-Table-panel screen.
The status *Defined* displays if a SELECT FROM Temporal Table statement has already been defined, otherwise *None* displays.
If you want to extract data from temporal tables or views without a SELECT FROM Temporal Table statement, make sure *None* displays. To change the status from *Defined* to *None*, enter Yes in the SELECT FROM Temporal Table field, then set the Use System Time and Use Business Time to No in the SELECT-FROM-Temporal-Table-panel screen.
Specify Extract "TO" File Information Area:
Use this area to specify the following extract output information:
Extract File name
Specify the name of the file to which data will be extracted. Include the member name (in parentheses) when the file is a PDS. For more information on the extract file, see Extract File and File-AID/RDX Extract File. If you specify a pattern, select a sequential file from the “Catalog Utility File List” (MVS Catalog Utility File List (for Pattern FR*.ORDERTAB) after you entered one of the primary commands. Remember, File-AID/RDX will not prompt for a member.
Format Unicode Data
Specify whether data extracted from Db2 tables with Unicode encoding is written to the extract file in Unicode or EBCDIC format (see also profile value Db2 Format).
1 | Unicode option will write the data using Unicode encoding. |
2 | Compatibility format will maintain the conversion to EBCDIC encoding used in previous releases. |
Edit Data Privacy Spec
Specify whether you want to change the current data privacy specifications. When data privacy has been specified, File-AID/RDX will disguise the extracted data as part of the extract batch job according to the disguise criteria defined in the Disguise Control file (DCF) or in the Dynamic Privacy Rules Project (DPR). When you enter Y, File-AID/RDX will display the Data Privacy Specification screen so you can change the current setting.
Current Values displays *DCF*, *DPR*, or *None* for the selected disguise option.
Relationship Information Area:
Use this area to specify the following relationship information:
File name or pattern
Specify the name of the file that contains the referential integrity and application relationship information you want to use for the extract process. If you specify a pattern, select a file from the “Catalog Utility File List” (see MVS Catalog Utility File List (for Pattern FR*.ORDERTAB).
Primary Commands
The following File-AID/RDX-specific primary command is valid on this screen:
EDIT (E)
Displays the JCL for this extract request. File-AID/RDX shows the Generated JCL panel where you review and modify the extract JCL.
GO (G)
Submits this extract request. Before issuing the GO command, make sure you have completed all the extract information. File-AID/RDX will also issue a message upon completion of the job.
MENU
Switches from this panel to the full Extract Menu. Only valid when profile setting Display Extract Menu is set to Y.
MVS (M)
Switches from this panel to the single panel Extract - MVS Driving Object prefilled with the applicable information from your current profile. See Extract - MVS Driving Object.
Use of Db2 Views
File-AID/RDX supports views of Db2 tables in the Extract function. If you specify a view as the driving table, File-AID/RDX lists relationships defined for the view, not the underlying base table. File-AID/RDX then extracts data from the view specified as the driving table/view and from all tables and views related to the driving table/view.
Use of Aliases and Synonyms
File-AID/RDX supports aliases and synonyms of tables in the Extract function. If you specify an alias or synonym as a driving table, File-AID/RDX lists relationships associated with the base table and extracts from the base tables.
Extract - MVS Driving Object
The Extract - MVS Driving Object screen shown in the following figure is displayed when your profile specifies that the driving object for an extract is an MVS file, or you enter the MVS command in the Extract - Db2 Driving Object screen.
Use this screen to specify the name of the MVS file for which you want to extract related data.
Extract - MVS Driving Object
OPTION ===> SITE Profile: RDXQUICK
Primary Commands: DB2 driving object, Edit JCL, Go to submit job
Specify file to drive the extract process from:
File ===> FRSAMP.ORDERTAB
Optional File Information:
Record layout usage ===> (S = Single; X = XREF)
Record layout file ===>
Member name ===> (Blank or pattern for member list)
XREF file ===>
Member name ===> (Blank or pattern for member list)
Specify Extract Options:
Edit Object Selection Criteria ===> N (Y = Yes; N = No) *Defined*
Specify Extract "TO" File Information:
File Name ===> FRSAMP.EXTRACTM
Edit Data Privacy Spec ===> (Y = Yes; N = No) *DCF*
Relationship information stored in:
File Name ===> FRSAMP.RELATION
The *Current Values* indicators to the right of certain extract option fields are display fields only and are updated upon return from each of the extract options to reflect the current status and value for the option.
The body of this screen consists of the following fields:
Specify File To Drive The Extract Process From Area
Use the fields in this area to specify the MVS file for which you want to retrieve relationship information from the relationship file so you can extract related data. When specifying patterns in the fields, File-AID/RDX searches the relationship file and presents selection lists.
File
Specify the MVS file name of the object from which you want to extract related data. To view a list of files, specify a pattern. Valid pattern character is * (see Pattern Characters). If you specify a pattern, the “Catalog Utility File List” shown in MVS Catalog Utility File List (for Pattern FR*.ORDERTAB) is displayed.
If the specified file name is not found in the relationship file File-AID/RDX displays the Relationship Listing Window - No Relationships where you can decide whether to continue with a single object extract or start a new extract request.
Optional File Information Area
The following fields are not needed when the selected MVS file is found in the relationship file. However, if the driving object file name is not in the relationship file, you must specify the layout information when continuing with a single object extract.
Record layout usage
Indicate whether a single record layout (usage "S"), or an XREF (usage "X") had been used to define the selection criteria. Only needed when no relationships have been defined for the MVS file.
Record layout file
Specify the record layout file for the MVS object from which you want to extract related data. To view a list of layout files, specify a pattern. Valid pattern character is * (see Pattern Characters). If you specify a pattern, select a file from the “Catalog Utility File List” as shown in MVS Catalog Utility File List (for Pattern FR*.ORDERTAB).
Member name
Specify the member of the record layout file that contains the layout information for the MVS object. Leave blank or use a pattern to narrow the search.
XREF file
Only needed if layout usage is X. Specify the XREF file name for the MVS object from which you want to extract related data. Valid pattern character is * (see Pattern Characters). If you specify a pattern, select a file from the “Catalog Utility File List” as shown in MVS Catalog Utility File List (for Pattern FR*.ORDERTAB).
Member name
Specify the member of the XREF file that contains the layout information for the MVS object. Leave blank or use a pattern to narrow the search, also see XREF Select Member List Screen.
Specify Extract Options Area
Edit Object Selection criteria
Enter Yes so you can specify selection criteria for the driving object. File-AID/RDX will display Selection Criteria Menu screen when you press Enter. Enter No to extract all rows from the driving object.
Current Values displays *Defined* if selection criteria has already been defined.
Specify Extract "TO" File Information Area:
Use this area to specify the file to which File-AID/RDX will copy the extracted data and whether data privacy rules should be applied.
File name
Specify the name of the file to which data will be extracted. You must include the member name (in parentheses) when the file is a PDS. For more information, see Extract File and File-AID/RDX Extract File. If you specify a pattern, select a sequential file from the “Catalog Utility File List” (see MVS Catalog Utility File List (for Pattern FR*.ORDERTAB) after you entered one of the primary commands. Remember, File-AID/RDX will not prompt for a member.
Edit Data Privacy Spec
Specify whether you want to change the current data privacy specifications. When data privacy has been specified, File-AID/RDX will disguise the extracted data as part of the extract batch job according to the disguise criteria defined in the Disguise Control file (DCF) or in the Dynamic Privacy Rules Project (DPR). When you enter Y, File-AID/RDX will display the Data Privacy Specification screen.
Current Values displays *DCF*, *DPR*, or *None* for the selected disguise option.
Relationship information stored in Area
File name
Specify the name of the file that contains the referential integrity and application relationship information you want to use for the extract process. If you specify a pattern, select a file from the “Catalog Utility File List” (see MVS Catalog Utility File List (for Pattern FR*.ORDERTAB).
Primary Commands
The following File-AID/RDX-specific primary command is valid on this screen:
DB2 (D)
Switches from this panel to the single panel Extract - Db2 Driving Object prefilled with the applicable information from the current profile. See Extract - Db2 Driving Object.
EDIT (E)
Displays the JCL for this extract request. File-AID/RDX shows the Generated JCL panel where you review and modify the extract JCL.
GO (G)
Submits this extract request. Before issuing the GO command, make sure you have completed all the extract information. File-AID/RDX will also issue a message upon completion of the job.
MENU
Switches from this panel to the full Extract Menu. Only valid when profile setting Display Extract Menu is set to Y.