Answer Posted / naresh k

select * from table_name;
The above qurey get duplicate record also because the
database store records like multi-set..
if we want get distinct records then use following query.
select distinct(attribute_name) from table name

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2697

---

Why do we need reorg in db2?

966

---

What db2 400?

1143

---

Describe major components of db2?

1082

---

What is the meaning concurrency in the db2 database?

1093

---

Give a brief description of db2 isolation levels?

1046

---

What os does db2 run on?

955

---

What are the various data types available in db2?

1071

---

What is dclgen (declaration generator)?

1032

---

What is the max length of sqlca?

1206

---

Define declaration generator (dclgen).

1097

---

What do you mean by commit and rollback?

1025

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

1083

---

What are foreign keys in db2?

1082

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1064

---