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 6028

what is a trigger and types of triggers

HSBC,

3 7880

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 5778

what is rebinding ?

IBM,

1 5360

what is the use of bind parameter, Replace?

IBM,

5 9222

difference between group clause and order clause

 1 4657

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

 1 3700

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

Syntel,

1 5115

what is different three logs in DB2?

Syntel,

1 5169

what is difference between random and sequence file access

Syntel,

1 4435

How do you run JCL in cobol program

IBM, Syntel,

1 5002

what is difference between Plan and Package

Syntel,

1 5398

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 9469

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

Hewitt,

1 5266

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

 3 44124

Post New DB2 Questions

Un-Answered Questions { DB2 }

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

684

How can you do the explain of a dynamic sql statement?

732

Is it possible to create an Instance in DB2 using DB2 Control Center ?

725

Explain how can you do the explain of a dynamic sql statement?

762

What is rct?

861




Can we insert update delete in view?

675

What are packages in db2?

697

What are the rules for db2 programming?

742

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

861

What is ibm db2 connect?

660

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

2524

What is the difference between cursor and select statement?

729

What is a bind in db2?

692

What do you mean by between and in? Is between inclusive of specified range values?

779

B37 abend during spufi?

1101

For More Un-Answered { DB2 } Questions Click Here