What is Call attach facility? How does it work?

1 Answers   Syntel,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

What is the purpose of the DSNC transaction ?

1 Answers  

---

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

How to check last update on table in db2?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is a db2 tablespace?

0 Answers  

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

---