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 2066

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

1053

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?

1136

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 }

How to dsect parameter is used in bms?

1291

Express the distinction between jes2 and jes3?

1176

What are packages in db2?

1023

What is db2 instance?

1097

What is the term “where” for?

1007

what is the difference between *like and *namvar ?

2543

Is it possible using max on a char column?

1140

How to handle exceptional conditions in cics?

1137

What is netezza database?

1028

I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.

1566

Can you explain create an empty file by using sort?

954

can we use ASCII ,CDUP,SENDPASV commands in SFTP?

3664

What is the difference between escape(top or bottom) and escape immediate(top or bottom?

1028

Can you explain exec cics handle condition command?

1080

Is condition checking possible in jcl? If yes, how?

1292

For More Un-Answered { MainFrame } Questions Click Here