Interested to Buy Any Domain ? << Click Here >> for more details...
Can you access the DB2 Directory table using SQL?
- 3 Answers
- 7634 Views
- I also Faced
- E-Mail Answers
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 |
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
what is differnece between DROP TABLE & DELETE TABLE .
is it possible to get -811 error when you use cursors. why?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What is a db2 collection?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How can record locking be achieved in those DB2 versions which do not support it?
What is db2 catalog database?
Name some fields from SQLCA
What is the use of value function?
COBOL 
