WinOdEan Field Information

The primary objective of this package is data entry, updation and retrieval of records. To Create/Update data, field information that defines the property of a field should be existing somewhere. This property of a field that needs to be stored in a file. The storing of entire field information in a file allows the user to retrieve and modify the same as and when required. The name of the file has been left to user's choice with only the extension part being retained by the program. The name of the file should be a standard file name under Windows. The extension is always maintained as "FMT". The information existing in this file allows the user to create/update records, moreover, used for file manipulation purposes.

The field file entries consist of following items:

  1. Field Name

    Name of the field stands as a reference for further utilization. The field name should always start with an alpha character. The characters that are allowed are A-Z, 0-9, '-' and it can consist of combination of any of these set of characters. Each field should be uniquely named and OdEan does not allow duplicate field names. The naming convention has been restricted to this in order to provide direct COBOL compatibility with the created field names. Maximum length of the field name is 32 characters.

  2. Field Type

    The type of fields supported in OdEan and its COBOL equivalent are provided below:

    OdEan Field Type COBOL Equivalent
    A - Alphabetic A
    G - General (Alphanumeric) X
    N - Numeric 9
    D - Date X

    The program is designed in such a way that all the fields are compatible with COBOL.

  3. Field Sub Type

    This is associated only with field of type numeric. In case if the field type is of Numeric and Signed then appropriate information has to be entered. When Signed is selected, it implies it is a numeric field consisting of sign information. The Signed field operations comprises of four types:

    SIGNED LEADING (Embedded)
    SIGNED LEADING SEPARATE
    SIGNED TRAILING (Embedded)
    SIGNED TRAILING SEPARATE

    When user indicates a signed field under the signed field only characters that are accepted under this are Plus (+) and Minus (-). The default sign is always retained as positive. This feature is provided mainly for COBOL.

    The above signed options are taken care only during Export to Cobol format. While entering the data in any data entry mode, the signed field operators is always Signed Leading Separate.

    Detailed description of Signed field storage: The storage type behavior for signed field is described in detail here in order to help the user to know whether user can use a foreign file under this package after creating field information. This detailed description will help the user in understanding the behavior of signed field feature under OdEan.

    For SIGNED LEADING SEPARATE and SIGNED TRAILING SEPARATE the '+' and '-' signs are stored as it is:

    Example: SIGNED LEADING SEPEARATE
    Length 10 Characters (Bytes)
    Value stored 123456789+
    123456789-

    SIGNED LEADING and SIGNED TRAILING which are embedded is stored as follows:
    The trailing or leading character is taken as the one that has to be embedded with the sign information. The following table shows how the sign and the digits are combined and represented as single entity.

Embedded Signed Field Information
DigitPositiveNegative
0{}
1AJ
2BK
3CL
4DM
5EN
6FO
7GP
8HQ
9IR

Examples:
Following table shows the examples for the various sign specifications which represents all the possible combinations of signed field information. For clear understanding from the programmer/system analyst point of view even COBOL equivalent is provided.

COBOL Description:

02 L-S PIC S9999 SIGN LEADING SEPARATE CHARACTER.
02 T-S PIC S9999 SIGN TRAILING SEPARATE CHARACTER.
02 E-LS PIC S9999 SIGN LEADING.
02 E-TS PIC S9999 SIGN TRAILING.

OdEan Equivalent Description under field Information:

S -- Leading Separate
S -- Trailing Separate
S -- Leading
S -- Trailing

OdEan Equivalent
Numeric ValueL-ST-SE-LSE-TS
+0+00000000+}000000}
123+123123+}123123}
123-123123-}12312C
4. Starting Column Number

The starting column number for a specific field can be termed as a positional number within a record from where this field should start. The first column is always taken as one (1). The next starting column will be Previous field starting column number plus previous field number of characters plus one. The starting column numbers are calculated automatically by the program.

5. Number of characters

The number of characters for a field is the maximum number of character and/or digits the user may enter as input to this field. The physical storage may not always be equal to the number of characters in the case of date since separate storage type is provided.

The maximum number of character for each type of field is as follows:

Field Type Maximum number of characters
Alphabetic512
General512
Numeric 18
Date Dependent on type of storage

Date Field:

The date field basically comprises of three components:

  • Date Field visible on the screen
  • Date Field that has to be stored in the file.
  • Base year for validation and also for Year-2000 Conversion facility

The Date field format that is visible on the screen consists of thirty-two types. Any one of the available types can be chosen by the user:

NoFormatDateMonthYear
1DdMmYy222
2Dd/Mm/Yy222
3Dd:Mm:Yy222
4Dd-Mm-Yy222
5DdMmYyyy224
6Dd/Mm/Yyyy224
7Dd:Mm:Yyyy224
8Dd-Mm-Yyyy224
9MmDdYy222
10Mm/Dd/Yy222
11Mm:Dd:Yy222
12Mm-Dd-Yy222
13MmDdYyyy224
14Mm/Dd/Yyyy224
15Mm:Dd:Yyyy224
16Mm-Dd-Yyyy224
17YyMmDd222
18Yy/Mm/Dd222
19Yy:Mm:Dd222
20Yy-Mm-Dd222
21YyyyMmDd422
22Yyyy/Mm/Dd422
23Yyyy:Mm:Dd422
24Yyyy-Mm-Dd422
25YyDdMm222
26Yy/Dd/Mm222
27Yy:Dd:Mm222
28Yy-Dd-Mm222
29YyyyDdMm422
30Yyyy/Dd/Mm422
31Yyyy:Dd:Mm422
32Yyyy-Dd-Mm422

The storage type determines the way the entered date is to be stored in the file. This consists of five storage types and these are as follows:

· As it is
· DoyYy
· DoyYyyy
· YyDoy
· YyyyDoy

As it is This option stores the date in the same way it is keyed-in.
DoyYy This stores the date by converting the date and month into day of the year with two digits YY.
DoyYyyyyThis stores the date by converting the date and month into day of the year with four digits Yyyy.
YyDoy This is exactly similar to that of DoyYy except that Doy and Yy places are interchanged.
YyyyDoy This is exactly similar to that of YyyyDoy except that the storage places are interchanged.

Following table shows the input type and different type of storage that takes place in the package:

For example, if the value that is entered is 17/08/95, the following table depicts the storage information for each type that may be chosen:
As it isDoyYyDoyYyyyYyDoyYyyyDoy
17/08/95229952291995952291995229

Base Year: The base year is used primarily for two purposes:

· Validation of year
· Transmigration facility for year-2000

Base years that are supported in the package are 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1980,1990, 1995, 2000, 2005 and 2010. The user can also edit the date field in addition to above mentioned base years.

The following paragraph describes the purpose of base year concept provided under the package:

Validation of year: Year 99 is taken as the concluding year for two-character year irrespective of base year chosen. In case of four-character year it is 1999 or 2000 depending upon the base year chosen. Hence for minimum value of the year, always base year is taken into account. Validation is performed when user enters the year field with keeping base year as Minimum value.

Transmigration facility for year 2000: By selecting a file where year is of two-character size and setting the output file year to four characters transmigration facility can be accomplished through export option with remarkable ease. Detailed description for the same is provided under the chapter Data Entry.

6. Number of Decimal(s):

This is the number of decimal characters (digits) that the user can enter in a numeric field.

From the point of COBOL the decimal is only an assumed decimal position. Hence the decimal position from the point of OdEan becomes immaterial except in the case of reformatting which helps for calculation of significant digits. However, if user intends to export the same into xBase format or for the data entry operator to analyze properly for digits after decimal or digits before decimal it may be advisable to use the concept of decimals. Hence, when decimal concept is utilized the user should be cautious while entering the number of character for the decimals. For example, if user needs a numeric field of size 10 and decimal point is two digits, the appearance of two digits from right on the screen will be as follows:

Number of characters: 10 Decimal 2
Value: 1234567890
Visible on the screen: 12345678.90

While entering the number of character information for numeric field user should never consider the decimal point for size of field since it is only a virtual entity.

7. Justified

Three types are allowed. "L" indicates Left Justified, "R" indicates Right justified and "C" indicates Center Justification. The data will be justified according to the option set, after the entry is completed in a field. The default justification is always left for alphanumeric and alphabetic fields and right for numeric fields.

8. Duplicate

A "Y" has to be entered to indicate that, this is a field with duplicate data. This actually means that the data contained in this field will have information that are identical or nearly similar in many records. This is primarily helpful when the data that is being entered at present record field consists of information exactly similar to that of previous record or somewhere near by that. In case of identical data user will have to enter just CARRIAGE-RETURN to move into next field and in case of near by that, only those information that needs to be changed, should be changed and moved to next field either by keying in a CARRIAGE-RETURN or a Right-Tab. This newly created data will become part of data for future records.

9. Mandatory Entry

A "Y" signifies that this field should not be left blank while data entry. This indicates that some valid information has to be entered during the data entry process. If nothing is entered during the data entry process with this setup, it does not allow the operator to move into the next field.

10. Maximum Value

This is applicable only to Numeric fields. If nothing is entered here, the maximum value that is entire field will be filled with 9s (HIGHEST VALUE).

11. Minimum Value

This is applicable only to Numeric fields. If nothing is entered here, the entire field will be filled with zeroes (LOWEST VALUE).

Note: The conventional Field Information is used here in order to help data entry operators to easily understand the concepts and also to avoid using technical jargons like schema definition, data dictionary, etc. From the point of view of a regular IT professional this is left for his or her own personal interpretations.

FieldInfo screen
Following are the sub-options available in FieldInfo screen:

  1. Create Field Information

    Field Information Creation Menu
    During the field creation process the cursor moves appropriately to its locations under a single field. Maximum number of fields that can be created per record is 128. The field information entered is displayed in the grid which has been positioned in the bottom portion of the screen. A field present can be updated by selecting that particular field from the grid or by using First, Last, Prev & Next command buttons. The bottom portion of the main screen consists of status line. The first panel in the status line describes the work being done i.e. Field Information, Data Entry, etc., second panel describe the nature of the work i.e. Create / Update, Inquire, etc. which cursor is currently positioned & third panel gives the currently opened file. The Field create/update screen also contains a status line. The first panel in the status line displays the filename & the second panel gives brief description describing the nature of the field attribute on which cursor is currently positioned. In the above displayed figure since the cursor is positioned on name attribute description of name is seen on this line. Dialog box may appear wherever appropriate. For example, when user wants to modify the starting column number other than what is computed and displayed by the package, there will be a need of FILLER field name attribute. The reason behind this is that a record cannot have unidentified hole. Hence, it displays a dialog box of the following nature:

    In this case if the answer is affirmative (Yes) it goes ahead, Creates a field with name FILLER with number of characters which is equal to number of characters that falls in-between. If a wrong entry is made while creating attribute information it gets back into the same field displaying the appropriate error message.

  2. Inquire Field Information

    This displays the entire Field information. Only arrow keys are accepted under this option.

  3. Print Field Information

    This option is exactly similar to inquire option except that it sends the field information to a printer for an hard copy.

  4. Create Source

    This feature helps the user to create a COBOL compatible source file. When this option is invoked the following menu appears on the screen.

    The record information is actually a structure information that falls into the category of 01 Level under COBOL. All the defined fields are set for 02 level. Refer to Appendix A for example.

  5. Exit

    Exits to the operating system. While exiting to the operating system the program resets the screen to its original mode and also returns to original directory.

Field Information entry

Within the screen, the user can move to any desired direction. However, following things should be kept in mind while moving accross the fields:

Date and Date field Entry

Specification of a date field is kept slightly different from that of others due to following reasons: When Date field is chosen, a list-box is displayed providing the user a combination of thirty-two types of dates, five type of storage's and fifteen base years. The attribute for date can be chosen either by entering CARRIAGE-RETURN or by clicking the mouse.

Field Deletion/Insertion

When user either Inserts or Deletes a field, the starting column gets automatically adjusted for every field.

FILLER

This is a unique identifier provided in this package. User can introduce any number of FILLER fields. This is the only FIELD Name where duplicate names are allowed. While creating/entering the data, the FILLER fields are not displayed and these fields will be converted into spaces during data storage.

Main Screen