Explain the difference between an internal and an external
sort, the pros and cons, internal sort syntax etc.
Answers were Sorted based on User's Feedback
Answer / vampire
Internal sort is manual sort use in cobol.
external sort is in jcl using inbuild program name called sort
ex
//step1 exec pgm=sort
synatx for internal sort
sort/merge sortfile on ascending/descending
key1/key2/key3,using file1/file2/input procedure is
section-1 giving file3/file4/output procedure is section-2
nobody can write syntax more than this.it is combination.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ajmal
I would like to add something to that.
External Sort's syntax
//SYSIN DD *
SORT FIELDS = (length of key, starting position of key,
CH, A/D)
/*
A - Ascending
D - Descending
Correct me if i'm wrong
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / mailid
Sort fields syntax is
//SYSIN DD*
SORT FIELDS=(START POSITION,LENGTH,A/D,DATATYPE)
/*
| Is This Answer Correct ? | 0 Yes | 1 No |
Following questions were asked in Capegemini on 8th sep,2012 mainframe test 1.)Condition code for dul recors in VSAM- 2.) Is NULL or =NULL in Select statement 3.)max size of CI 4.)What happens after CI is full 5.)Ques on COND parameter 6.)which among following can not be rolled back a)delete table b.)droptable c)Update d.)insert 7.)groupby and orderby sql querries 8.)Max extents in VSAM file 9.)quesn on DPRTY=(1,10) 10.)range of condition codes in COBOL 11.)occurs clase can not be used at which level? 12.)delimiter in jcl 13.)sort card for file in PGM=SORT 14.)PIC(6) value 120056 possible? 15)question on BLKSIZE Is (20,20) and (20,10) possible? 16.)number of bytes in RDF 17.)Can we use index in WS-section or LK-section 18.)Verify command in IDCAMS used for? 19.)question on Alternate Index 20.)Return code of file attribute mismatch 21.)In which format COBOL variables stored? 22.)what is Alternate of HANDLE? 23.)can SUM,AVG,MIN,ROUND used in numeric and char variable data types? 24.)What is the datatype of FILE STATUS codes in WS-section?
Hai friends why we need to read a file before re-write a record?
I've one string with spaces ( I N D I A ). My question is I want remove the spaces & combine in to single string without space (INDIA).How we can write the cobol program & wich options we need to use. Please let me know.
Suppose i have a Cobol field of 10 byte. it contains a decimal sign.How to know where is the point location?
We have 3 programms A,B,C.In the middle of the program A the controls goes to program B and in the middle of the program B control wants to go program C,after completion of program C again control comes to program B and again after completion of program B control comes to program A.How the process will takes and what are the controls we use for that process.If it is possible anybody of you explain with example?
What is the purpose of Identification Division?
Write the code to count the sum of n natural numbers.
Write some characteristics of cobol as means of business language.
What is the difference between next sentence and continue in cobol programing language?
what is the minimum number of lines a Cobol program should have to successfully compile and run
Write the code implementing the perform … varying.
how we rectify soc4 and soc7 error in project(need real time answer)? please reply