Can you access the DB2 Directory table using SQL?

Answers were Sorted based on User's Feedback



Can you access the DB2 Directory table using SQL?..

Answer / s

No, However you can display the information using DISPLAY
Command.

Is This Answer Correct ?    6 Yes 3 No

Can you access the DB2 Directory table using SQL?..

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

Can you access the DB2 Directory table using SQL?..

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

Post New Answer

More DB2 Interview Questions

Are views updateable?

0 Answers  


What are db2 objects?

0 Answers  


Define predicate?

0 Answers  


Why db2 is called db2?

0 Answers  


What are catalog tables in db2?

0 Answers  






i want to delete 20th million record how ?

4 Answers   IBM,


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 .....

0 Answers  


What is the syntax required for the creation of a cursor?

1 Answers  


What are packages in db2?

0 Answers  


What is blu acceleration in db2?

0 Answers  


What do you mean by commit and rollback?

0 Answers  


What is the database descriptor?

2 Answers  


Categories