What are common codes and their purpases?

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

(Continued from previous question...)

What are common codes and their purpases?

Command codes extends the function of a SSA call. It simplifies programming and it improves performance.
C- Concatenated key.
D-path call,
F-first occurrence,
L- last occurrence,
N-path call ignore,
P - set parentage

(Continued on next question...)

Other Job Interview Questions

• What for procopt is used? List some of them
• How man key filed and search fields can a segment have?
• What is secondary indexing
• Which is the DL/I function used in CICS-IMS program?
• Define DBD?
• What are the parameters used in CBLTDLI call?
• What are the control block in IMS?
• What is the limitation on the no. of levels in a DL/I database ?
• Define DBD?
• Which is the first statement in COBOL-IMS programs?
• More...