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

what is a trigger and types of triggers

3 9377

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 6661

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

TCS,

6 11909

what is a steplib

CGI,

4 8480

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

Syntel,

3 8279

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 8440

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

3 10826

give the examples for strings and unstrings in cobol

IBM,

2 8175

what is rebinding ?

IBM,

1 6003

what is the use of bind parameter, Replace?

IBM,

5 10972

can we access sequential files online

Cap Gemini, GS,

4 9578

can we creat a member logical file

3 10326

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

3 5782

can we write a proc with in a proc

IBM,

4 8105

what is the compile process of cobol program expalin with code

IBM,

2652

Un-Answered Questions { MainFrame }

Explain the difference between a package and a plan.

1137

Differentiate between control interval (ci) and control area (ca)?

1053

What are the information stored in ci?

1070

Express the distinction between jes2 and jes3?

1244

which are the query selection criteria, which can be given in a query?

1221

How to write record if no field or the field are different in physical file in rpgle ?

1032

How does a cursor work?

1043

What is a set in idms? What pointers are required, what are possible? How may sets be ordered?

931

Name the 3 common ways to create maps?

1201

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

1164

how can you copy to a vsam cluster?

1212

how to define to define a hidden filed in dspf ?

1409

What is dbrm in db2 database?

1198

What is difference between isnull and coalesce?

1116

How to update physical file using logical file with example?

1106

For More Un-Answered { MainFrame } Questions Click Here