Answer Posted / yogendra shinde

Hi,

Alias and Synonym both are alternative names to a table
name. But the major difference between Alias and Synonym is
that
>>>Alias can be used to refer a table at different location
( meaning different or remote system and it is not provate
to user who has created it)

>>> Synonym is used to refer table in the same location
with different name. Synonym is very much provate to the
user who has created it.

>>> Regarding dropping ALIAS and SYNONYM I am doubtful.
I have read that if we drop base table or base view then
both alias and synonym are also dropped (As per C.J.DATE
DB2 version 4.0). Please update if anybody has more on this.

What is image copy in db2?

993

---

define clustering index.

1010

---

What is a trigger in the db2 database?

1059

---

What is dclgen (declaration generator)?

1036

---

What is bind and rebind in db2?

1124

---

How to restart a DB2 program?

1879

---

What is reorg?

1133

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1402

---

What is load replace in db2?

981

---

Explain package in db2 and its advantages?

1190

---

Mention the different locking levels that are available in db2.

1117

---

Explain about mirror activator disk mirroring?

992

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3188

---

List down the data types in the db2 database.

1098

---

Explain about rct in db2?

1091

---