trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [5/7] incubator-trafodion git commit: Incorporate Comments 1
Date Wed, 20 Dec 2017 21:19:02 GMT
Incorporate Comments 1


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/2a48db2f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/2a48db2f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/2a48db2f

Branch: refs/heads/master
Commit: 2a48db2fa583be25b0f8b39c18fe8de07a51a81d
Parents: 551dc30
Author: liu.yu <yu.liu@esgyn.cn>
Authored: Tue Dec 19 14:53:43 2017 +0800
Committer: liu.yu <yu.liu@esgyn.cn>
Committed: Tue Dec 19 14:53:43 2017 +0800

----------------------------------------------------------------------
 .../sql_functions_and_expressions.adoc          | 32 ++++++++++----------
 .../_chapters/sql_language_elements.adoc        |  2 +-
 2 files changed, 17 insertions(+), 17 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/2a48db2f/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
index 8c18fb7..733256f 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
@@ -220,13 +220,13 @@ 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.
+| <<emptyblob_function,EMPTY_BLOB() Function>>   | Creates a dummy LOB handle
of type BLOB.
+| <<emptyclob_function,EMPTY_CLOB() Function>>   | Creates a dummy LOB handle
of type 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.
+| <<buffertolob_function,BUFFERTOLOB_Function>>     | Takes the address and size
of an input buffer, and converts the contents of 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.
+| LOBTOSTRING                     | Converts LOB data into a simple string literal.
 | LOBTOFILE                       | Converts LOB data into a linux/hdfs file.
 | LOBTOBUFFER                     | Converts LOB data into a buffer.
 |===
@@ -951,7 +951,7 @@ The following are BITAND restrictions:
 [[buffertolob_function_syntax]]
 === Syntax Descriptions of BUFFERTOLOB Function
 
-The BUFFERTOLOB function takes an address and a size of an input buffer, and converts the
data pointed to by that buffer into LOB. This function can be used in INSERT or UPDATE statement.
+The BUFFERTOLOB function takes the address and size of an input buffer, and converts the
contents of that buffer into LOB. This function can be used in an INSERT or UPDATE statement.
 
 BUFFERTOLOB function is a Trafodion SQL extension.
 
@@ -963,11 +963,11 @@ BUFFERTOLOB(LOCATION lob source buffer address, LENGTH lob length value)
 
 * _lob source buffer address_
 +
-The long value of the user buffer address in int64.
+The int64 value of the user buffer address.
 
 * _lob length value_
 +
-The length of the user specified lob buffer in int64.
+The int64 value of the user specified lob buffer.
                  
 [[buffertolob_function_examples]]
 === Examples of BUFFERTOLOB Function
@@ -3468,9 +3468,9 @@ DIFF2_I1TS
 [[syntax_descriptions_of_emptyblob_function]]
 === Syntax Descriptions of EMPTY_BLOB() Function
 
-The EMPTY_BLOB() function creates a dummy LOB handle with BLOB.
+The EMPTY_BLOB() function creates a dummy LOB handle of type BLOB.
 
-This function can be used in INSERT or UPDATE statement, to initialize a LOB column or attribute
to EMPTY.
+This function can be used in an INSERT or UPDATE statement, to initialize a LOB column or
attribute to EMPTY.
 
 EMPTY_BLOB() function is a Trafodion SQL extension.
 
@@ -3485,7 +3485,7 @@ EMPTY_BLOB()
 
 * If EMPTY_BLOB() is specified, then a dummy lob handle is created.
 
-** No data is associated with the empty LOBs yet, but these dummy LOB handles can later be
used to populate with new LOB data. If the LOB had data previously associated with it, it
will be erased.
+** No data is associated with the empty LOBs yet, but these dummy LOB handles can later be
used to populate the LOB with new data. If the LOB had data previously associated with it,
it will be erased.
 
 ** The dummy LOB handle will get the same datatype as the underlying column.
 +
@@ -3509,9 +3509,9 @@ insert into test1 values (1, empty_blob());
 [[syntax_descriptions_of_emptyclob_function]]
 === Syntax Descriptions of EMPTY_CLOB() Function
 
-The EMPTY_CLOB() function creates a dummy LOB handle with CLOB.
+The EMPTY_CLOB() function creates a dummy LOB handle of type CLOB.
 
-This function can be used in INSERT or UPDATE statement, to initialize a LOB column or attribute
to EMPTY.
+This function can be used in an INSERT or UPDATE statement, to initialize a LOB column or
attribute to EMPTY.
 
 EMPTY_CLOB() function is a Trafodion SQL extension.
 
@@ -3526,7 +3526,7 @@ EMPTY_CLOB()
 
 * If EMPTY_CLOB() is specified, then a dummy lob handle is created.
 
-** No data is associated with the empty LOBs yet, but these dummy LOB handles can later be
used to populate with new LOB data. If the LOB had data previously associated with it, it
will be erased.
+** No data is associated with the empty LOBs yet, but these dummy LOB handles can later be
used to populate the LOB with new data. If the LOB had data previously associated with it,
it will be erased.
 
 ** The dummy LOB handle will get the same datatype as the underlying column.
 +
@@ -3783,7 +3783,7 @@ then selects the desired columns.
 [[externaltolob_function_syntax]]
 === Syntax Descriptions of EXTERNALTOLOB Function
 
-The EXTERNALTOLOB function converts data from an external file into LOB format. This function
can be used in INSERT or UPDATE statement.          
+The EXTERNALTOLOB function converts data from an external file into LOB format. This function
can be used in an INSERT or UPDATE statement.          
 
 EXTERNALTOLOB function is a Trafodion SQL extension.
 
@@ -3870,7 +3870,7 @@ The result is 1.
 [[filetolob_function_syntax]]
 === Syntax Descriptions of FILETOLOB Function
 
-The FILETOLOB function converts data from a local linux/hdfs file into LOB format. This function
can be used in INSERT or UPDATE statement.          
+The FILETOLOB function converts data from a local linux/hdfs file into LOB format. This function
can be used in an INSERT or UPDATE statement.          
 
 FILETOLOB function is a Trafodion SQL extension.
 
@@ -7411,7 +7411,7 @@ SELECT STDDEV (price * qty_available) FROM sales.parts;
 [[stringtolob_function_syntax]]
 === Syntax Descriptions of STRINGTOLOB Function
 
-The STRINGTOLOB function converts a simple string literal into LOB format. This function
can be used in INSERT or UPDATE statement.
+The STRINGTOLOB function converts a simple string literal into LOB format. This function
can be used in an INSERT or UPDATE statement.
 
 STRINGTOLOB function is a Trafodion SQL extension.
 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/2a48db2f/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
index 3261020..2704107 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
@@ -370,7 +370,7 @@ FRACTION(n) 0-999999 +
 in which n is the number of significant digits (default is 6; minimum is 1; maximum is 6);
+
 stored in 2, 4, or 8 bytes depending on number of digits^2^
 .2+| LOB Data Types .2+| LOB | BLOB | Binary Large Object .2+| 10G – no limit + 
-Currently it sets to 10G (default) and it’s controlled by the `CQD LOB_MAX_SIZE`, the size
can be changed depending on your needs.
+Currently the limit defaults to 10G. This limit can be configured as needed using the CQD
`LOB_MAX_SIZE`.
 | CLOB | Character Large Object 
 .10+| Numeric Data Types .5+| Numeric | NUMERIC (1,_scale_) to + NUMERIC (128,_scale_) |
Binary number with optional scale; signed or unsigned for 1 to 9 digits
 | 1 to 128 digits; +


Mime
View raw message