Euro conversion criteria


The Euro Conversion function enables you to convert to and from the euro (or ECU (European Currency Unit)). Select Option 1 (Euro Conversion) from the Euro Tools Menu.

The following figure enables you to enter currency conversion criteria to convert the specified field to or from the euro. This screen is displayed when you press <Enter> on the Euro Conversion Input Dataset Specification screen.

Euro Currency Conversion Criteria Screen

  Action  Sets  Display  Show  Options  Menu  Help
 -------------------------------------------------------------------------------
 File-AID/Data Solutions ------- Euro Conversion Criteria ----------------------
 COMMAND ===>                                                  SCROLL ===> PAGE
 EURO RATE DATASET ===> DASAMP.EURORATE.FACTORS
 SET  1 OF  1           EMPLOYEE-MASTER-FILE                     GBL = N SEL = N
 ---- FIELD LEVEL/NAME ------- -FORMAT- RO FROM/TO   CURRENCY   DECIMAL ADJUST
 ******************************* TOP OF DATA ***********************************
 5 EMP-NUMBER                    5/AN
 5 EMP-LAST-NAME                15/AN
 5 EMP-FIRST-NAME               10/AN
 5 EMP-MID-INIT                  1/AN
 5 FILLER                        2/AN
 5 EMP-TITLE                    30/AN
 5 EMP-PERSONAL-INFO SYNC       23/GRP
   10 EMP-NATL-ID-NUMBER         9/NUM
   10 FILLER                     1/AN
   10 EMP-DATE-OF-BIRTH          6/AN
   10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH
   10 EMP-DOB-REDEF SYNC         6/GRP
     15 EMP-DOB-MM               2/NUM
     15 EMP-DOB-DD               2/NUM
 Valid RO: EX, FM - EURO RATE DATASET contains valid CURRENCY values.
 Commands: SELect, View

Field descriptions

EURO RATE DATASET

Data set name of the European currency rate file. It must be a Sequential file or a member of a PDS. The records must be 80 bytes and formatted as shown in Conversion Rate Table. Data Solutions provides the sample European currency rate file, DASAMP.EURORATE.FACTORS, shown in DASAMP.EURORATE.FACTORS Sample ERUORATE Dataset.

Set

Identifies the set of criteria displayed.

01 Level Name

Name of the record file structure from layout.

GBL

Specifies whether one or more global fields have been attached to this set of criteria (N or Y).

SEL

Specifies whether selection criteria has been attached to this set of criteria (N or Y).

FIELD LEVEL/NAME

Name of the field from layout.

FORMAT

Length and type of field.

RO

Specify a relational operator. Possible values are:

EX 

Execute (default)

= 

Replicates last entered criteria

FM 

Field mask. For more information, see Field Mask.


FROM/TO

Convert from or to ECU:

TO 

Convert from ECU (euro) to NON-ECU value specified in CURRENCY field.

FROM 

Convert from NON-ECU value specified in CURRENCY field to ECU (EURO)


CURRENCY

Three-character name of NON-ECU currency. For example, BEF.

Warning

Important

This currency name must match a record in the conversion rate file.

DECIMAL ADJUST

Optional decimal point adjustment. + or - to increase/decrease the number of retained decimal positions. 123, or 4 is the number of retained decimal positions. For example, if the calculated value is 1.2468, a +3 in this field changes the value to 1247 (with an assumed decimal point between the 1 and 2). If the calculated value is 1234567, a -3 in this field changes the value to 1235.

The data field that you specify for conversion must be numeric. Binary (COMP) fields can be 2, 4, or 8 bytes. Numeric (EXTERNAL,DISPLAY) fields can be 1 - 18 digits and may have an embedded trailing sign. Packed (COMP-3) fields can be 1 -18 digits (1 - 10 bytes) with or without a sign.

Conversion Rate Table

Position

Value Description

1-8

EURORATE identifies record.

9-10

Unused.

11-13

Three character non-ECU currency (i.e. BEF).

14-15

Unused.

16-26

Specify a six-digit conversion rate in this 11-character field. Position 20 must contain a decimal point. The conversion rate is equivalent to one ECU. Data Solutions allows a maximum of six significant digits.

27-28

Unused.

29-80

Optional country identifier and/or description.

DASAMP.EURORATE.FACTORS Sample ERUORATE Dataset

  File  Edit  Confirm  Menu  Utilities  Compilers  Test  Help
-------------------------------------------------------------------------------
EDIT       USERID0.DASAMP.EURORATE.FACTORS                 Columns 00001 00072
Command ===>                                                  Scroll ===> PAGE
****** ***************************** Top of Data ******************************
 ==MSG> -Warning- The UNDO command is not available until you change
 ==MSG>           your edit profile using the command RECOVERY ON.
 000001 EURORATE  ATS  0013.760300  AUSTRIA SCHILLING
 000002 EURORATE  BEF  0040.339900  BELGIUM FRANC
 000003 EURORATE  NLG  0002.203710  DUTCH GUILDER
 000004 EURORATE  FIM  0005.945730  FINLAND MARKKA
 000005 EURORATE  FRF  0006.559570  FRANCE FRANC
 000006 EURORATE  DEM  0001.955830  GERMANY MARK
 000007 EURORATE  IEP  0000.787564  IRISH PUNT
 000008 EURORATE  ITL  1936.270000  ITALY LIRA
 000009 EURORATE  LUF  0040.339900  LUXEMBOURG FRANC
 000010 EURORATE  ESP  0166.386000  SPAIN PESETA
 000011 EURORATE  PTE  0200.482000  PORTUGAL ESCUDO
****** **************************** Bottom of Data ****************************

Primary commands

    • ==

The following is a list of primary commands and their abbreviations that are valid on the Euro Conversion, Euro Triangulation, Data Analysis, Date Pattern Analysis, Data Translator, Data Generator, Pattern Data, Data Encryption, and Data Replace Criteria screens.

ALIGN (AL)

Controls display of ALIGNED/UNALIGNED term for PL/I data.

ARRAY (AR)

Controls display of array declaration information for PL/I data.

BACK

Positions the display to the previous criteria. Synonym for LEFT.

CANCEL (CAN)

Returns to main panel without saving current updates.

CHANGE (CHG or C)

Switch from the Selection Criteria to the Change Criteria panels. This command is only valid on the Record Layout Selection Criteria and Global Selection Criteria panels.

COMPLEX (CM)

Controls display of COMPLEX terms for PL/I data.

DELETE (DEL)

Deletes a criteria set (change and associated selection criteria).

DISPLAY (DIS)

Specifies a display format.

DOWN

Scrolls down.

END

Terminates display of the formatted criteria screen and displays the Change Criteria Menu.

FILLER (FILL)

Controls display of FILLER fields.

FORWARD (FWD)

Positions the display to the next criteria. Synonym for RIGHT.

GLOBAL (GBL)

Displays the GLOBAL Change Criteria panel which shows the defined global fields (variables). Use this panel to create criteria which will test values of global fields. Valid only if a global field has been defined.
On the GLOBAL Change Criteria panel, you enter change criteria in the same way you enter change criteria on the record layout; the normal relational operators are available to operate against the global variables.

GROUP (G)

Controls the display of occurrences of group-level items.

INPUT/ INSERT (I)

Inputs/inserts a new criteria set.

IMPORT

Imports an existing change criteria set.

LEFT

Positions the display to the previous criteria. Synonym for BACK.

LOCATE (L)

Scrolls directly to the specified record layout line.

LR (Locate Record)

Positions the display to the specified criteria number.

MESSAGE (MSG)

Controls the message display.

OCCURS (OCC)

Controls the display of array declaration items.

OFFSET (OFST)

Controls format of SHOW OFFSET (Columns, Relative, or Hex).

PICTURE (PIC)

Controls the display of the PICTURE or DISPLAY line for numeric data.

PROFILE (PROF)

Displays profile information lines.

RECORD (REC)

Closes the Global Change or Global Selection Criteria panel and returns to the Formatted Selection or Change Criteria panel. Only valid on the Global Selection Criteria or Global Change Criteria panels.

REDEFINE (RED)

Controls the display of data item redefinitions.

REFLNG (REF)

Controls the display of BIT/CHAR REFER field length reference lines for PL/I data.

REPEAT (R)

Causes a criteria set (formatted change and selection) to be repeated.

RESET (RES)

Causes excluded lines to be redisplayed.

RETURN

Returns to the Primary Option Menu.

RIGHT

Positions the display to the next criteria. Synonym for FORWARD.

SELECT (SEL)

Displays the Formatted Selection Criteria screen.

SHOW (S)

Displays LEVEL, NUMBER, FORMAT, OFFSET, or PICTURE information for the selection fields.

SYNC

Controls the display of the SYNC term for fields in a COBOL record layout.

UP

Scrolls up.

VIEW (V)

Displays the View Criteria screen which is a keyword summary of the current settings for formatted change and selection criteria. See View Specification Keywords Screen.

ZERO (Z)

Controls the display of leading zeros in the numeric data fields.

Shortcut Commands

When entering or modifying change criteria you can change the type of criteria you are about to enter by using any of the following primary commands:

AGING

Switches to Date Aging.

DATAENCR

Switches to Data Encryption.

DATAGEN

Switches to Data Generation.

DATANALY

Switches to Data Analysis.

DATAPGEN

Switches to Pattern Data Generation.

DATAREPL

Switches to Data Replace.

DATATRAN

Switches to Data Translator.

DATAVALD

Switches to Validate Criteria.

DATEANLY

Switches to Date Pattern Analysis.

EUROCNV

Switches to Euro Conversion.

EUROTRI

Switches to Currency Triangulation.

FLDEXITS

Switches to Field Exits.

For example: You have selected “7 Encryption” on the criteria menu and you are entering encryption criteria and then you want to switch to data translation.

You could press PF3 to go back to the menu and then select “4 Translator” or you could enter the primary command DATATRAN on the data encryption criteria screen.

If you have already entered criteria for the set that is currently displayed, the primary command process assumes that you want to insert the new type of criteria after the current set.

Selection criteria

The Selection Criteria screen is displayed when you enter the SELECT (SEL) primary command on the Euro Conversion Criteria screen. See Selection-criteria for a sample of this screen and field descriptions.

Global criteria

The Global Criteria screen is displayed when you enter the GLOBAL (GBL) primary command in any of the Data Solutions Change or Selection Criteria screens. It lists all global variables defined with option G of the Criteria Menu. See Global Criteria for a sample of this screen and field descriptions.

Field mask

The Field Mask Criteria screen is displayed when you enter the Field Mask (FM) relational operator in the relational operator (RO) column on the Euro Conversion Criteria screen. See Field Mask for a sample of this screen and field descriptions.

Related topics

 

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

BMC AMI DevX File-AID/Data Solutions 23.01