BLOB, CLOB, DBCLOB, and XML considerations

Fields of large object data types (BLOB, CLOB, or DBCLOB), or fields of the XML data type cannot be directly accessed from an open query file. Also, they are not allowed on some parameters of the Open Query File (OPNQRYF) command.

Fields that contain any of the large object data types (BLOB, CLOB, or DBCLOB) or the XML data type can only be read by using the Copy From Query File (CPYFRMQRYF) command or SQL. The CPYFRMQRYF command must be used to access large object fields from an open query file. A field of data type BLOB, CLOB, DBCLOB, or XML cannot be specified on these OPNQRYF parameters: KEYFLD, UNIQUEKEY, JFLD, and GRPFLD. An XML field cannot be specified on the MAPFLD parameter.