What is query_cache_limit?
What is runstats and reorg in db2?
what is the difference between normal select query and currosor
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Can you use max on a char column?
how to execute qcmdexc in rpgle?plz write code also?
What is a bind card?
How to insert more than one record using insert?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What does db2 plan contain?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is data manager?
Explain in brief how does db2 determine what lock-size to use?