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 7480

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

RBS,

2 15027

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

IBM,

2 12742

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 8295

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,

2755

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 5342

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 5334

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

1 7440

What are the types of Signature validation?

1 4433

What is an Array Data Structure?

1 3949

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

1 9487

can i sort packed decimal if i can tell the syntax

Barclays,

1 5665

What is Multi Occurrence Data Structure(MODS)?

CTS,

1 4653

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 9889

What is IBM OS/2?

1 2702

Un-Answered Questions { MainFrame }

What is the function of finish in idms?

905

How can we retrieve the total number of records in RPG & CLLE?

668

Can you define commarea?

993

How to access db2 tables in mainframe?

1067

how do you specify the number of records to roll in a subfile ?

2190

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

987

Which isolation level provides maximum concurrency?

1169

what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?

1019

What is dbrm in db2 database?

1136

How can we see the copy book length using file-aid?

973

How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?

1271

how to refer the data field?

2290

Explain the types of perform?

1031

What is qsam?

846

define the purpose of the %sst function?

1673

For More Un-Answered { MainFrame } Questions Click Here