Ohio Educational Computer Network System (OECN)
UDMS Beginning Training Guide

You will set qualifications for the fields, WAGE_CLS and DEPTNO. Select the MODIFY option in order to bring up the main REPORT MENU. The following screen should appear.

========================================================================================= |DD-MMM-YY HH:MN XM REPORT3 PAGE 9999| | Lesson 3 Report | | Data definition (PRSPAY) | |=======================================================================================| |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | | | | | | | REPORT MENU [TOP] <PF3> cancel | | | | SELECT Rpt Fields TOTAL this Rpt MODIFY Rpt Descriptor CANCEL | | DEFINE Input/Calc Flds FORMAT this Rpt CHANGE Submit Options SAVE as | | QUALIFY Data Records GENERATE this Rpt CATALOG | | SORT Rpt Data EXAMINE Format | |_______________________________________________________________________________________|

Now highlight and select the "QUALIFY Data Records " option. This brings up the DEFINE QUAL menu as shown next.

_____________________________________________________________________________ | | | DEFINE QUAL <PF3> cancel | | | | ====> USER-DEFINED Data Record Qualification CANCEL | | LOAD Data Record Qualification from existing Def | | | |___________________________________________________________________________|

Next select the "USER-DEFINED Data Record Qualification" option.

This brings up the DATA RECORD QUALIFICATION screen with the cursor prompting for the "Comparison Field". This is the field against which the data records will be qualified for selection. This field needs to be already entered in the Report Field list. You can either type in a field name, or press the [PF1] key to see a list of fields and select one from there.

For this report, you want BOTH of the following conditions to be satisfied in order to select (qualify) a record:

1. WAGE_CLS EQ 1 AND 2. DEPTNO LE IN_DEPTNO

Begin by typing in the field name, WAGE_CLS, as shown in the next screen.

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Qual Entries: 0 DATA RECORD QUALIFICATION | | Comparison Comparison ----- Compare to ---------- And/Or | | Field Operator Constant Field | | | | 1 WAGE_CLS <==== | | | | | | | | | | DEFINE <PF1> select <PF2> help <PF4> finished | |_______________________________________________________________________________________|

Press the [Return] key to advance to the Comparison Operator field. This detail allows you to specify what type of camparison will be made to WAGE_CLS.

Press the Help key [PF2] to see a list of the qualification options.

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Qual Entries: 0 DATA RECORD QUALIFICATION | | Comparison Comparison ----- Compare to ---------- And/Or | | Field Operator Constant Field | | | | 1 WAGE_CLS EQ | | | | | | | | | | DEFINE <PF1> select <PF2> help <PF4> finished | | | | EQ begins with LE less than or equal to EE exactly equal to | | NE does not begin with GE greater than or equal to NX NOT exactly equal to | | LT less than CN contains | | GT greater than NC does not contain <more> | |_______________________________________________________________________________________|

The comparison operators are described in the following table:

Comparison Operator		Description
EQ	begins with	On "AN" fields, finds anything that BEGINS WITH the Constant or Field2 specified. On a "NU" field finds the value that is EXACTLY EQUAL.
NE	does not begin with	Opposite of "EQ".
LT	less than
GT	greater than
LE	less than or equal to
GE	greater than or equal to
CN	contains	causes ReportWriter to scan the content of a field for a character(s) specified by you. The field is qualified (selected) if it contains the character(s) specified, regardless of location in the field.
NC	does not contain	the reverse of "contains". When the specified characters do NOT occur in the field, then the record is selected.
EE	exactly equal to	qualifies, character for character, records whose contents are identical to the value specified. Valid only for "AN" fields. For example, "NAME EE PAT", would not select "PATRICK".
NX	not exactly equal to	Reverse of "EE". Finds all values where the "Compare To Constant/Field" is NOT EXACTLY EQUAL to the comparison field.

Press [Return] key to accept the default "EQ" and advance to the "Compare to Detail" fields.

The value entered here will be compared to the current value of "WAGE_CLS". If the values are equal, then the record will be selected. If the values are not equal, then the record will not be selected. As you can see, the "Compare to" detail may either be a constant or a field name. In addition, the "constant" can be either of the following:

• an arithmetic expression (such as: 1 + 1)
• several constants separated by commas---implied OR's (such as: 10, 20, 30---which translates into 10 OR 20 OR 30.

You will use the constant field, so enter the value 1 in this field and press [Return] to advance to the "Connector" field. This field is used for multiple conditions which are connected by either "AND" or "OR". The default value is "AND" as shown next.

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Qual Entries: 0 DATA RECORD QUALIFICATION | | Comparison Comparison ----- Compare to ---------- And/Or | | Field Operator Constant Field | | | | 1 WAGE_CLS EQ 1 ====> AND | | | | | | | | | | DEFINE <PF1> select <PF2> help <PF4> finished | | | |_______________________________________________________________________________________|

Press the [PF2] key to see the options for the Connector. A screen similar to the following should appear.

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Qual Entries: 0 DATA RECORD QUALIFICATION | | Comparison Comparison ----- Compare to ---------- And/Or | | Field Operator Constant Field | | | | 1 WAGE_CLS EQ 1 AND | | | | | | | | | | DEFINE <PF1> select <PF2> help <PF4> finished | | | | AND this condition and the next must both be met | | OR this condition or the next will qualify the record | |_______________________________________________________________________________________|

Mixing AND's and OR's provides the ability to construct compound qualifications. Further, parentheses may be used to control the order to the evaluation. Consider the following examples:

_____________________________________________________________________________ | | | Example Compound Qualifications - Using AND's / OR's / Parentheses | | | | 1 DEPTNO EQ 30 AND | | 2 (LASTNAME EQ HIRSCH OR | | 3 EMPNO EQ 00150) | | | | 1 (WAGE_CLS EQ 1 AND | | 2 CUR_SALARY GE 2000) OR | | 3 (WAGE_CLS EQ 2 AND | | 4 CUR_SALARY GE 12) | | | |___________________________________________________________________________|

In this report you want BOTH conditions to be satisified, press the [Return] key to accept the AND connector and enter in the field name, DEPTNO, as shown in the next screen.

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Qual Entries: 0 DATA RECORD QUALIFICATION | | Comparison Comparison ----- Compare to ---------- And/Or | | Field Operator Constant Field | | | | 1 WAGE_CLS EQ 1 AND | | 2 DEPTNO <==== | | | | | | | | DEFINE <PF1> select <PF2> help <PF4> finished | | | |_______________________________________________________________________________________|

Press the [Return] key and then enter the data as shown in the next screen.

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Qual Entries: 0 DATA RECORD QUALIFICATION | | Comparison Comparison ----- Compare to ---------- And/Or | | Field Operator Constant Field | | | | 1 WAGE_CLS EQ 1 AND | | 2 DEPTNO LE IN_DEPTNO | | | | | | | | DEFINE <PF1> select <PF2> help <PF4> finished | | | |_______________________________________________________________________________________|

You have entered two record qualifications. When the report is generated, only records which have WAGE_CLS = 1 AND have the DEPTNO < or = to the current value of IN_DEPTNO will be included in the report.

Since you are finished with the qualifications, press the [Return] key and then the (PF4) key. This will bring up the DATA RECORD QUALIFICATION MENU where you can make correction and/or delections as indicated below.

_________________________________________________________________________________________ | | | Rpw: REPORT3 REPORT DEFINITION MODIFICATION View: PRSPAY | | | |EMPLOYEE # LASTNAME DEPT. # WAGE CLASS SALARY CA_RAISE CA_NEW_SALARY| |********** *************** ******* ********** *********** ********* *************| | | | 00-000 XXXXXXXXXXXXXXX 9999 9 $999,999.99 $9,999.99 $999,999.99| | | | | | | | Qual Entries: 2 DATA RECORD QUALIFICATION | | Comparison Comparison ----- Compare to ---------- And/Or | | Field Operator Constant Field | | | | 1 WAGE_CLS EQ 1 AND | | 2 DEPTNO LE IN_DEPTNO | | | | | | | | QUALIFY MENU <PF3> cancel <PF4> finished | | | | ADD an Entry REVIEW the Entries CANCEL | | INSERT an Entry CLEAR all Entries FINISHED | | CHANGE an Entry EXAMINE Format | | DELETE an Entry | |_______________________________________________________________________________________|