What is the difference between plan and package in db2?
No Answer is Posted For this Question
Be the First to Post Answer
How can deadlocks be resolved?
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 are the 4 environments which can access DB2 ?
what is datacom db?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
what is plan? is plan executable or package?
Mention the downsides of page level lock.
What does runstats do in db2?
what is SMP/E? and what are the major steps of it? thanks...
What is a clustered index?
Describe what a storage group(STOGROUP) is?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,