Rules for indexed tables, COBOL Programming

Assignment Help:

RULES FOR INDEXED TABLES:

The rules of indexing a table with an INDEXED phrase are as shown below:

(1) If indexing is completed for any one level of a table, then indexing should be used for all levels. Therefore it will be an error if in the above the INDEXED phrase is used only for FACULTY and not for the DEPARTMENT and YEAR.

(2) The Index names cannot be used in combination with the subscripts. And hence, a reference as YEAR (F1, S2, S3) will be treated as an error as F1 is an index name but S2 and S3 are data names. Though, index names can be used in a combination with numeric positive integral literals. Therefore YEAR (F1, 2, 3) is valid as F1 is an index name, while 2 and 3 are numeric integral literals.

(3) Indexes are valid only for the tables where they have been identified. The Indexes for one table cannot be used for the other table. Therefore F1, D1 and Y1, being indexes for the table ENROLL-TABLE, cannot be used for other tables in similar program.

(4) The index names should be exclusive. The same index name should not be used for various levels of a table.

(5) The indexes should not appear anywhere in the DATA DIVISION except in the INDEXED phrase of the OCCURS clause. This means that the index names must be implicitly defined and must not be defined explicitly.

(6) The Indexes can be manipulated only by the SEARCH, SET and PERFORM statements. The value of an index is frequently known as the occurrence number. The internal presentation of the occurrence number is system dependent.

(7) An index can be coded plus or minus an integer literal for the relative addressing of the table elements. For illustration, YEAR (F1+1, D1-2, Y1-1) is valid. If F1, D1 and suppose that the value 1,3 and 4 respectively then this will refer to the third YEAR of the first DEPARTMENT of the second FACULTY.

(8) There can be more than one index for each level. For illustration, the ENROLL-TABLE can also be defined as

1783_RULES FOR INDEXED TABLES.png


Related Discussions:- Rules for indexed tables

Examples - edit characters for numeric data, Examples - Edit characters for...

Examples - Edit characters for numeric data: The following illustration illustrates the use of Z editing characters. The character b is used to indicate the space character an

Write statement, WRITE STATEMENT: The WRITE Statement verb releases a r...

WRITE STATEMENT: The WRITE Statement verb releases a record in an output file. The syntax for the WRITE statement can be unlike depending on the output device and the medium us

Example of condition names, Example of condition names: The illustrati...

Example of condition names: The illustration below is of the use of the condition names  77  MARITAL-STATUS     PIC    9   88  SINGLE    VALUE    IS     ZERO   88  MA

Rewrite statement, REWRITE statement: The REWRITE statement is used to...

REWRITE statement: The REWRITE statement is used to update the existing record in a disk file. The normal format is as shown below: REWRIE  record-name  [  FROM      ide

Data names and identifiers - cobol program, Data Names and Identifiers:   ...

Data Names and Identifiers:   The Data name provides reference to the storage space in the memory where the real value is stored. This value takes part in the operation whene

Program for sequential file creation & rewriting , Program for Sequential F...

Program for Sequential File Creation & Rewriting  We have to write a program to create a Length file with just two fields: l (Length) and l-c (Length-Code). Add a few records.

Giving file-name - simple merge verb, GIVING    file-name-5. The input...

GIVING    file-name-5. The input files to be merged through the MERGE statements which are specified in the USING phrase. These files should be sequential files and should be

Subscript and index, What is the difference between subscript and index

What is the difference between subscript and index

ACCEPT VERB, When using the accept verb in cobol is it possible to assign s...

When using the accept verb in cobol is it possible to assign something other then "SYSIN" for a ddname?

Illustration of subtract verb, Illustration of Subtract verb: (a) SUBT...

Illustration of Subtract verb: (a) SUBTRACT A FROM B. This illustration means that the value of A will be subtracted from the value of B and the subtracted result will be s

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd