Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1354#discussion_r158074821
--- Diff: docs/lob_guide/src/asciidoc/_chapters/working_with_lob.adoc ---
@@ -235,6 +235,8 @@ The source for inserting into a LOB can be any of the
following:
An unnamed parameter can be used to prepare a statement and then during an
execution, either a function or a simple string parameter can be passed in
which will be converted to LOB data.
* `EMPTY_BLOB()` or `EMPTY_CLOB()`
++
+NOTE: If you want to insert `EMPTY_BLOB()` or `EMPTY_CLOB()` into a lob
column, the CQD `TRAF_CLOB_AS_VARCHAR` which is *ON* by default must be turned
*OFF* before creating the table.
--- End diff --
Oops... I meant to say, "The CQD must be 'OFF' at the time the table with
the BLOB / CLOB column is created. (Otherwise the table is created with a
VARCHAR.)" Apologies.
My fault for typing that comment quickly before rushing off to an
appointment.
---
