Answer Posted / ramana99

select City, Country, count('X') from Customers
group by City, Country
HAVING count('X') > 1
;

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1801

---

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 .....

1897

---

What is release/acquire in bind?

654

---

What's The Error Code For Unique Index Voilation?

648

---

What is query_cache_limit?

541

---

---

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

2375

---

Can one database have multiple instances?

579

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

698

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3788

---

What does db2 stand for?

596

---

Is it possible using max on a char column?

603

---

List down the types of triggers in the db2 database?

588

---

How can you find out the # of rows updated after an update statement?

637

---

Explain about dbrm.

607

---

What is cloudant database?

641

---