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
what is utility for parm lib
How to test SQL -911 error while developing COB-DB2 program
How to create db2 table in mainframe?
What is cursor with hold option in db2?
How do I optimize a query in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is dbrm? What it contains? When it will be created?
How can record locking be achieved in those DB2 versions which do not support it?
What is dclgen (declaration generator)?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What are the 2 sqlcodes that are returned?
What action db2 takes when a program aborts in the middle of a transaction?
Highlight all the advantages that are attached to a package.
When the like statement is used?
What is db2 catalog database?