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 8— Specifying extract scope
Verify extract options as set with User profile SAMPMENU: | |
|---|---|
In this field… | Do the following: |
Extract Navigation Criteria | Set the global navigation controls to: Direct ===> Y |
Extract Scope Detail View | Type O for File-AID/RDX to display the listing of the related objects. |
Cycle Count | This field has been locked by the current profile’s setting (see Maximum cycles). |
Maximum Total Rows/Records From All Objects | Type 50 limit the extract to 50 extracted records. |
Action When Maximum Count Is Reached | Type Q for File-AID/RDX to resolve all orphan records after maximum count has been reached. |
Extract from DB2 using Uncommitted Reads | Type Y. |
Extract IMPLICITLY HIDDEN columns | Leave set to N. |
Extract from image copy | Type N. |
SELECT FROM Temporal Table | Leave set to N. |
Press Enter | File-AID/RDX displays the Extract Scope - Object View screen. |
Field Names and Descriptions
The following list describes all of the fields in this window.
FIELD | DESCRIPTION | |
|---|---|---|
Driving Object | Displays the name of the driving object from which you want to extract related data. | |
Extract Navigation Criteria | Navigation criteria determines the extend of how File-AID/RDX chases the related objects from the driving object. On this panel, you specify the Navigation Criteria globally, for all included objects and relationships. In the Detail View panels you may then determine the navigation on an individual object or relationship level. | |
Direct | Specify to extract the dependents of the driving object (starting point) and their dependents. Y Extract the dependents of the driving object and their dependents. N Do NOT extract the dependents of the driving object and their dependents. C (All Children only) Extract the dependents of the driving object and all of their dependents only. This option ignores all other Navigational Criteria Options (DPSI) settings and cannot be modified during the extract specification. Using the C method to extract data and only its dependent data can lead to extracted data that is not loadable because of referential integrity issues due to the omitted related parent data. This can be useful for extracting specific data that is then used for a purge procedure. P (Plus) Extract all of the direct relationships of the driving object, i.e. all of its parents and first level dependents only. Direct "Plus" means resolve all objects’ parents until there are no more parents to return. This option ignores all other Navigational Criteria Options (DPSI) setting sand cannot be modified during the extract specification. | |
Parents | Extract the parents of all extracted data to maintain the integrity of the extracted data. | |
Siblings | Extract other dependents of the extracted parents from the same relationships. | |
Indirect | Extract other dependents of the extracted parents from other relationships. | |
Extract Scope Detail View | Specify whether you want to view the list of relationships or list of related objects. Set to R or O to view the related objects and their relationships in more detail. In the detail panels, you may apply extract and navigation controls to individual relationships or objects. | |
N (None) | None does not display either of the detail extract scope panels. | |
O (Object) | Object displays the Extract Scope - Object View panel, listing all objects related to the driving object from which to extract data. For more information, see Extract Scope - Object View. | |
R (Relationship) | Relationship displays the Extract Scope - Relationship View panel, listing all the relationships associated with the driving object from which to extract data. For more information, see Relationship Navigation Criteria. | |
Extract Options | Use these fields to limit the number records to be extracted in this request. | |
Cycle Count | Specify the maximum number of cycles for all relationships leading from the object. Cycle count limits the number of times an object can be visited during an extract. This global setting for the Cycle Count can be overridden for each individual relationship (see Cycle). | |
Maximum Total Rows/Records From All Objects | Specify the maximum number of rows or records you want to extract from all related objects. Enter an asterisk (*) to set no limit. | |
Action When Maximum Count Is Reached | Specify how the extract should terminate when the maximum count has been reached: Q Quiesce resolves all orphan records after maximum count has been reached. (May result in more records than the maximum count.) S Stop does not resolve possible orphan records (may extract dependent records without their parents). | |
Extract from DB2 using 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). For more information, see 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. | |
Extract from image copy | Specify whether File-AID/RDX should extract data from Db2 Image Copy data sets or not. This option is only available if your site installation set the parameter variable UIMGCPY to Yes. For more information, see ALLOW_EXTRACT_FROM_DB2_IMAGE_COPY in File-AID/RDX Product Configuration. Y File-AID/RDX extracts related data from the most recent, full Db2 Image Copy for the applicable tablespaces. For partitioned tablespaces, File-AID/RDX extracts related data from image copy data sets as follows:
An image copy data set must exist in the MVS catalog for each Db2 table in the extract request. If not, the extract terminates. To extract data from a Db2 Image Copy, you must have one of the following authorization privileges:
N File-AID/RDX will extract from the regular Db2 tables. | |
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. | |
Scope Summary Counts | The following fields display how many objects and relationships will be included in the extract based on the specified Navigational Criteria specified. | |
Relationships Active | Displays how many relationships will be used to extract data from the related objects. | |
Related DB2 objects | Displays how many related Db2 objects will be accessed to extract data from. | |
Related MVS objects | Displays how many related MVS objects will be accessed to extract data from. | |
Output Key files | Displays for how many Output Key files File-AID/RDX will create for this extract request. | |
This section provides information about the following topics: