Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What is a junction record in IDMS?
- Correct Answer
- A junction record is a member record type that allows for many-to-many relationship between its two owner records
- 1. How does IDMS insure data integrity? Discuss
- 2. If you are current on the owner of a set, what is the difference between an obtain next and obtain first in IDMS? Discuss
- 3. What is the meaning of Copy IDMS Subschema-Binds? Discuss
- 4. Is there a application program coding difference between local and central version mode in IDMS? Discuss
- 5. What is an OOK-Rec in IDMS? Discuss
- 6. What is currency in IDMS? Discuss
- 7. What is purpose of VSAM? Discuss
- 8. How do you convert flat files to VSAM files? Discuss
- 9. During processing of a VSAM file, some system error occurs and it is subsequently unusable What do you do? Discuss
- 10. Name some common VSAM error conditions and codes? Discuss
Technology problems
Search Results
Correct Answer: IDMS uses record locks to prevent another run-unit from updating the same record
Correct Answer: No difference There is a difference between obtain first and obtain next for an area sweep, but not when current on the owner in a set
Correct Answer: It generates a bind run-unit and binds all the records for the sub-schema the program is referencing
Correct Answer: No The mode is specified via the SYSCTL DD card in the JCL
Correct Answer: An OOK-Rec is a one of a kind record set, used to get to another record set
Correct Answer: Currency is the location within the database during run-unit execution There are four levels of currency: - Current of run-unit is the record occurrence of the last successful find or obtain; - Current of record type is for the most recent of each record type; - Current of record set is the most recent within each set - Current of area is within each area
Correct Answer: VSAM acts as an interface between Application program & Operating System
Correct Answer: Use IDCAMS REPRO to load the flat file into the VSAM file
Correct Answer: Run VERIFY
Correct Answer: End of file (10) Duplicate key (22) Record not found (23) VSAM logic error (90) Open problem (92) Space problem (93)
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.