Answer Posted / sandeep kumar

insert into tablename(col1, col2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
....................
....................

What is the role of union all and union

1119

---

Explain package in db2 and its advantages?

1201

---

List out the buffer pools in db2

1069

---

What are the rules for db2 programming?

1081

---

What happens in bind step in a db2 program?

964

---

What is a storage group (stogroup)?

1241

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

1071

---

What is deadlock in db2?

1062

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2082

---

Explain in brief how does db2 determine what lock-size to use?

1034

---

How can the duplicate values be eliminated from db2 select?

1097

---

can all users have the privilage to use the sql statement select * (dml)?

1160

---

Can you tell me how can you find out the # of rows updated after an update statement?

1095

---

How to get the ddl of a table in db2?

1125

---

What is the default page size of buffer pools?

1120

---