Interested to Buy Any Domain ? << Click Here >> for more details...
What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 14870 Views
- I also Faced
- E-Mail Answers
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 |
Suppose i have a Cobol field of 10 byte. it contains a decimal sign.How to know where is the point location?
I have a file it contain 10 records.i got abend at 8th record because of soc7.how do you know that perticular record got abend?
How to pass return codes from cobol to jcl?
what happens when a copybook variables are declared using include statement ?
How to get the last record in vsam file in cluster? And how can you get the ksds file records into your cobol program?
What is the size of s9(19)comp3? explain
WT R TECHNICAL MAINFRAME QUESTION ASKED IIN ANJANASOFTEARE??
how we separate the cobol cics statements from cobol&cics programming?
after udatingg first 110 rows, my job abends. now how do i change my cobol program so that when i restart the Job it will start updating from 111th row ( i.e in next run I di=ont want to update those 110 rows which are already been updated in the first run before job abend)
What is binary search?
How will you find the currepted records in a file
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
COBOL 
