Answer / s

CREATE TABLE AAA
LIKE TABLE BBB;

Answer / nag(igate)

the like will create the same table structure and it will
not copy data from existing table.

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

---

is there any restrictions for unions ?

4 Answers   Patni,

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

What is copy book?

1 Answers   Thomson Reuters,

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

What os does db2 run on?

0 Answers  

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

What is a recovery log?

1 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---