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

Explain in brief how does db2 determine what lock-size to use?

1045

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 2065

How would you find out the total number of rows in a db2 table?

1052

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What are the contents of dclgen?

1112

Why select is not preferred in embedded sql programs?

1299

How do you select a row using indexes in db2?

1135

When reorg is used?

1129

What are the various isolation levels possible?

1122

How can you do the explain of a dynamic sql statement?

1069

Can you use max on a char column?

1097

List some fields from sqlca?

1058

Explain what are the various isolation levels possible?

1044

What is the physical storage length of the data types date, time, and timestamp?

1090

What is the use of value function?

1151

Un-Answered Questions { MainFrame }

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1737

I have a pf, it contains 5 members, how to access particular member data from logical file?

975

Explain the mdt in cics?

1164

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

2092

Why db2 is called db2?

1041

How to Clear a Query Using the RESET Command ?

1722

What is inspect in cobol ?

1301

IIN APITUDE THEY GAVE ONLY 10 QUESTIONS.. THEY ARE SIMPLE ONE FROM NUMBER SERIES,BOATS,TIME & DISTANCE,PROFIT &LOSS,FIND OUT THE NUMBER ? 9 25 4 36 81 64 49 AND surveillance SPELLINGS E.T.C

2184

Explain the function of //cntl statement?

1172

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

1125

Can you explain control variable in online screens?

983

When are scope terminators compulsory?

1038

What is the connection string to connect to the DB2 Database ?

1128

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104

What is data structure in as400? What is the use of data structure?

1085

For More Un-Answered { MainFrame } Questions Click Here