Interested to Buy Any Domain ? << Click Here >> for more details...
When will you chose to run RUNSTATS?
- 1 Answers
- 9410 Views
- I also Faced
- E-Mail Answers
Answer / deepak dada
is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base
| Is This Answer Correct ? | 4 Yes | 4 No |
How many databases can be created inside an instance in db2 ?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Can you tell me how can you find out the # of rows updated after an update statement?
how to get duplicate records from tables?write qurey for this?
how to take the back up of the DB2 table.
what is different three logs in DB2?
What is a DBRM, PLAN ?
Define db2.
How does the processing of a correlated subquery differ from a non correlated subquery?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
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.
COBOL 
