Answer Posted / ms. stanley
SPUFI = SQL Processing Using File Input
| Is This Answer Correct ? | 30 Yes | 1 No |
Post New Answer View All Answers
What is ibm db2 connect?
What is a buffer in memory?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the use of dclgen in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What does runstats do in db2?
What is the max length of sqlca?
What are the two types of logging in the db2 database? Explain them.
What is the information associated with sysibm.syslinks table?
What is drop table?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Describe major components of db2?
What are the full forms of spufi and dclgen and why are they used?
How can record locking be achieved in those DB2 versions which do not support it?
Define db2 and its databases?