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 find the maximum value in a column in db2?
What is copy pending status in db2?
What is clone table?
What is the use of value function?
What is database alias db2?
Which component is used to execute the sql statements?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is an instance in db2?
What does db2 mean?
How will you return the number of records in table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Name the lockable units in DB2?
Comment whether the cursor is closed during commit or not.
What is null indicator in db2?
What is sqlca’s maximum length?
