How to read last record in vsam file.,I don't kn

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to read last record in vsam file.,I don't know how many records are there?

Move highvalues to the key of the VSAM file and the issue Readnext record command. Then give Readprev command. This will read the last record. In VSAM, there is one command HURBA, Using that we can read the last record, If you want to know more about go to IBM RED BOOKS. You will get the solution.
by using the HURBA we can get the max records by using the CKD count key data we will get the last record

(Continued on next question...)

Other Job Interview Questions

• At what stage DB2 must be up?
• Is BETWEEN inclusive of the range values specified? –
• What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
• Explain difference between sys.cat and sys.ibm?
• What is a clustered index?
• Is it mandatory to use DCLGEN? If not, why would you use it at all?
• How will you send data from a cobol file to DB2 table?
• How to read last record in vsam file.,I don't know how many records are there?
• Name some fields from SQLCA.
• What is lock escalation?
• More...