Screen conventions

In general, the first three lines of each display are formatted as follows:

Pattern characters

Many screens accept pattern characters. Valid pattern characters are:

Asterisk (*)—Matches all values. Valid for specifying objects, creators, tables, and members. Any characters following the asterisk (*) are disregarded, unless when searching for MVS objects in the MVS catalog, then the asterisk is treated the same as in ISPF dialogs.

Underscore (_)—Matches an occurrence of any single character. If an underscore is embedded in a string, the string must end with a percent sign (%). For example, xyz, xaz, and xbz all match x_z%. Valid for specifying Db2 objects only.

Percent sign (%)—Matches the occurrence of no characters or an unlimited number of characters. If a percent sign is embedded in a string, the string must end with a percent sign (%). For example, xyz, xz, and xmnoz all match x%z%. Valid for specifying Db2 objects only.

After you enter a pattern, File-AID/RDX displays a selection list. You can then select the appropriate name from the list.

Escape characters

Escape characters are required when you specify a creator or table name that does not conform to the Db2 alphanumeric character set. Escape characters are also required when you do not want uppercase translation of creator or table names.

Double-Byte Character Set (DBCS) support

File-AID/RDX supports the use of the Double-Byte Character Set (DBCS). Db2 must be installed with the mixed data option and your terminal must support the use of DBCS data.

File-AID/RDX enables you to do the following using DBCS:

• Specify tables whose names contain double-byte characters.
• Specify WHERE clause arguments on the Selection Criteria screen in Option 2, Extract.

If you have column names that contain DBCS characters, File-AID/RDX displays them enclosed in shift in and shift out characters on the Selection Criteria screen, the Relationship Information window, and the Column Relationships screen.

Table Names

You can specify table names that contain DBCS characters. Use the following syntax:

" > dbcs-string < "

where,

You can use mixed strings to specify values in the Where field on the Selection Criteria screen. Use the following syntax for CHAR, VCHAR, and LVCHAR strings:

=’sbcs-string > dbcs-string < sbcs-string’

where,

Use the following syntax for GRPH, VGRPH, and LVGRPH strings:

=G' > dbcs-string <'

where,

Column Name Display

If you have column names defined using DBCS characters, File-AID/RDX will display them using DBCS enclosed in shift out and shift in characters.

Types of Screens

There are several types of screens in File-AID/RDX. These screen types are defined in the following sections.

Option Selection Screen

The Option Selection screen displays a list from which you select an option by entering the appropriate character(s) in the Option field and pressing Enter. The File-AID/RDX Primary Option Menu shown in the following figure is an example of an Option Selection screen.

Option Selection Screen Example

Option Information Screen

The Option Information screen enables you to specify information necessary to perform the function selected. The Db2 Relationship Facilitator screen shown in the following figure is an example of an Option Information screen.

Option Information Screen Example

See Db2 Relationship Facilitator for a description of this screen example.

Scrollable Data Screen

The Scrollable Data screen shows information about multiple relationships and allows up/down scrolling. The Relationship Detail screen shown in the following figure is an example of a scrollable data display.

Scrollable Data Screen Example

See Relationship Detail for a description of this screen example.

Pop-Up Windows

File-AID/RDX uses several types of pop-up windows to perform functions such as displaying a selection list and displaying detailed information about a single relationship.

Selection Pop-Up Window

The selection pop-up window displays a scrollable list of items from which you can select one or more entries. This type of window displays minimal information about the items on the list. The Table List shown in the following figure is an example of a selection pop-up window.

Selection Pop-Up Window Example

Information Display Screen

The information display screen displays information about an object or a relationship. The Relationship Information window shown in the following figure is an example of an information display screen.

Information Display Screen Example

See Relationship Information Screen for a description of this screen example.

Scrolling

When a scrollable data display or pop-up window is displayed, the information to be displayed may exceed the screen or window size. The scrolling commands enable you to move the information up or down relative to the screen or window allowing you to view all displayable data. You can scroll through the data by using the UP and DOWN commands.

Only the Selection Criteria screen and scrollable fields (see also Scrollable Fields for Db2 Long Names) permit left and right scrolling. You can use the LEFT and RIGHT commands to scroll through the data.

The scrolling commands have the following syntax:

Valid scroll amounts are:

Valid Scroll Amount Values

For scrolling purposes, a “page” is defined as the amount of information currently visible on the logical screen. A pop-up window, for example, might have 10 lines of scrollable data. In this case a scroll amount of HALF would scroll 5 lines.

Scrollable fields for Db2 long names

Table and Creator names, for example, can be up to 128 characters long. File-AID/RDX supports Db2 long names and uses scrollable fields to display them on panels.

Long Name Indicator

When the complete table or creator (schema) name fits in the viewable field on a panel, the field name is followed by “===>”, but when there are more data in the field, the panel will show the “+++>” long name indicator instead. This should alert you to scroll or expand the field to view the name in its entirety. In the following figure, the long name indicator “+++>” for Table Name alerts that EMP_GENERATED_TIMESTAMP_HIDD is longer than displayed EMP_GENERATED_TIMEST.

Long Name Indicator Example

You can view the long names in two ways:

• Using the LEFT and RIGHT commands to scroll through the long name within an existing field
• Using the EXPAND command to display the long name in a separate window

The ZCLRSFLD command (PF24), introduced in z/OS 1.8, clears the contents of the scrollable field to blanks without having to EXPAND the scrollable field.

Scrollable fields are a standard ISPF feature. Refer to the “ISPF Dialog Developer’s Guide” for more information about scrollable fields.

Using the LEFT and RIGHT Commands

In order to view a long name in File-AID/RDX, use the LEFT and RIGHT commands to scroll in the field on the panel. A “Start of field” or “End of field” message displays in the upper right-hand corner of the screen, when the beginning or end of the field is reached.

Scrollable fields are not supported within dynamic display panels. The following is a list of the most commonly used dynamic display panels:

• Graphical Relationship Display

Use the KEYS command to set LEFT and RIGHT commands to a PF key (see also Assign PF Keys).

Using the EXPAND Command

The EXPAND command enables you to view a long object name in a separate window from the panel of the field. In order to view a long name, type EXPAND in the command line of the panel, move the cursor into the field to expand, and press ENTER (see the following figures for an example).

Use the KEYS command to set the EXPAND command to a PF key (see also Assign PF Keys).

EXPAND Command in Scrollable Field

EXPANDed Field