What is the purpose of the FILE STATUS clause in

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

(Continued from previous question...)

What is the purpose of the FILE STATUS clause in the SELECT statement?

The FILE STATUS field identifies the field that VSAM uses to provide information about each I/O operation for the file.

(Continued on next question...)

Other Job Interview Questions

• Do primary key values have to be unique? Do alternate key values have to be unique?
• What is a CA, control area?
• What more info you should give in the DD statement while defining the next generation of a GDG ?
• How do you load a VSAM data set with records ?
• How many buffers are allotted to VSAM KSDS and ESDS ?
• What is FREESPACE ?
• Syntax of AMS modal commands ?
• What is IDCAMS ? and what is the purpose of it ?
• What is the meaning of the DEFINE MODEL parameter?
• What is the device independent method to indicate where a Record is Stored ?
• More...