SQL 如何从db2中选择CLOB数据类型数据
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13512796/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to select CLOB data type data from db2
提问by user1845010
SELECT CAST (ATTCH_BODY AS CLOB(30720))
INTO :WS-ATTCH-BODY
FROM NBASRDOCUM 05 WS-ATTCH-BODY SQL TYPE IS CLOB(32K).
When I am trying to select clobdata using above query, it shows all zeros (0) in the variable.
当我尝试clob使用上述查询选择数据时，它显示变量中的所有零 (0)。
Please recommend me how to select clobdata type. Actually I've inserted a text file with 2k size from GUI into that variable (ATTCH_BODY). I need to send it back to GUI using XML strings.
请推荐我如何选择clob数据类型。实际上，我已经将一个 2k 大小的文本文件从 GUI 插入到该变量 ( ATTCH_BODY) 中。我需要使用 XML 字符串将其发送回 GUI。
回答by nate_weldon
I have done something like the following.
我做了类似以下的事情。
select cast(CLOBCOLUMN as varchar(32000))
from TABLENAME where cast(TABLENAME.CLOBCOLUMN as
varchar(32000)) like '%AString%' for read only;
