Object Selection Criteria specification

The following figure is displayed when the selected driving object on the Object Selection Criteria screen is a Db2 table or view.

Object Selection Criteria specification

File-AID/RDX ----------- Object Selection Criteria --------------------------
Command ===> SQL                                               SCROLL ===> CSR
Set 1 of 1
Specify selection criteria for table FRSAMP.ORDER_TABLE

    Column Name           Type(Length)        Where                     More: >
- -------------------- ------------------ ----+---10----+---20----+---30---
P ORDER_NUMBER          CHAR(6)             > 'FF0000'
    CUST_NUM              CHAR(6)
    SOC_SEC_NUM           CHAR(11)
    CREDIT_CARD_NUM       CHAR(16)
    ORD_TYPE              CHAR(8)
    ORD_DATE              DATE
    ORD_STAT              CHAR(8)
    ORD_AMOUNT            DEC(9,2)
    ORD_DEPOSIT           DEC(9,2)
    ORD_LINE_COUNT        INTEGER
    SHIP_CODE             CHAR(2)
    SHIP_DATE             DATE
    ORD_DESCRIPTION       VCHAR(100)
    ** End of Columns **

To specify the driving table selection criteria:
In this field…	Do the following:
Where	Type > (greater than symbol), followed by a space, and the string ’FF0000’
Command	Type the SQL primary command.

Press Enter

File-AID/RDX displays the File-AID/RDX Generated SQL screen.

Field Names and Descriptions

The following list describes the fields on this screen.

FIELD	DESCRIPTION
Key/Index Indicator	(Untitled 1 byte field) Indicates P Primary key, F Foreign Key, or I High Order Index key (if not Primary or Foreign) for the column as an aid for users to create SQL that will perform well.
Column Name	Displays the names of the columns of the driving object.
Type(Length)	Indicates the data type of each column in the driving object. Warning Important Distinct type (UDT) columns show either their built-in data types or their UDT names, depending on the status of the UDTSWAP primary command. To switch the display status enter the UDTSWAP command. To view a list of all UDTs that are part of the extract issue the UDTTYPE command. When entering a WHERE clause for a UDT column you must enter the appropriate CAST function manually. Example: =CAST('A01' AS TSOID01.DEPARTMENT) Column types CLOB, BLOB, DBCLOB, ROWID, BINARY, VARBINARY, or XML are not eligible for WHERE clauses.
Where	Identifies the operators and values to use to further define the column extract criteria.

Primary Commands

The following list identifies the primary commands that are available from this screen. For details on the command, see File-AID/Related Data XPERT Reference.

COMMAND	DESCRIPTION
CAPS ON	Switches all entered letters in the WHERE field to uppercase letters.
CAPS OFF	Does not switch lowercase letters in the WHERE field to uppercase.
DOWN	Scrolls toward the end of the column list by the specified scroll amount.
END	Redisplays the Selection Criteria Specification screen.
LEFT	Scrolls toward the left of the Where column by the specified scroll amount.
RIGHT	Scrolls toward the right of the Where column by the specified scroll amount.
SQL	Displays the ISPF/PDF EDIT screen where you can edit or specify selection criteria using SQL syntax.
UDTSWAP	Swaps the display for distinct type columns from UDT name to the built-in data type and length and vice versa. There are no operands associated with this command.
UDTTYPE	Lists all distinct data types (UDTs) that are part of the extract. The list displays the schema, UDT name, and the built-in data type and length. There are no operands associated with this command.
UP	Scrolls toward the top of the column list by the specified scroll amount.

Line Commands

There are no line commands associated with this screen.

SQL Edit Screen

The following figure is displayed when you enter the SQL primary command on the Object Selection Criteria specification or Table Selection Criteria screen.

Only the WHERE clause of the SQL statement is displayed as you cannot modify any other part of the SQL statement for selection criteria. It displays only the WHERE clause of the SELECT statement. File-AID/RDX will create the remainder of the SQL statement.

SQL Edit

EDIT - File-AID/RDX Generated SQL --------------------------- COLUMNS 001 072
COMMAND ===> END SCROLL ===> HALF

*NOTE*
*NOTE* All Columns will be extracted FROM DSNLOCAT.FRSAMP.ORDER_TABLE
*NOTE*
****** ***************************** TOP OF DATA ******************************
000001 WHERE ORDER_NUMBER > ’FF0000’
****** *************************** BOTTOM OF DATA *****************************

To redisplay the Driving Table Selection Criteria screen:
In this field…	Do the following:
COMMAND	Type the END primary command.

Press Enter

File-AID/RDX displays the Driving Table Selection Criteria screen from which you invoked the SQL command.

To redisplay the Selection Criteria Specification screen after completing all driving table selection criteria:
In this field…	Do the following:
COMMAND	Type the END primary command in the Driving Table Selection Criteria screen.

Press Enter

File-AID/RDX displays the Selection Criteria Specification screen.

Field Names and Descriptions

This is an ISPF/PDF edit screen. For more information about this screen, see IBM ISPF/Program Development Facility Reference.

Primary Commands

ISPF edit primary commands are valid on this screen. For details on each command, see IBM ISPF/Program Development Facility Reference.

Line Commands

ISPF edit line commands are valid on this screen. For details on each command, see IBM ISPF/Program Development Facility Reference.

Object Selection Criteria specification

Field Names and Descriptions

Primary Commands

Line Commands

SQL Edit Screen

Field Names and Descriptions

Primary Commands

Line Commands

BMC Compuware File-AID/RDX 21.01

On this page