How Plan is created while executing the query using SPUFI?
Answer Posted / mangesh
No Plan is get created while executing the query using
SPUFI. SPUFI , QMF are only tools to check the correctness
of your query , i.e where ur query is correct or u have
coded anythig wrong .
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
What is the physical storage length of date data type?
Mention the definition of cobol in varchar field.
What os does db2 run on?
What's The Percentage Free Space ?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
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.
What is database manager in db2?
What is buffer pool?
What is sqlca?
What is a bind card?
Before you give the explain statement, what are the prerogatives?
How many databases are there?
Explain the function done by data manager?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is buffer pool in the db2 database?