Github user DaveBirdsall commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/1350#discussion_r157637887 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc --- @@ -213,6 +213,24 @@ corresponding week of the year. See the individual entry for the function. +[[lob_functions]] +== LOB Functions + +Trafodion provides following LOB functions to process LOB data. + +[cols="25%,75%"] +|=== +| <<emptyblob_function,EMPTY_BLOB() Function>> | Creates a dummy LOB handle with BLOB. +| <<emptyclob_function,EMPTY_CLOB() Function>> | Creates a dummy LOB handle with CLOB. +| <<stringtolob_function,STRINGTOLOB Function>> | Converts a simple string literal into LOB format. +| <<filetolob_function,FILETOLOB Function>> | Converts data from a local linux/hdfs file into LOB format. +| <<buffertolob_function,BUFFERTOLOB_Function>> | Takes an address and a size of an input buffer, and converts the data pointed to by that buffer into LOB format. +| <<externaltolob_function,EXTERNALTOLOB_Function>> | Converts data from an external file into LOB format. +| LOBTOSTRING | Converts LOB data into simple string literal. --- End diff -- I would say, "Converts LOB data into a simple string literal."
---