Q4. How will you get the count of record without using COUNT verb in query?
Answer Posted / sasidharreddy
by using inspect
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are types of indexes?
What is host variable?
What is a db2 collection?
Define sqlca.
Mention the different locking levels that are available in db2.
is it compulsory commitment control in journal?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is db2 bind process?
What is the usage of open cursor command?
How can you find out the # of rows updated after an update statement?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is a plan and package in db2?
Explain in detail about buffer manager and its functionalities?
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
What is check constraint. Explain with example.