Answer Posted / kp

Synonym is private to the user who has defined the Synonym
and also the synonym cannnot refer to a remote table

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2070

---

What is page size in db2?

978

---

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

2947

---

What is the use of dclgen in db2?

1085

---

What is load utility in db2?

1181

---

What is the syntax for FETCH in DB2 ?

1216

---

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

4317

---

What are the different types of base tables?

1097

---

How to test SQL -911 error while developing COB-DB2 program

7576

---

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

1049

---

What is cloudant database?

1101

---

What is image copy in db2?

1021

---

What is the use of runstats in db2?

1112

---

What is cursor with hold option in db2?

1075

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

---