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
3669 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

Mention the different locking levels that are available in db2.

1140

Is it possible using max on a char column?

1146

What is the use of reorg in db2?

1089

Give the name of some fields form sqlca.

1092

What is the role of union all and union

1132

Define declaration generator (dclgen).

1123

define clustering index.

1036

What happens in bind step in a db2 program?

978

How do I delete a table in db2?

1088

Explain about mirror activator disk mirroring?

1018

What is plan in cobol db2?

1146

i want to maintain uniqueness on pdf without make lf??????????

2160

What is dclgen in db2?

1156

List some fields from sqlca?

1065

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1278