How can tablespace be moved to another dasd volume that is allocated for that tablespace?
No Answer is Posted For this Question
Be the First to Post Answer
What is lock escalation?
What is the role of schema in the db2 database?
What is a root page?
How to find schema of a table in db2?
List some fields from sqlca?
Explain the use of the WHERE clause?
What is explain in db2?
What is a page?
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 Utility is used to migrate DB2 from one release to the next?
can i code union in cobol-db2 pgm ?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,