Deutsche Bank
Gokul Refoils & Solvent Interview Questions and Answers
Q1. what syntax you give in Parm parameters to not be abend job when Subscript had ended his limit?
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
Q2. How will you abend the program? by moving error code to Return code
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
Q3. How will you read your file in different record structure ?
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 file parsing
Q4. How will you increase performance of cobol program when its using number of cursors?
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 cursor operations
Q5. How you will add 10 th additional record in file using Cobol program , what is the path.
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
Q6. How will you give data from Cobol to JCL ?
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.
Q7. How will you resolve division by zero error Socb
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
Q8. How will you check if file is empty ?
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
Q9. is SQLCA EXEC SQL is mandatory ?
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.
More about working at Deutsche Bank
Interview Process at Gokul Refoils & Solvent
Top Mainframe Developer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month