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 5692

what is a trigger and types of triggers

HSBC,

3 7582

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 5526

what is rebinding ?

IBM,

1 5136

what is the use of bind parameter, Replace?

IBM,

5 8731

difference between group clause and order clause

 1 4486

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

 1 3522

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

Syntel,

1 4887

what is different three logs in DB2?

Syntel,

1 4962

what is difference between random and sequence file access

Syntel,

1 4253

How do you run JCL in cobol program

IBM, Syntel,

1 4787

what is difference between Plan and Package

Syntel,

1 5196

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 9008

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

Hewitt,

1 5028

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

 3 43060

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to find the number of rows in a db2 table?

644

Define declaration generator (dclgen).

665

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7504

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2375

What are the uses of db2 optimizer?

815




What is db2?

739

What language is db2 written in?

595

What is the use of db2 optimizer?

606

How to check sequence on a table in db2?

598

Give the name of some fields form sqlca.

609

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

744

How many databases can be created inside an instance in db2 ?

595

What is dbrm? When it will be created?

594

What is deadlock in db2?

577

Explain dclgen.

722

For More Un-Answered { DB2 } Questions Click Here