你测试一下,把语句改成这个样子:
SELECT KANJI_FULL_NAME_KNJ
FROM V_SYSTM_CSRM_ASOF
WHERE FUNCTION_CODE_DESC_ENG='MKT'
AND BUSSINES_SEGMENT_GRP_CD BETWEEN '1' AND '4'
;执行一下看看有没有问题
Cause :In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.
Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.
SQL文如下:
SELECT RM_CD, KANJI_FULL_NAME_KNJ
FROM V_SYSTM_CSRM_ASOF
WHERE FUNCTION_CODE_DESC_ENG='MKT'
AND BUSSINES_SEGMENT_GRP_CD BETWEEN '1' AND '4'
ORDER BY RM_CD ASC