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!
Edit Characters for Numeric Data:
The characters below can be used in the PICTURE clause to indicate the editing.
Z * $ - + CR DB . , B O /
The use of these edit characters are elucidate below:
Z (Zero Suppression) :
The edit character Z is used to repress the leading zeroes in the numeric data item. The leading zeroes are substitute with blanks.
The Z character has no effect of trailing the zeroes.
77 level used for- It is Elementary level item. it Cannot be subdivisions of other items or cannot be qualified, or they can be subdivided themselves.
PROGRAM TO DEMONSTRATE SORT VERB: The file for which a record having 2 fields, viz., Account Number and Name is already available. Sort the file based on the ascending order o
SIGN CONDITION: The sign condition establishes whether or not the algebraic value of an operand is negative, positive or zero. The operand can be either the numeric identif
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.
PROGRAM TO DEMONSTRATE MERGE VERB: The two files for which a record having 2 fields viz. Account Number and Name are already available. Now Merge these two files and create a
Example of Sign condition: The illustration below describes the use of the sign condition. Illustration: 77 BALANCE PIC S9 (6) V99. . . I
There are some restrictions when these procedures are used. (i) The Procedure should not contain any SORT/MERGE statement. (ii) An explicit transfer of the control outside
Comparing features of oracle rdbms with Mysql
DELETE STATEMENT: The format of the delete statement is as shown below: DELETE file-name RECORD [ ; INVALID KEY imperative-statement ] Whenever the ACCESS MOD
Occurs Clause: Let us establish tables with the help of an illustration. Assume that there are ten different types of income-tax rates that are read from some input medium and
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