FM大数据处理（cast string as varchar）出错。

xiaoerp

fm里 ，递归查询从clob里拿出USER_KEY放到TMP临时表里，然后和BLOGS_USER表一起做个查询。
因为USER_KEY是string，用cast转为varchar：

• SELECT CAST (USER_KEY  AS VARCHAR(64)) USER_KEY,  DISPLAY_NAME
• FROM TMP, BLOGS_USER
• WHERE CAST (USER_KEY  AS VARCHAR(64))=USER_GUID
  

复制代码
出现如下error：

• This query contains an error and can not be executed.
• It is recommended that you view the query feedback on the "Query Information" tab.
• RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-232'.
• UDA-SQL-0175 The operation "fetch" has been cancelled.
• [IBM][CLI Driver][DB2/LINUXX8664] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014
• UDA-CUR-0000 Unable to fetch the row.
  

复制代码
补充：在本地db2里测试通过。
找到设置timeout的地方了。
在导数据的时候设置的。
默认应该是0啊