Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
We have input file, record layout is EMP ID (6 char) , EMP NAME (20 char), Designation (3 char),Salary (5 digit) Base Branch (10char) Grade (3 Alphanumeric).
This is the input file contain 150 records.
There are five base branches
chennai,
hyderabad,
bangalore,
mumbai,
delhi.
each base branch containing 30 records each.
We have to make an output file which can be our VSAM file where it will contain 3 output files which should merge
chennai and hyderabad (output file 1)
bangalore and mumbai (output file 2)
delhi into one.(output file 3)
DATA RECORD CLAUSE: The DATA RECORD clause, documents the record names defined for the file. For illustration, DATA RECORDS ARE REC-1, REC-2, REC-3 that means there are 3diffe
PERFORM STATEMENT: The PERFORM statement can be used to execute the group of consecutive statements written elsewhere in the program. We refer to this group of statements a
Example of Perform statement: PERFORM BEGIN-CALCULATION THRU END-CALCULATION. Assume, BEGIN-CALCULATION and END-CALCULTION is paragraph names. The execution of the PERFORM
REWRITE STATEMENT: The REWRITE statement has the format for a relative file as shown below, REWRITE record-name [ FORM identifier ]
SEQUENTIAL FILES WITH THE VARIABLE-LENGTH RECORDS: The Magnetic - tape or disk files can hold variable-length records. In this situation the file can have records with various
DELETE STATEMENT: The format of the delete statement is as shown below: DELETE file-name RECORD [ ; INVALID KEY imperative-statement ] Whenever the ACCESS MOD
RELATIONAL CONDITION: We know that a relational condition specifies a comparison between two operands and has the form. Operand-1 relational-operator operand-2
BLOCK CONTAINS CLAUSE: Integer -1 of the BLOCK CONTAINS clause indicates the block size either in terms of records or in terms of characters. For illustration, BLOCK CONTAINS
INDEXED SEQUENTIAL FILES: In the indexed sequential files which are also known as indexed files, the records are stored in the sequence order generally in ascending order. In
Comparing features of oracle rdbms with Mysql
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd