Answer / s

SELECT count(*) from SYSIBM.SYSTABLES
WHERE CREATOR = 'OWNER' ;

Answer / satish

select count(*) from sysibm.systables where creator='owner'

select * from sysibm.systables

What is a LIKE table and how is it created?

2 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

What is buffer pool and list some of them?

0 Answers  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

What is ibm db2 used for?

0 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---