1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

explain about index with examples

Syntel,

2 5832

what is a trigger and types of triggers

HSBC,

3 7685

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 5622

what is rebinding ?

IBM,

1 5214

what is the use of bind parameter, Replace?

IBM,

5 8886

difference between group clause and order clause

 1 4539

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

 1 3585

what is difference between Static call and Dynamic call? How does it function?

Syntel,

1 4971

what is different three logs in DB2?

Syntel,

1 5040

what is difference between random and sequence file access

Syntel,

1 4322

How do you run JCL in cobol program

IBM, Syntel,

1 4872

what is difference between Plan and Package

Syntel,

1 5265

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

Syntel,

5 9173

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

Hewitt,

1 5115

What is -904 sql code? How to resolve it?

 3 43596

Post New DB2 Questions

Un-Answered Questions { DB2 }

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1670

Explain package in db2 and its advantages?

632

How will you return the number of records in table?

545

What do you mean by storage group (stogroup)?

614

What is db2? Explain.

634




What is dclgen (declaration generator)?

638

What is the use of commit in db2?

665

What is null in db2?

609

Is ibm db2 free?

614

What is nvl in db2?

667

How to resolve deadlock issue

18189

What's The Error Code For Unique Index Voilation?

680

What are the contents of a dclmgen?

662

What is the use of db2 optimizer?

646

What is the clustering index in the db2 database?

610

For More Un-Answered { DB2 } Questions Click Here