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!
FILE-CONTROL paragraph for the indexed files:
The common format for the SELECT clause for a file is as shown below:
SELECT file-name ASSIGN TO implementor -name
The ORGANIZATION clause specifies that the file is an indexed file. The RECORD KEY clause indicates the record key data item on the basis of which the file is sequenced. The field that is specified in the RECORD KEY clause (data-name-1) is also termed as the primary key. Whereas the files are stored on the basis of the prime key, that is the records of an alternative key.
OPEN statement: We know that the processing of a file should start with the execution of an OPEN statement. The file can be opened in any one of the 4 open modes - INPUT, OUTP
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
START STATEMENT: The START statement places the files to the initial logical record whose record key satisfies the condition specified by the KEY phrase. The access mode shoul
Floating Insertion The currency symbol ($) can emerge in multiples on the left-hand side of the picture. In this situation the character will be treated in similar way as t
File Activity: The file activity is a measure of the proportion of records processed during an update run. Therefore we define the activity ration as shown below. Activi
PROGRAM USING OCCURS CLAUSE: We have to write a simple program to demonstrate Occurs Clause. Get the employee details for 3 persons and compute the total salary. identifica
REWRITE STATEMENT: The REWRITE statement has the format for a relative file as shown below, REWRITE record-name [ FORM identifier ]
DELETE STATEMENT : The file should be opened in the I-O mode. If the access is SEQUENTIAL, the INVALID KEY phrase must be specified. Rather than, the last input-output state
Example of Sign condition: The illustration below describes the use of the sign condition. Illustration: 77 BALANCE PIC S9 (6) V99. . . I
Comparison of Nonnumeric Operands: A nonnumeric operand can be compared to the other nonnumeric operand according to the rules as shown below: (i) Fields of Equal Sizes:
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