What is Alternate Index ? How is it different from regular
index ?
Answers were Sorted based on User's Feedback
Answer / vish
The answer provided by NK is absolutely correct but we
should be very careful whil choosing the alternate index as
it may not be Unique. e.g. in the example given by NK, the
Emp# will always be Unique within a company but many many
employees can have the same name. So if we declare Emp_name
as AIX (i.e. alternate Index) and then use it for fetching
data then we may end up in multiple rows and hence we may
need additonal logic to arrive at the desired unique record.
Your comments are Welcome!!
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / nk
The purpose of any index is to provide the most efficient
access to the records in a file. Say you have a file of
employee names and numbers. Usually the primary index will
be the employee number. If you request a record by
providing the empl#, the access will be very fast. If you
have to very often request a record by the empl name, you
may want to create a second (a/k/a alternate) index based
on the name. So when you provide a name, the access to the
correct record also will be very fast.
Is This Answer Correct ? | 10 Yes | 2 No |
wht happens if we dnt give scope terminator ?
can u give result for the fallowing example... 05 a pic 9(2) 05 b redifines a pic x(2). move 'xy' to b. display a,b.
1)what is use of linkage section? 2)what is difference between comp and comp-3
What is the difference between PIC 9.99 and 9v99?
we can use set true for condition names.. similarly can we code set to false in cobol pgm? will it work?
WE HAVE 2 FILES IN COBOL. ONE IS FIXED LENGTH RECORDS ANOTHER ONE IS VARIABLE LENGTH. IF I DECLEAR LRECL OF FIXED ONE AS 80 AND 2ND RECORD AS 132. WHAT WE NEED TO DECLEAR LRECL FOR THOSE 2 FILES IN JCL?
how do you reference the variable unblock file formats from cobol programs
hi friends,can any one post the ibm mainframe inteqview questions for 1year exp candidate,for itc infotech interview?. have any body attended for this in the past?...
.How to add one input & one Out file in existing cobol program. how approach tell me step by step.
What are the divisions in a cobol program? Which one is the mandatory division among them?
I have 2 dimensional array with having 100 elements. So how to find the 11th item in an array?
where did you see the information regarding abend codes in jcl?