Answer Posted / magesh

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

What is cursor with hold option in db2?

1138

---

What is db2 optimizer?

1313

---

How can you quickly find out the # of rows updated after an update statement?

1086

---

What is a bind card?

1278

---

What is db2 look?

1077

---

Which component is responsible for processing sql statements and selecting access paths?

1178

---

Which components manage deadlocks in db2?

1124

---

Define sqlca.

1172

---

What is bufferpool in db2?

1097

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372

---

Define db2.

1172

---

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2595

---

Can we update view in db2?

1054

---

What is cursor in dbms?

1113

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788

---