Line commands description

This section provides information about the following commands:

A (Accept Path)

Accept an individual relationship to be included in the extract. When you press Enter, you return to the previous Extract Scope screen where you entered the CHECK command. Check Extract Warning screen.

A (Add)

On the Application Relationship Detail and Db2 or MVS Object List screen, A enables you to create a new application relationship by displaying the Add Relationships screen. On the Unrelated Object Specification screen, A allows you to add unrelated objects to your extract specification. On the Default Value Definition screen, A allows you to add literal definitions during load column mapping.

A line command summary:

  • Add a new AR relationship
  • Add an unrelated object
  • Add a literal definition

A (Add/Assign Rule)

Displays the Associated Rules List where you can select an already defined associated disguise rule or create a new associated rule to assign to a selected column (see also Associated Rules List). You can only enter the A line command for a column that does not have a rule assigned to it, yet.

A (All)

Extract all data from this object regardless of the relationships from and to this object. Extract Scope - Object View screen.

B (Browse)

From the Relationship Facilitator Option, B enables you to browse the relationship file for the selected object by displaying the Column Relationships screen.

B line command summary browse for a relationship

C (Change and Go)

Select an extract request and change the selection criteria for the driving object before submitting the request (Extract Reference List and Extract Request File Member List screens).

C (Copy)

Copies a profile member (Profile Selection screen).

D (Delete)

Valid on the Application Relationship Detail screen, RI Relationship Detail screen, SQL Edit screen, and the Column Relationships screen. Deletes the relationship on the line containing the D line command. On the Default Value Definition screen, D deletes a literal definition during load column mapping.

D line command summary:

  • Deletes relationship on the current line
  • Deletes selection criteria for the object on the current line
  • Deletes literal definition during Load Column/Field Mapping
  • Deletes entries from a Reference List or Request File
  • Entries from the list of partition definitions

E (Edit AR)

From the Relationship Facilitator Option, E enables you to maintain (add, edit, delete) application relationships for the selected object by displaying the Column Relationships screen.

E line command summary edit an AR relationship.

E (Edit Object)

In the Target Environment screen, E enables you to edit the create information for the selected object. Only valid for objects marked to be created.

E line command summary edit object create information.

G (Go)

Submits an extract, or load request immediately without any changes (Reference List and Request File Member List screens).

I (Ignore Path)

Ignore an individual relationship, it will not be included in the extract and its status changes to “Relational error ignored”. You can still use the Accept Path line command to change the status individually or enter the ACCEPT primary command. Check Extract Warning screen.

I (Information)

Valid on Relationship Detail screens in the Browse Relationships, RI Relationship, and Application Relationship suboptions. Also valid on the Relationship Criteria screen and the Graphical Relationship Display screen. Displays the Relationship Information pop-up window. This window contains slightly different information for each suboption. When entered in the Extract, Load, or Delete Reference List, it displays the Request Details screen with detailed information about the selected request. In the Target Environment screen, I displays the DDL for the selected Db2 object. In the Data Disguise - Object List, I displays data disguise information for an object and in the Data Disguise - Column/Field List, I displays data disguise information for a column/field.

I line command summary:

  • Display information about a relationship
  • Display detailed information about an extract, delete, or load request
  • Display DDL for selected Db2 object
  • Display data disguise information for an object
  • Display data disguise information for a column/field

I (Insert)

The I (Insert) line command inserts a different partition after the current partition. The inserted partition(s) are based on the model partition. To insert more than 1 partition at a time, enter the number of partitions with the I line command (nnn = 1 - 999). Valid on the Tablespace Partition Definition and Index Partition Definition panels.

L (List DB)

In the Data Disguise - Object List, lists all objects that are in the same database as the selected object and are not already in the object list. Then you can select any of the objects to be added to the object list.

L (Load RI)

From the Relationship Facilitator Option, L enables you to maintain (load, delete) Db2 RI relationships for the selected object by displaying the Column Relationships screen.

L line command summary load an RI relationship.

L (Lock)

Prevents the request entry from rolling off the Reference List.

L (Lock Table)

Indicate whether or not a table will be locked during extract. The L line command acts as a toggle switch, enter it once and it will set the status to Locked. Enter L a second time, and the Locked status is removed. FUNCTION LOCK must be enabled for the L line command to be valid. Extract Scope - Object View screen.

M (Modify Request)

Valid in the Extract Reference List and Extract Request File Member List screens. Selects this extract request, displays the Modify Extract Request panel where you can change the Db2 subsystem and any object name in the request. This allows you to create an extract request on one Db2 subsystem or MVS environment and then easily modify or "clone" it to run on a different Db2 subsystem or MVS environment which has the same objects but with different names.

M line command summary selects an extract request, allows changing SSID and/or object names.

M (Modify MVS Object)

When issued in the Unrelated Object Specification screen for an unrelated MVS file, it displays the Modify Unrelated MVS Object Definition screen where you can change the record layout and/or XREF information for the file.

M line command summary selects an unrelated MVS file to modify its record layout information (valid on Unrelated Object Specification screen only).

n (Column or Field Number)

Valid only on the Column/Field Relationships screens. Establishes an application relationship between a parent column or field (the column/field next to which you enter the command) and a dependent column or field (the column/field designated by the entered number).

n line command summary establish a new column relationship

O (ObjectOut)

In the Data Disguise - Object List, removes the selected object from the object list.

P (Passthru)

Don’t extract any data from this object, but process all relationships as if records based on the relationship would have been extracted. Extract Scope - Object View screen.

R (Related objects)

In the Data Disguise - Object List, searches the relationship file and displays any related objects that are not yet included in the object list. Then you can select any of the related objects to be added to the object list.

R (Relationship View)

Mark this object to be included in the Relationship View when the VIEW primary command is entered. Extract Scope - Object View screen.

R (Remove)

Removes an unrelated object from the Unrelated Object List.

R (Rename)

Renames a profile member (Profile Selection screen) or a request file member (Request File Member List screen).

R (Repeat)

The R (Repeat) line command repeats a partition definition in the list of different partitions from the model. To repeat a partition definition more than once, enter the number of repetitions with the R line command (nnn = 1 - 999). Valid on the Tablespace Partition Definition and Index Partition Definition panels.

R (Restore original name)

Restores the original object name for the selected object. Valid on the Modify Object Names - DETAIL Screen.

S (Select)

Valid on the Browse - Relationship Summary window, RI Relationship Detail screen (load/refresh), Application Relationship Detail screen, and Relationship Criteria screen. Valid also on the Relationship Listing pop-up window and the Table List pop-up window. Selects a relationship or table to be operated on.

Selects a column to load a literal in the Column Mapping screen. Selects a literal definition to be assigned to a column in the Default Value Definition screen.

Selects an extract, load, or delete request and displays the appropriate Extract, Load, or Delete Menu or screen (Reference List and Request File Member List screens).

Selects an object in the ObjectIn Preview, ObjectOut Preview, or Data Disguise - Object List screen or a column/field in the Data Disguise - Column/Field List screen for data disguise.

S line command summary:

  • Select a relationship or table
  • Select a column/field to load literals
  • Select a literal definition for a column/field
  • Select an object or member from a list
  • Select a profile from the profile list
  • Select an extract, load, or delete request
  • Select an object for data disguise
  • Select a column/field for data disguise

U (Unassign Rule)

Removes a disguise rule from a column in the Data Disguise - Column/Field List.

U (Unexclude)

Valid on the Extract Scope - Object and Relationship Views, Graphical Relationship Display, Source to Target Mapping, and Target Environment screens. Selects a previously excluded object/relationship to be included in the extract or load.

U line command summary undo exclude on a relationship

U (Undo Remove)

Reverses removing an unrelated object from the Unrelated Object List.

U (Unlock)

Removes the lock status from a request entry in a Reference List.

U (Update)

On the Default Value Definition screen, U allows you to update literal definitions during load column mapping.

U line command summary update a literal definition

V (View JCL)

Displays the JCL for this load or extract request. File-AID/RDX shows the Generated JCL panel where you review and modify the load or extract JCL (Reference List and Request File Member List screens for extract and load).

V line command summary view extract or load JCL.

X (Exclude)

Valid on the Relationship Criteria screen and the Graphical Relationship Display screen. Excludes a relationship from the extract or load.

X line command summary exclude a relationship.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*