Repository: incubator-trafodion Updated Branches: refs/heads/master c235e6142 -> a434be0ac
Add a Note for EMPTY_BLOB() and EMPTY_CLOB() Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/083fcb02 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/083fcb02 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/083fcb02 Branch: refs/heads/master Commit: 083fcb020e53ec0fb4e198059a866c34831e62e3 Parents: 52df383 Author: liu.yu <[email protected]> Authored: Mon Dec 18 16:08:57 2017 +0800 Committer: liu.yu <[email protected]> Committed: Mon Dec 18 16:08:57 2017 +0800 ---------------------------------------------------------------------- docs/lob_guide/src/asciidoc/_chapters/working_with_lob.adoc | 2 ++ 1 file changed, 2 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/083fcb02/docs/lob_guide/src/asciidoc/_chapters/working_with_lob.adoc ---------------------------------------------------------------------- diff --git a/docs/lob_guide/src/asciidoc/_chapters/working_with_lob.adoc b/docs/lob_guide/src/asciidoc/_chapters/working_with_lob.adoc index 783c9b6..c05d670 100644 --- a/docs/lob_guide/src/asciidoc/_chapters/working_with_lob.adoc +++ b/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. ** If `EMPTY_BLOB()` or `EMPTY_CLOB()` is specified, then a dummy lob handle is created.
