What is a view? Why use it?
- 3 Answers
- 5058 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aditya
view is used to create another representation of data where
we can protect the important data from public view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / purushothr
view is a logical table that can be created by one or more
base table
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinivasa yadav
VIEW IS A VIRTUAL MEMEORY SPACE WHICH DOES'NT HOLD ANY DATA.
MAINLY VIEW IS USED TO RESTRICT AUTHORIZATION FOR THE
USERS. SO USER CAN ACCESS ONLY PARTICULAR COLUMNS.
| Is This Answer Correct ? | 0 Yes | 3 No |
Mention some fields that are a part of sqlca.
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What if we fail to give values in columns declared as NOT NULL ?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What are db2 tables?
What is a DBRM, PLAN ?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is sqlcode -922 ?
What is access path in db2?
What are the disadvantages of PAGE level lock?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
COBOL 
