Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  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 5284

what is a trigger and types of triggers

HSBC,

3 6991

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 5090

what is rebinding ?

IBM,

1 4742

what is the use of bind parameter, Replace?

IBM,

5 7931

difference between group clause and order clause

 1 4223

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

 1 3257

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

Syntel,

1 4577

what is different three logs in DB2?

Syntel,

1 4607

what is difference between random and sequence file access

Syntel,

1 3942

How do you run JCL in cobol program

IBM, Syntel,

1 4427

what is difference between Plan and Package

Syntel,

1 4849

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 8196

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

Hewitt,

1 4617

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

 3 39369

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a collection in db2?

445

What is release/acquire in bind?

494

What is with ur in db2?

489

What are the various data types available in db2?

494

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?

6766




what is the sqlcode -501

10475

What are the contents of dclgen?

495

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

464

What is db2 stogroup?

462

How to execute stored procedure in db2 command editor?

410

What do you mean by commit and rollback?

440

What is scrollable cursor in db2?

427

How to take backup of table in db2?

463

What is the role of schema in the db2 database?

494

Is db2 relational database?

432

For More Un-Answered { DB2 } Questions Click Here