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!
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 sorted on the merge keys. The SORT statement rules in respect of the ASCENDING/DECENDING KEY phrase are also applicable in this situation.
Let us suppose that there are three zones and as such three sales files are to be merged. The Three files are named as ZONE-FILE-1, ZONE-FILE-2 and ZONE-FILE-3.
It has been supposed that all the three input files and the last merged file termed as MERGED-FILE are the tape files.
B (Blank Insertion) : The occurrence of a B anyplace in the picture will insert a space character in the edited data. There can be more than one B in the picture. Examples:
RULES OF REDEFINES CLAUSE The rules shown below govern the use of the REDEFINES clause: (i) The level-number of data-name-1 and data-name-2 should be identical. (ii) Exce
File- Section &Working-Storage Section: a) FILE SECTION: The FILE SECTION includes the explanation of all data items that must be read from or written onto some external
MOVE CORRESPONDING: It is frequently required to move some of the data items of one group to some other data items in the other group. If the names of the equivalent data item
RULES OF RENAMES CLAUSE: The rules below should be observed while using the RENAMES clause: (i) All RENAMES entries should be written only after the last record descript
Comparing features of oracle rdbms with Mysql
COMPOUND CONDITION: The two simple conditions can be connected by the logical operators AND or OR to form a compound condition (also termed as combined condition). When two co
OCCURS CLAUSE - PROGRAM: We have to write a program to demonstrate the occurs clause. Get names of the students and show them on the screen. identification division.
Label Records / Disk Directory: The most important information stored in the header label is what is termed as the file title. In the situation of magnetic-disk files the labe
PROGRAM FOR INVENTORY We have to write a program to update the inventory file. Consider 2 files,viz, invfile an tranfile. Invfile has 3 fields pno,name,qty. Tranfile has 3 fil
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd