DB2 Interview Questions
Questions Answers Views Company eMail

explain about index with examples

Syntel,

2 4255

what is a trigger and types of triggers

HSBC,

3 5749

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 4055




what is rebinding ?

IBM,

1 3813

what is the use of bind parameter, Replace?

IBM,

5 6179

difference between group clause and order clause

1 3473

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

1 2572

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

Syntel,

1 3793




what is different three logs in DB2?

Syntel,

1 3774

what is difference between random and sequence file access

Syntel,

1 3241

How do you run JCL in cobol program

IBM, Syntel,

1 3561

what is difference between Plan and Package

Syntel,

1 4046

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 6190

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

Hewitt,

1 3727

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

3 29937


Post New DB2 Questions






Un-Answered Questions { DB2 }

B37 abend during spufi?

121


What is the difference between drop table and delete table?

43


Is db2 free?

44


Explain the benefits you can get from mainframe connect?

35


What's The Percentage Free Space ?

122






Define db2 and its databases?

68


Is db2 a programming language?

47


What db2 400?

50


What are the different types of base tables?

82


List out the buffer pools in db2

103


How to find the maximum value in a column in the db2 database?

79


Which isolation level provides maximum concurrency?

73


What is drop table?

42


How to check table size in db2 sap?

47


What is a system catalog table in db2?

45