IBM MainFrame Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

COBOL (1072)
JCL (1031)
CICS (755)
DB2 (1122)

IMS (143)
IDMS (107)
Natural (81)
ADABAS (26)

REXX (60)
Assembler (68)
CLIST (6)
QMF (32)

MVS (25)
OS390 (10)
OS 2 (7)
VSAM (319)

IBM MainFrame Interview Questions

Questions Answers Views Company eMail

explain about index with examples

Syntel,

2 6935

what is an MDT in cics

Syntel,

4 10718

what is a trigger and types of triggers

HSBC,

3 9154

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

IBM,

2 6539

01 A pic 9(100) find record length of it

TCS,

6 11660

what is a steplib

CGI,

4 8257

using cursor how can you fetch more than one record into a variable

Syntel,

3 8097

If I defined space as TRK(10,10) for the one file and lrecl = 4K then tell me how many record will vsam file will contain. will it 1,2,3,4,5 or how many,

IBM,

3 8271

What is the difference between shroptions(2 3) and shroptions (4 3) in the Def CLUSTER ??

3 10692

give the examples for strings and unstrings in cobol

IBM,

2 8038

what is rebinding ?

IBM,

1 5899

what is the use of bind parameter, Replace?

IBM,

5 10742

can we access sequential files online

Cap Gemini, GS,

4 9416

if a>b continue display x. dispaly y. end-if display 1 display 2. display 3. what should be my output ?

3 5625

can we write a proc with in a proc

IBM,

4 7956

Un-Answered Questions { IBM MainFrame }

What is RRange and ARange?

2103

in a cobol select statement, can you tell what is the organization for a ksds?

1110

Why do we bind in db2?

1207

what are the codes returned by the ams (access method services) command during the execution in vsam?

1286

What is the maximum of key fields and search fields allowed in a segment?

994

What is ook-rec?

895

Explain dclgen.

1197

Explain the difference between cics program control table (pct) and cics processing program table (ppt)?

1051

What is coalesce in db2?

1129

Kindly specify the pic clause for the any bll cell type of data fields?

1215

What is access path in db2?

982

What is the function of entry sequenced data set?

1076

how to display the negative numbers?

2330

Explain the meaning of spufi?

1033

What are catalog tables in db2?

1044

For More Un-Answered { IBM MainFrame } Questions Click Here