elayarajack
New User
Joined: 15 Feb 2004
Posts: 8
|
|
|
|
hi,
thanks for your timely help. can you give me answer to my folowing questions too
1.what are the differences between vasm and db2. why we r going for db2.
2.function of REBIND option
3.how to access even records(ie record 22, 24, ..... upto 40 from 20) in indexed organization and dynamic access mode using alternate indexes.
plse do clear these doubts. |
|
franclin
New User
Joined: 23 May 2003
Posts: 11
Location: Chennai, India
|
|
|
|
Dear,
| Quote: |
| 1.what are the differences between vasm and db2. why we r going for db2. |
VSAM means virtual storage access methods of storing your data permanantly in DASD.
DB2 is a relational database, which also stores data, but give you a high access control over it.
there is no relation b/w data in a VSAM file, but DB2 provides integirity and entity relationship among data.
| Quote: |
| 2.function of REBIND option |
REBIND binds your DBRM again without disturbing your base program. You can prefer REBINDING whenever,
a) An INDEX is added to your table
b) RUNSTATS utility has been run
Always prefer rebinding, instead of bind, whenver any authorization changes have been made to the table, but not any SQL statements in your program.
| Quote: |
| 3.how to access even records(ie record 22, 24, ..... upto 40 from 20) in indexed organization and dynamic access mode using alternate indexes. |
Begin with your START commend with indexed from 20NTH RECORD. Use READ NEXT commend twise. Display the second READ NEXT valued. It will give you all even records. Perform this loop 10 times. |
|
