Interested to Buy Any Domain ? << Click Here >> for more details...
What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 14993 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 |
What is the reference modification.
consider two data items 77 W-A PIC 9(3)V99 VALUE 23.75 77 W-B PIC ZZ9V99 VLAUE 123.45 after the statement MOVE W-A TO W-B what will be W-B's value? a.123.75 b.b23.75 (where b indicates space) c.023.75 d.invalid move
Write down the divisions of cobol program?
can I copy book which contain db2 statment in procedure divion?
How can we increase the size of an existing PDS to include more no. of modules.
How to read the last 100 records from a COBOL file. The file contains N number of records.
IF I mention stop run in CICS what happens?
1.give the details about WHEN OTHER. 2. how many form are available in evaluate.
What are the differences between COBOL and COBOL II?
SUPPOSE I HAVE 60 CHARACTERS STING. IN THAT I WANT FIND OUT HOW MANY TIMES 'A'(ASSUME)WILL REPEATED AND I HAVE TO PASS 'E' IN PLACE OF 'A'ALONG THAT STRING.
What is report-item?
What is the LINKAGE SECTION used in COBOL?
COBOL 
