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 RUNSTATS?
List some fields from sqlca?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
what is SMP/E? and what are the major steps of it? thanks...
How to insert more than one record using insert?
What are the various isolation levels possible?
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.
How to resolve -407 sql code in DB2?
What is difference between isnull and coalesce?
What is the picture clause of null indicator variable?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
Can any one tell me about Restart logic in DB2.