Interested to Buy Any Domain ? << Click Here >> for more details...
Can you access the DB2 Directory table using SQL?
- 3 Answers
- 7762 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 |
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
List down the data types in the db2 database.
how do u update the faltfile into db2 table ?
can we update the table by using cursors can anyone post the query?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
what types of copies can be made with the COPY Utility ?
how we will do null data selection in cobol-db2 program
What are iseries servers?
What is dclgen in db2?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
can we view the access paths created by dbrm ? how ? thx
COBOL 
