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 6323

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

RBS,

2 14012

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

IBM,

2 11711

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 6832

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,

2254

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 4245

Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 4543

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

1 6374

What are the types of Signature validation?

1 3610

What is an Array Data Structure?

1 3052

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

1 8533

can i sort packed decimal if i can tell the syntax

Barclays,

1 4870

What is Multi Occurrence Data Structure(MODS)?

CTS,

1 3794

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 8058

What is IBM OS/2?

1 1945


Un-Answered Questions { MainFrame }

What is the format of comment statement?

654


name the utility program closely associated with vsam?

571


What is the use of base and index registers in the IBM 360/370 processor?

3327


What is a continuation triple? what is the use of limit sys?

1495


Difference Between Skip Before & Space Before?

664






How to alter the parameters for the existing gdg?

702


How to view db2 table structure?

581


What makes vrrds different from vsam?

699


Write a logic program for knowing the repeated number of a vowels in a given program?

3305


How to run db2 command in windows?

635


Define an associator in adabas?

526


What is the function of dd name parameter with a 2 part structure; audit.report?

693


Explain the different system tables used in cics?

531


How can the duplicate values be eliminated from db2 select?

619


Explain how many conditions can you include in a single handle condition command?

605