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.

Is db2 a database?

0 Answers  

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

Define check constraint.

0 Answers  

---

what's the error code for Unique Index Violation?

2 Answers  

---

What is buffer pool?

0 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

what is the difference between join and union?

4 Answers   IBM,

---

What is sqlcode -922 ?

2 Answers  

---

cobol-db2 runjcl please?

2 Answers   DELL,

---