Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / wazid noor mohammed
sometimes u have to write complex queries.
for this query u can give one name.
For to give that name we use view concept.
after defining the view with the particular name to the
complex query.
Next time ,we can execute that query by simply calling the
view name of that query
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How do you pull up a query which was previously saved in qmf?
What is the maximum number of columns in a db2 table?
What is alias in db2?
Name the various locking levels available?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Explain dclgen.
Give a brief description of db2 isolation levels?
What is the difference between cursor and select statement?
What is dclgen in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2 optimizer?
What is dbrm?
What does reorg do in db2?
List out the data types available.
