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 5672

what is a trigger and types of triggers

HSBC,

3 7564

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 5518

what is rebinding ?

IBM,

1 5118

what is the use of bind parameter, Replace?

IBM,

5 8709

difference between group clause and order clause

 1 4474

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

 1 3506

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

Syntel,

1 4877

what is different three logs in DB2?

Syntel,

1 4954

what is difference between random and sequence file access

Syntel,

1 4249

How do you run JCL in cobol program

IBM, Syntel,

1 4775

what is difference between Plan and Package

Syntel,

1 5190

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 8986

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

Hewitt,

1 5024

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

 3 43030

Post New DB2 Questions

Un-Answered Questions { DB2 }

Discuss about db2 bind?

664

Can we insert update delete in view?

569

Explain about open switch business continuity software?

557

What is performance tuning db2?

605

How to create db2 table in mainframe?

625




How to execute stored procedures?

616

How is deadlock resolved?

646

List out the three types of page locks that can be held.

681

What is the physical storage length of the data types date, time, and timestamp?

598

What is runstats utility in db2?

565

What do you mean by commit and rollback?

588

What is a plan and package in db2?

609

List out the data types available.

694

How do I change the column size in db2?

583

What is an instance database?

594

For More Un-Answered { DB2 } Questions Click Here