Answer Posted / abirami

select max(salary) from tablename
fetch first 10 rows only

What is coalesce in db2?

1127

---

Explain various types of locks in db2?

1136

---

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

1107

---

What are catalog tables in db2?

1044

---

What does runstats do in db2?

1099

---

Explain about open switch business continuity software?

1124

---

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?

2526

---

How do I add a column in db2?

1043

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1100

---

What do you mean by between and in? Is between inclusive of specified range values?

1088

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2176

---

Mention the downsides of page level lock.

1159

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1185

---

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 ?...

4297

---

How to view db2 table structure?

1011

---