Writer instructions | ||
Purpose | Use this page to display a banner announcement on each page of the space. Create the Space announcements page in the master space, outside of the Home branch. You can version the Space announcements page to enable different banners to be published into different target spaces, however, the banner that is displayed in the versioned (master) space itself only displays the most recently-published banner. If you find errors in the banner area of your versioned space and you are sure the Space announcements page is set up correctly, try publishing the page to the same space. For more information, see Space-announcements-banners. | |
Removing | When an announcement is no longer needed, remove the BMC Space Banner macro. | |
Translation | Localized spaces using the L10n Viewport theme must change the name of this page to Space announcements l10n. See Configuring-the-Scroll-ViewPort-theme-for-translated-spaces. | |
Usage | Choose one or none of the following BMC Space Banner macros. If your space requires another kind of announcement, you can use this page in coordination with your team lead and editors. |
Step 1—Specifying extract information
File-AID/RDX displays the following figure when you select Option 2 from the File-AID/RDX Primary Option Menu and your profile specifies DB2 as the default object type. All input fields on this panel are prefilled with values from your current profile.
Extract - DB2 Driving Object
OPTION ===> G 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 ===> ORDER_TABLE (* or pattern for selection list)
Specify Extract Options:
Edit Object Selection Criteria ===> Y (Y = Yes; N = No) *None*
Maximum Rows to Select ===> * (* for all rows)
Use Uncomitted Read ===> Y (Y = Yes; N = No)
Extract IMPLICITLY HIDDEN columns ===> N (Y = Yes; N = No)
SELECT FROM Temporal Table ===> N (Y = Yes; N = No) *None*
Specify Extract "TO" File Information:
File name ===> FRSAMP.QUICKEXT
Format Unicode Data ===> 2 (1 = Extract as Unicode; 2 = Convert Unicode)
Edit Data Privacy Spec ===> N (Y = Yes; N = No) *None*
Relationship Information:
File name or pattern ===> FRSAMP.RELATION
Select the object type of the driving object for the extract: | |
---|---|
In this field… | Do the following: |
Command | Type G to submit the extract job as soon as you complete specifying the selection criteria for the driving table. |
SSID | Type the subsystem ID where the sample tables reside, if different from the SSID specified in your FRSAMPQK profile. |
Location | Leave blank. |
Creator | Type FRSAMP. |
Table Name | Type ORDER_TABLE. |
Edit Object Selection Criteria | Type Y, so you can enter selection criteria for the driving object. |
Maximum Rows to Select | Type * to retrieve all rows that meet the selection criteria for the driving object. |
Use Uncommitted Reads | Type Y to extract data from Db2 objects that include Uncommitted Reads. |
Extract IMPLICITLY HIDDEN columns | Leave set to N. |
SELECT FROM Temporal Table | Leave set to N. |
File name | Type FRSAMP.QUICKEXT, if different from the extract file specified in your FRSAMPQK profile. |
Format Unicode data | Type 2 for compatibility mode. |
Edit Data Privacy Spec | Type N if the current value is *None*. Type Y if the current value is other than *None* and set the Disguise Extract File value to 3 (No) in the Data Privacy Specification panel. |
File name or pattern | Type FRSAMP.RELATION, if different from the relationship file specified in your FRSAMPQK profile. |
Press Enter | File-AID/RDX displays the Driving Object Selection Criteria screen, where you specify the selection criteria for the driving object. |
Field Names and Descriptions
The following list describes all of the fields on this screen.
FIELD | DESCRIPTION | |
---|---|---|
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 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. 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. | |
Edit Object Selection Criteria | Enter Yes so you can specify selection criteria for the driving table. File-AID/RDX will display the Driving 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 displays. | |
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 Read | Specify whether to 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, for more information, see UNCOMMITTED_READ_DEFAULT in the Db2 environment). | |
Extract IMPLICITLY HIDDEN columns | Specify whether File-AID/RDX should extract data from IMPLICITLY HIDDEN columns or not. When this option is chosen, 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” screen when you press Enter. 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” 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” screen. | |
File name | (Extract file) Specify the name of the file to which data will be extracted. Include the member name (in parentheses) when the file is a PDS. | |
Format Unicode Data | Specify whether Db2 data extracted from tables with Unicode encoding is written to the extract file in Unicode or EBCDIC format. 1 Unicode option will write the data using Unicode encoding without utilizing IBM z/OS Conversion Services. 2 Compatibility format will maintain the EBCDIC encoding utilizing IBM z/OS Conversion Services used in previous releases of File-AID/RDX (default). | |
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. Note: Data Privacy is not allowed with a Delimited Extract. | |
File name or pattern | (Relationship file) Specify the name of the file that contains the referential integrity and application relationship information you want to use for the extract process. Note: If you leave this field blank, File-AID/RDX will perform a single table extract. Optionally, a single table extract now allows to extract selected Db2 columns and/or output of the extract file in delimited format. |
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 can 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.
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.