what is internal sort and external sort ?
which is preferable ?
Answers were Sorted based on User's Feedback
Answer / tejas sheth
Hi
For internal sort you need to code a program by specifying
the sort criteria and that the program need to be compiled
and linked.
But in case of External sort there is no need for coding the
program.Moreover you can change the sort criteria just by
changing the sort parameters that passed thru the SYSIN card.
So the external sort is more efficient compared to internal
sort.
| Is This Answer Correct ? | 24 Yes | 8 No |
Answer / udhaya
the internal sorting can reside in main memory....external
use secondary memory.....
-internal sorting is independent of time to read/write a
record...external ids dependent on the same
-internal sorting takes input only which can be fit into
its memory...i.e. it takes small input....whereas external
sorting can take as much as large input...
| Is This Answer Correct ? | 17 Yes | 3 No |
hi, can you ppl tell me, how to check whether the rewrite we gave for the ksds file is successful or not in the program.? i gave rewrite, the rewrite code is executing and maxcc=0 but updation doenot happen in the file?
When the working storage variables get allocated? a.At Compile time b.At starting of the run time c.At end of the run time. d.None of these
I have a field with data type X(10). I want to perform arithmetic operation on this field? I tried doing it by moving the value into a numeric field. but it didn't work out. I am getting a S0C7 abend. Pls let me know if there is any way of getting this done?
Did anybody attend the walkin of TCS on 31st July in Gurgaon for any technology,If u have completed 3 round i.e till the HR round,have u received the Offer letter yet? Please let me know.Thanks.
a. Can the OPTIONAL clause in COBOL only be coded for input files? b. If it is coded for files opened in OUTPUT, I-O or EXTEND mode, will it give a compilation error? c. If there are no compilation errors and if such files are not coded in the JCL, will the OPEN statement run fine when these files are opened? d. How will a WRITE statement work for the above files?
What is the default value of DISP for temp datasets
how can u find out just by seeing wheater it is main program or sub program ? any two ways to identify reply soon ?
What is the difference between perform … with test after and perform … with test before?
What is the difference between NEXT SENTENCE and CONTINUE?
how many bytes do SPPPP999 will store?
What is file status 92?
how will u retreive value from a table.write it with syntex. 01 ws-table 05 ws-table1 occurs 10 times. 05 ws-table2 occurs 10 times. the above is 2 dimensional array..how will u retrieve 1st element of an array