P
Paul Clare
Guest
Hi Geir Otto, this could be because there is invalid character data (e.g. control codes) in the CLOB. COPY-LOB validates the data as real 'character' data. From the COPY-LOB ABL reference: "However, if the target is a LONGCHAR or a CLOB, the AVM validates the character data based on the target object's code page. For a CLOB, this is the code page of the CLOB. For a LONGCHAR, this is -cpinternal unless the LONGCHAR's code page was set using the FIX-CODEPAGE statement. If the validation fails, the AVM raises the ERROR condition." If there are control characters in it then it isn't valid and they need to be removed. See articles 000072678 and 000049137. This might explain why it works when the target is an XML file as the same validation isn't performed? Paul.
Continue reading...
Continue reading...