代码:
select tranwrd(trim(memname)," ","_") as setname, name as vname,
(select max(length(trim(name))) from templb.lossdata) as len
from dictionary.columns
where libname= "TEMPLB" and type = "char";
目的: 查询lossdata表中各字符列值的实际最大长度。
问题:subquery 返回错误值。以列LOSS_REASON为例:subquery返回值是11, 而将subquery硬编码成select max(length(trim(LOSS_REASON))) from templb.lossdata则返回3。
请各位指点错在哪里。多谢。