The key that is passed to VSAM is constructed by concatenating the variables specified; blanks are not trimmed. For example, if the KSDS specified a key length of 5 instead of 9 characters, the key that is in the preceding example would be truncated to and only records that match that value would be retrieved. This approximate key retrieval is useful when the exact key is not known.
It represents a single element as shown in the above example such as student id, name, marks, total marks, and percentage.
The number of characters in any field is known as field size, for example, student name can have 10 characters. For example, in students marks file, each student will be having a unique student id which forms the primary key. Secondary keys are unique or non-unique fields that are used to search for related data.
For example, in students marks file, full name of student can be used as secondary key when student id is not known.
Descriptors fields are used to describe an entity. For example, in students marks file, marks and percentage fields that add meaning to the record are known descriptors. Record Record is a collection of fields that is used to describe an entity. One or more fields together form a record. For example, in students marks file, student id, name, marks, total marks, and percentage form one record.
The cumulative size of all the fields in a record is known as the record size. The records present in a file may be of fixed length or variable length.
Physical Record Physical record is the information that exists on the external device. It is also known as a block. Logical Record Logical record is the information used by the program.
In COBOL programs, only one record can be handled at any point of time and it is called as logical record. File File is a collection of related records. For example, the students marks file consists of records of all the students.Random Processing of VSAM Files Q.
What are the Environment Division considerations for random processing of KSDS File? What are the PROCEDURE DIVISION statements for random retrieval of records in KSDS file.
You are going to write a COBOL Program to search the details of Employee No. 70 in the Employee KSDS File. the COBOL READ. Jun 23, · If the COBOL program is on the same platform as the spreadsheet file, just point the program to that file. If the COBOL program is on a mainframe or any other platform, then you would need to FTP the file to that platform.
Answer / pa. Being a flat file, we cant be sure that it will have a unique key field.
So, External to the cobol program, using SORT utility, we can add a serial no column, and then SORT it in descending order based on that column and read the file sequentially in COBOL program. Mar 01, · identification division.
program-id. fileksds. author. kk. environment division. Nov 22, · Read a Record from file and Delete VSAM Sample Program's; DB2 Sample Program's; COBOL Sample Program's; CICS Sample Program's; Subscribe To.
Posts Comments Total Pageviews CICS Sample Program's. SEND MAP program IDENTIFICATION DIVISION. PROGRAM-ID.
ADDPGM1. These sample programs cover COBOL language elements, two and three files matching, random and sequential files, bubble sort, relative files, screen processing, variable length records, working with dates, object oriented programs, and data structures.