Answer Posted / sadiq afroze
An application plan or package is generated by the bind to
define an access path
| Is This Answer Correct ? | 64 Yes | 14 No |
Post New Answer View All Answers
What is dbrm?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Mention the location where the output received from explain statement is stored.
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 .....
How would you find out the total number of rows in a db2 table?
What is dbrm? What it contains?
Which isolation level provides highest data integrity?
What is a trigger in the db2 database?
Explain correlated sub-queries.
What is null value in db2?
How to get the ddl of a table in db2?
When the like statement is used?
What is the max length of sqlca?
What are the 2 sqlcodes that are returned?
What is the role of the data page in the db2 database?