Answer / ganesh

select row_number()over() from table_name

Answer / sasidharreddy

by using inspect

what is SPUFI ?

2 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What happens to a cursor after a commit?

3 Answers  

---

What is the role of the data page in the db2 database?

0 Answers  

---

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.

0 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

What is a DB2 access path?

1 Answers  

---

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

0 Answers   MCN Solutions,

---

Name some fields from SQLCA.

2 Answers  

---

What does DSNDB07 database do?

2 Answers  

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---