Mainframe, MVS and zOS Discussion

1. Describe different transaction isolation levels in DB2 and their implications.
2. What SQL statements have you used extensively during development and support?
3. Explain the effects of using CURSOR WITH HOLD with GROUP BY and ORDER BY clauses in your queries.
4. How do you retrieve the current system date and time using DB2 and COBOL?

1. Describe a situation where you encountered a JCL error code -904. What was the cause and how did you resolve it?
2. How can you check for empty files and locate specific characters within files using JCL utilities?
3. How do you reference the output dataset from a previous step in a JCL job with multiple steps?
4. Explain the purpose and usage of COND=EVEN and COND=ONLY parameters in JCL.
5. How do you manage the deletion of a GDG (Generation Data Group)?

1. Explain how to declare and use host variables in COBOL programs.
2. How can data be passed from a JCL job to a COBOL program?
3. What happens when you encounter a SUM FIELDS = NONE condition in COBOL?
4. Describe the compilation process for COBOL programs that interact with a DB2 database.

DB2Explain the effects of using CURSOR WITH HOLD with GROUP BY and ORDER BY clauses in your queries.

DB2What happens when you encounter a SUM FIELDS = NONE condition in COBOL?
 

 

I think we can not use GROUP BY and ORDER BY in the same cursor?

SELECT CREATOR,COUNT(*)
FROM   SYSIBM.SYSTABLES            
GROUP  BY CREATOR                  
ORDER  BY 2 DESC                  

DB2 Guy" wrote: ↑Mon Apr 22, 2024 9:34 pm This might interest some of you. Listed below are the Mainframe Interview Questions for 3-5 Years Experience:Database and SQL

1. Describe different transaction isolation levels in DB2 and their implications.
2. What SQL statements have you used extensively during development and support?
3. Explain the effects of using CURSOR WITH HOLD with GROUP BY and ORDER BY clauses in your queries.
4. How do you retrieve the current system date and time using DB2 and COBOL?

JCL and Data Management

1. Describe a situation where you encountered a JCL error code -904. What was the cause and how did you resolve it?
2. How can you check for empty files and locate specific characters within files using JCL utilities?
3. How do you reference the output dataset from a previous step in a JCL job with multiple steps?
4. Explain the purpose and usage of COND=EVEN and COND=ONLY parameters in JCL.
5. How do you manage the deletion of a GDG (Generation Data Group)?

COBOL Programming

1. Explain how to declare and use host variables in COBOL programs.
2. How can data be passed from a JCL job to a COBOL program?
3. What happens when you encounter a SUM FIELDS = NONE condition in COBOL?
4. Describe the compilation process for COBOL programs that interact with a DB2 database.

All the best,