Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 6852

what is a trigger and types of triggers

HSBC,

3 8995

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 6444

what is rebinding ?

IBM,

1 5821

what is the use of bind parameter, Replace?

IBM,

5 10568

difference between group clause and order clause

 1 5145

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

 1 4158

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

Syntel,

1 5691

what is different three logs in DB2?

Syntel,

1 5675

what is difference between random and sequence file access

Syntel,

1 5052

How do you run JCL in cobol program

IBM, Syntel,

1 5554

what is difference between Plan and Package

Syntel,

1 6028

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 10696

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

Hewitt,

1 5781

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

 3 46061

Post New DB2 Questions

Un-Answered Questions { DB2 }

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2324

What is copy pending and check pending in db2?

967

How do I create a view in db2?

982

How do you pull up a query which was previously saved in qmf?

1114

What is rebind in db2?

1014

Is it possible using max on a char column?

1098

What is difference between rollback and commit?

1111

What is universal database?

1040

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1022

B37 abend during spufi?

1418

What is the use of db2 optimizer?

1067

What action db2 takes when a program aborts in the middle of a transaction?

1113

What are the benefits of using the db2 database?

1172

Explain the contents that are a part of dclgen.

1048

What is db2 connect?

1019

For More Un-Answered { DB2 } Questions Click Here