Question

db2 sql查询出错

select
V1.EMPLOYEEID,
V1.PROGRAMCODE,
V1.COURSEKEYTYPE,
V1.COURSETYPE,
V1.COURSETYPENAME,
V1.COMPL,
V1.ACTUALHOUR,
V1.COLOURSTATUS,
1,
'',
'',
CURRENT TIMESTAMP,
CURRENT TIMESTAMP

from V_LEARNINGCOMPLANDCOLOUR v1 WHERE V1.EMPLOYEEID IN (SELECT EMPLOYEEID FROM T_EMPLOYEES WHERE ID =3024)

报 Routine "SYSFUN.DOUBLE" (specific name "CHARTODOUBLE") has returned an error SQLSTATE with diagnostic text "SYSFUN:11".. SQLCODE=-443, SQLSTATE=38552, DRIVER=4.12.56 SQL Code: -443, SQL State: 38552 错误

雪地里跪求大神解决， 在线等..急。。。！！

Answer 1

V1.EMPLOYEEID 的数据类型和T_EMPLOYEES的EMPLOYEEID的数据类型一致么？
看报错，好像是折两个的数据类型不同，一个是double一个是char的。