FYI upward compatibility Db2 12 (vs 11 & 10 &
INSERT INTO TXT1 VALUES ('MATCH','NOMATCH');
INSERT INTO TXT1 VALUES ('MATCH','MATCH');
SELECT CHAR10, CHAR20,
SUBSTR(GETVARIABLE('SYSIBM.VERSION'),1,12) AS DB2VERSION,
CASE WHEN CHAR10 = CHAR20
THEN 'Db2 for z/OS says MATCH'
ELSE 'Db2 for z/OS says NOMATCH'
END AS "COMPARE_FLAG"
We have an open service request, but need to set up a trapping DSNADMSB (ADMIN_INFO_SQL has always been fine according to DSNTIJRT) to proceed.
I'm not an SQL guy (1st time for CASE) & new to DSNADMSB, so this could certainly be user error, but it really looks like CASE now processes equality in a different manner than WHERE.