Interested to Buy Any Domain ? << Click Here >> for more details...
What are foreign keys in db2?
- 0 Answers
- 1108 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can we insert update delete in view?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a db2 tablespace?
how can you access index
What is innodb buffer pool?
explain about index with examples
What is pagespace?
What is cloudant database?
What is meant by concurrency?
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.
How will fetch last 5 rows from table in db2
COBOL 
