Add office photos
Deutsche Bank logo
Employer?
Claim Account for FREE

Deutsche Bank

3.9
based on 3.4k Reviews
Video summary
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Mainframe Developer
Clear (1)

Deutsche Bank Mainframe Developer Interview Questions and Answers

Updated 5 Jul 2024

Q1. How will you abend the program? by moving error code to Return code

Ans.

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

View 1 answer
right arrow

Q2. what syntax you give in Parm parameters to not be abend job when Subscript had ended his limit?

Ans.

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

View 1 answer
right arrow

Q3. How will you read your file in different record structure ?

Ans.

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

Add your answer
right arrow

Q4. How will you increase performance of cobol program when its using number of cursors?

Ans.

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

Add your answer
right arrow
Discover Deutsche Bank interview dos and don'ts from real experiences

Q5. How you will add 10 th additional record in file using Cobol program , what is the path.

Ans.

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

Add your answer
right arrow

Q6. How will you give data from Cobol to JCL ?

Ans.

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.

Add your answer
right arrow

Q7. How will you resolve division by zero error Socb

Ans.

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

Add your answer
right arrow

Q8. How will you check if file is empty ?

Ans.

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

Add your answer
right arrow

Q9. is SQLCA EXEC SQL is mandatory ?

Ans.

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.

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Deutsche Bank Mainframe Developer

based on 1 interviews
Interview experience
5.0
Excellent
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Mainframe Developer Interview Questions from Similar Companies

Infosys Logo
3.6
 • 13 Interview Questions
TCS Logo
3.7
 • 13 Interview Questions
View all
Recently Viewed
INTERVIEWS
UKG
No Interviews
INTERVIEWS
UKG
No Interviews
INTERVIEWS
Deutsche Bank
5.6k top interview questions
INTERVIEWS
UKG
No Interviews
INTERVIEWS
Company Interviews
No Interviews
INTERVIEWS
UKG
No Interviews
INTERVIEWS
Company Interviews
No Interviews
INTERVIEWS
UKG
No Interviews
INTERVIEWS
Apco Infratech
No Interviews
INTERVIEWS
Company Interviews
No Interviews
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter