Answer Posted / saloni
QUALIFIER
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is release/acquire in bind?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is cursor with hold option in db2?
Can there be more than one cursor open for any program?
What is bind and rebind in db2?
What are concurrency issues?
What is a storage group (stogroup)?
What is the usage of open cursor command?
What is image copy in db2?
What os does db2 run on?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Which component is used to execute the sql statements?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How would you find out the total number of rows in a db2 table?