1. Categories >> Software >> MainFrame >> IBM MainFrame
  2. Suggest New Category


IBM MainFrame Interview Questions
Questions Answers Views Company eMail

explain about index with examples

Syntel,

2 5694

what is an MDT in cics

Syntel,

4 9292

what is a trigger and types of triggers

HSBC,

3 7584

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 5531

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

TCS,

6 9406

what is a steplib

CGI,

4 6615

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

Syntel,

3 6554

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 6902

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

 3 9466

give the examples for strings and unstrings in cobol

IBM,

2 6610

what is rebinding ?

IBM,

1 5141

what is the use of bind parameter, Replace?

IBM,

5 8733

can we access sequential files online

Cap Gemini, GS,

4 7631

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

 3 4595

can we write a proc with in a proc

IBM,

4 6543

Un-Answered Questions { IBM MainFrame }

What are IDMS set of occurances?

985

Explain correlated sub-queries.

587

Define cedf?

565

What is the function of the steplib dd statement?

739

How can record locking be achieved in those DB2 versions which do not support it?

623




Can QSAM files be accessed from CICS?

678

what is the right time for using in-line perform?

585

What are some jcl statements that are not allowed in procedures?

724

How do I create a view in db2?

599

Explain difference between call and link?

556

What are the distinctive features of a ksda, key sequenced dataset?

525

What does the keyranges parameter in define cluster command do?

522

how many buffers are allocated to vsam ksds and esds?

705

What does db2 plan contain?

573

Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?

624

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