DB2 Interview Questions
Questions Answers Views Company eMail

explain about index with examples

Syntel,

2 5627

what is a trigger and types of triggers

HSBC,

3 7510

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 5469

what is rebinding ?

IBM,

1 5086

what is the use of bind parameter, Replace?

IBM,

5 8624

difference between group clause and order clause

1 4448

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

1 3479

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

Syntel,

1 4843

what is different three logs in DB2?

Syntel,

1 4923

what is difference between random and sequence file access

Syntel,

1 4217

How do you run JCL in cobol program

IBM, Syntel,

1 4725

what is difference between Plan and Package

Syntel,

1 5141

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 8904

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

Hewitt,

1 4979

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

3 42779


Post New DB2 Questions

Un-Answered Questions { DB2 }

How can you count the number of rows from a table tab?

608


What is innodb buffer pool?

539


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2733


What is syscat in db2?

540


What is meant by dclgen?

594






What is declare cursor?

588


What types of tables are there in the db2 database?

533


How to find the number of rows in db2 tables?

588


What is the default page size of buffer pools?

627


What are db2 tables?

624


What is difference between rollback and commit?

602


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

636


What is a bind card?

659


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1684


What is the physical storage length of date data type?

695