Can All Users Have The Privilege To Use The SQL Statement
Select (DML)?
- 1 Answers
- 3669 Views
- I also Faced
- E-Mail Answers
Answer / s
If the SELECT privilege is granted to PUBLIC, Yes.
Otherwise privilege has to granted explicitly.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between base table and view?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
Why use RUNSTAT Utility?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How are write I/Os from the buffer pool executed?
What is a buffer pool?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is buffer pool in the db2 database?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What is phantom read in db2?
COBOL 
