- 论坛徽章:
- 0
|
hi all,
我在用golang调用db2cli 执行如下SQL总是失败,说是非法字符,大家看看我这SQL语法没有问题吧?
SELECT DATADATE,DATATIME,
(CASE
WHEN CICS_SYSTEM_ID like 'AAA%%' THEN 'BAN'
WHEN CICS_SYSTEM_ID like 'BBB%%' THEN 'ACS'
WHEN CICS_SYSTEM_ID in ('CCC','DDD') THEN 'BCC'
ELSE 'OTHER' END) as WRKID,CICS_SYSTEM_ID,TPS
FROM
(SELECT CICS_SYSTEM_ID,CHAR(DATE) AS DATADATE,CHAR(TIME) AS DATATIME,DEC(SUM(TRANSACTION_COUNT)/300,10,2) AS TPS FROM DRL.T_APP_CICS_5MKPI WHERE DATADATE BETWEEN '20151201' AND '20151202' GROUP BY DATADATE,DATATIME,CICS_SYSTEM_ID) |
|