[ https://issues.apache.org/jira/browse/TRAFODION-2849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16295935#comment-16295935 ]
ASF GitHub Bot commented on TRAFODION-2849: ------------------------------------------- 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." > Add BLOB and CLOB for *Trafodion SQL Reference Manual* > ------------------------------------------------------ > > Key: TRAFODION-2849 > URL: https://issues.apache.org/jira/browse/TRAFODION-2849 > Project: Apache Trafodion > Issue Type: Documentation > Reporter: Liu Yu > Assignee: Liu Yu > -- This message was sent by Atlassian JIRA (v6.4.14#64029)