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 do you mean by commit and rollback?
Explain about rct in db2?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
How to create db2 table in mainframe?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Suppose if I need to update a column, how you do that using cursor?
What is dbrm? When it will be created?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Which components manage deadlocks in db2?