What is explain in db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

How to run db2 command in windows?

0 Answers  


What is syscat in db2?

0 Answers  


How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,


What is a correlated sub query?

2 Answers  


What is explain plan in db2?

0 Answers  






What is image copy?

1 Answers   Virtusa,


What is a result table?

1 Answers  


What is the use of predicate?

0 Answers  


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.

1 Answers  


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  


Explain various types of locks in db2?

0 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


Categories