isnull => DB2 COALESCE
strcat = > || 로 묶기
MySQL:
— Convert the current date to YYYYMM format
SELECT DATE_FORMAT(NOW(), ‘%Y%m’);
DB2:
— Convert the current date to YYYYMM format
SELECT VARCHAR_FORMAT(CURRENT_DATE, ‘YYYYMM’) FROM sysibm.sysdummy1;
