SELECT COMM_TEXT INTO :WS_MIKM

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.

Question Posted / satish

1 Answers
3635 Views
I also Faced
E-Mail Answers

Answer Posted / satish

SELECT COMM_TEXT
INTO :WS_MIKM_COMM_TEXT
FROM MPIPROD.MIKMV01
WHERE (CASE WHEN (SUBSTR(COMM_TEXT,1,39 = :WS_COMMENT_TEXT)
AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC)) THEN 1
ELSE
(SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) THEN 2
END) IN (1,2)
AND ACCOUNT_NO = :WFD_ACCOUNT_NO

Tell me if i am wrong??

ACCOUNT_NO = :WFD_ACCOUNT_NO
AND CASE
OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to run db2 command in windows?

1175

What is the difference between oracle and db2?

1072

How many types of page locks can be held in db2?

1020

What is db2? Explain.

1014

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2827

What is ibm db2 client?

916

Describe major components of db2?

1082

What is netezza database?

997

Before you give the explain statement, what are the prerogatives?

1010

How does db2 sample database connect?

1010

How to get the ddl of a table in db2?

1114

If I have a view which is a join of two or more tables, can this view be updateable?

1126

Highlight all the advantages that are attached to a package.

1100

Is ibm db2 open source?

1052

What happens in bind step in a db2 program?

956