Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
2 4892i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
3 6849
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
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 .....
Explain the function done by data manager?
What is runstats db2?
How can record locking be achieved in those DB2 versions which do not support it?
How many databases can be created inside an instance in db2 ?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What are the full forms of spufi and dclgen and why are they used?
How many types of page locks can be held in db2?
Explain the contents that are a part of dclgen.
What is an instance database?
What is db2 instance?
B37 abend during spufi?
How can you do the explain of a dynamic sql statement?