Can you access the DB2 Directory table using SQL?
Answers were Sorted based on User's Feedback
Answer / s
No, However you can display the information using DISPLAY
Command.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / sachin borase
you can access the BSDS dataset from the db2 directory.
but other information cannot
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prasad botu
no user cant access data in db2 directory by sql but it db2
can access it for its internal purpose...
| Is This Answer Correct ? | 3 Yes | 1 No |
What is meant by index cardinality?
What is index cardinality?
What does the CHECK Utility do ?
How does DB2 determine what lock-size to use?
What is CHECK PENDING ?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What are the various locks available?
What happens to a cursor after a commit?
How to fetch the last row from the table in SQL (db2)?
What is an alias?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?