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 |
Are views updateable?
What are db2 objects?
Define predicate?
Why db2 is called db2?
What are catalog tables in db2?
i want to delete 20th million record how ?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the syntax required for the creation of a cursor?
What are packages in db2?
What is blu acceleration in db2?
What do you mean by commit and rollback?
What is the database descriptor?