Answer Posted / magesh

delete from (select row_number() over() as COLUMN1 from
TABLE_OWNER.TABLE_NAME )
where COLUMN1=20000000;

What is drop table?

1012

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2070

---

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.

2727

---

What is query_cache_limit?

971

---

What is the max length of sqlca?

1216

---

What are the contents of a dclmgen?

1131

---

How is the value function used?

1157

---

What is bind plan?

1049

---

What is a db2 package?

1060

---

What is dbrm? When it will be created?

1029

---

Define predicate?

1139

---

What is copy pending and check pending in db2?

1005

---

How would the varchar column remarks defined?

1090

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1273

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1105

---