Answer Posted / as
I know a senario in which views are created.
Suppose I have a field in my table which is secure and
should not be visible to everyone. In that case i can
create a view without that field and keep the table acces
(even browse) with a particular set of people.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain package in db2 and its advantages?
What is the maximum length of sqlca?
How to create backup table in db2?
What do you mean by rollback?
what is diffrence b/w file-aid tool and file-aid utility???
What is precompiler in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Explain the contents that are a part of dclgen.
What are foreign keys in db2?
Can we delete records from view?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is coalesce in db2?
Is ibm db2 free?
What is drop table?