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

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.

RBS,

2 7459

Q3. How will you fetch duplicate values from a DB2 table?

RBS,

2 15000

Q4. How will you get the count of record without using COUNT verb in query?

IBM,

2 12715

I have file with data as follows data 1 2 3 4 5 I need to read 1 and 5 ,then 2 and 4 then like.. upto end of file, can any one help on this

ISG,

3 8268

I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

CSC,

2743

Is it possible to add an keyfield or field to an Physical file without changing its file identifier. Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.

2 5316

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 5314

What is the exact difference between Service Program and Binding Directory?

1 7423

What are the types of Signature validation?

1 4417

What is an Array Data Structure?

1 3930

How to read data from *LDA (Local Data Area) in RPGLE program without using IN opcode?

1 9469

can i sort packed decimal if i can tell the syntax

Barclays,

1 5651

What is Multi Occurrence Data Structure(MODS)?

CTS,

1 4639

In all our JOB Statement we have always COND=(4,LT) defined. Nevertheless when a Job failed the last step should then be executed (send a message to an user). Due to we don't like to change all our JOB's (ca. 2000), we are looking for a simply solution.

4 9850

What is IBM OS/2?

1 2683

Un-Answered Questions { MainFrame }

What is the difference between lds and esds?

1048

What is the actual use of fillers?

966

What is recovery parameters in define cluster command?

1057

What are catalog tables in db2?

1050

How to override loadlib?

2040

What is the difference between SEND MAP DATAONLY and SEND MAP MAPONLY ?

1247

what is scan and xlate?

1839

Explain how does idms communicate with cics?

905

What is buffer pool in the db2 database?

1107

what is cab?

1166

What is the function of the dd mgmtclas keyword in sms datasets?

1237

Can you explain function of iebgener?

1029

how to handle -911 (deadlock) error in a db2 program so that the program will never abend?

1035

What is input procedure?

996

Is acct parameter mandatory?

1210

For More Un-Answered { MainFrame } Questions Click Here