MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

Are views updateable?

1107

What is reorg?

1101

How can you find out the # of rows updated after an update statement?

1085

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1057

What is meant by dclgen?

1081

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1063

How is a typical db2 batch pgm executed?

1133

Differentiate between cs and rr isolation levels? Where do you specify them?

1042

Name the various locking levels available?

1062

Explain how can you do the explain of a dynamic sql statement?

1085

How do you find the maximum value in a column in db2?

1081

How do you eliminate duplicate values in db2?

1129

How do you concatenate the firstname and lastname from emp table to give a complete name?

1037

How do you pull up a query which was previously saved in qmf?

1117

When do you specify the isolation level?

997

Un-Answered Questions { MainFrame }

System Testing for Mainframe Developers What is System Testing? integration testing ? what's the procedure ..

2032

What is scrollable cursor in db2?

1022

What is a bind card?

1176

which type of object is used in db2/400?

1019

What is the quality process in development?

1044

Explain the difference between a package and a plan. How does one bind 2 versions of a cics transaction with the same module name in two different cics regions that share the same db2 subsystem?

1004

a multiple format logical file is also known as?

1031

What are the rules employed while naming the steps in a job?

1116

how can you check for a records existence without causing and i/o (chain/read)?

2029

What is meant by a ‘Transid’ ?

1021

What r the comman abends in db2, jcl and cobol???????

2225

how can u check no of records in a file?

1110

How do you select a row using indexes in db2?

1090

What is concatenating?

1049

what is use of linkage section?

1045

For More Un-Answered { MainFrame } Questions Click Here