Deutsche Bank Mainframe Developer Interview Questions, Process, and Tips

To increase performance of a COBOL program using multiple cursors, consider optimizing the SQL queries, reducing the number of cursors, and using efficient data structures.

• Optimize SQL queries to retrieve only necessary data

• Reduce the number of cursors by combining multiple queries into one

• Use efficient data structures like arrays or tables to store and manipulate data

• Avoid unnecessary looping and processing within cur

To resolve division by zero error, check for zero before performing division operation.

• Check if the denominator is zero before performing division operation

• Handle the error by displaying a message or returning a default value

• Use conditional statements or try-catch blocks to prevent division by zero

Abend the program by moving error code to Return code

• To abend the program, set the return code to a non-zero value indicating an error

• This can be done using a conditional statement to check for errors and then setting the return code accordingly

• For example, in COBOL, you can use the ACCEPT statement to move the error code to the return code

To check if a file is empty, you can use file size or read the file and check for any content.

• Check the file size using system functions like stat() or file length property

• Read the file and check if there is any content present

• Use file handling functions to determine if the file is empty

To read a file with different record structures, use a combination of file parsing techniques and data manipulation.

• Identify the record structure of each section in the file

• Use conditional logic to parse each record based on its structure

• Implement error handling for unexpected record structures

• Utilize tools like regular expressions or custom parsing functions

• Consider using libraries or frameworks that support flexible

No, SQLCA EXEC SQL is not mandatory for Mainframe Developer.

• SQLCA EXEC SQL is not mandatory but can be used for error handling and status checking in COBOL programs.

• It is used to retrieve information about the most recent SQL operation.

• Developers can choose to use SQLCODE and SQLSTATE instead of SQLCA EXEC SQL.

Data from Cobol can be passed to JCL using file handling techniques like writing data to a dataset or passing parameters through PROCs.

• Use file handling techniques to write data from Cobol program to a dataset that can be accessed by JCL.

• Pass parameters from Cobol program to JCL using PROCs.

• Use symbolic parameters in JCL to reference data from Cobol programs.

Use the COND parameter in the JCL to prevent job abend when subscript limit is reached.

• Use COND parameter in JCL to check for subscript limit before executing subsequent steps

• Set COND parameter to check for specific return code when subscript limit is reached

• Add a condition to bypass subsequent steps if subscript limit is exceeded

To add the 10th additional record in a file using a Cobol program, you would need to read the file sequentially and write the new record at the appropriate position.

• Read the file sequentially until you reach the 9th record

• Write the 10th record at the current position in the file

• Update the file with the new record