You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2018/07/10 15:16:42 UTC

[1/5] trafodion git commit: [TRAFODION-3132] Add and Correct Descriptions for *Character String Data Type* in *Trafodion SQL Reference Manual*

Repository: trafodion
Updated Branches:
  refs/heads/master 9f8fc8e84 -> 20f8240e4


[TRAFODION-3132] Add and Correct Descriptions for *Character String Data Type* in *Trafodion SQL Reference Manual*


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

Branch: refs/heads/master
Commit: f72d026a231cbb418bf4334467cff71ba0b5eeb9
Parents: 9e675ff
Author: liu.yu <qw...@hotmail.com>
Authored: Mon Jul 9 17:29:19 2018 +0800
Committer: liu.yu <qw...@hotmail.com>
Committed: Mon Jul 9 17:29:19 2018 +0800

----------------------------------------------------------------------
 .../_chapters/sql_language_elements.adoc        | 47 ++++++++++----------
 1 file changed, 24 insertions(+), 23 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/f72d026a/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 2704107..43b8b9d 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
@@ -325,14 +325,14 @@ The following table summarizes the {project-name} SQL data types:
 [cols="14%,14%,24%,24%,24%",options="header"]
 |===
 | Category | Type | SQL Designation | Description | Size or Range^1^
-.8+| Character String Data Type .3+| Fixed-length character | CHAR[ACTER]          | Fixed-length character data            | 1 to 200000 characters^2^ ^8^
-| NCHAR                | Fixed-length character data in predefined national character set | 1 to 200000 bytes^3^ ^7^ ^9^
-| NATIONAL CHAR[ACTER] | Fixed-length character data in predefined national character set | 1 to 200000 bytes^3^ ^7^ ^9^
-.5+| Variable-length character | VARCHAR                      | Variable-length ASCII character string | 1 to 200000 characters^4^ ^8^
-| VARCHAR2                     | Variable-length ASCII character string | 1 to 200000 characters^4^ ^8^
-| CHAR[ACTER] VARYING          | Variable-length ASCII character string | 1 to 200000 characters^4^ ^8^
-| NCHAR VARYING                | Variable-length ASCII character string | 1 to 200000 bytes^4^ ^7^ ^9^
-| NATIONAL CHAR[ACTER] VARYING | Variable-length ASCII character string | 1 to 200000 characters^4^ ^7^ ^8^
+.8+| Character String Data Type .3+| Fixed-length character | CHAR[ACTER]          | Fixed-length character data            | 1 to 16,777,216 bytes ^6^
+| NCHAR                | Fixed-length character data in predefined national character set | 1 to 16,777,216 bytes^2^ ^5^ ^7^
+| NATIONAL CHAR[ACTER] | Fixed-length character data in predefined national character set | 1 to 16,777,216 bytes^2^ ^5^ ^7^
+.5+| Variable-length character | VARCHAR                      | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^6^
+| VARCHAR2                     | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^6^
+| CHAR[ACTER] VARYING          | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^6^
+| NCHAR VARYING                | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^5^ ^7^
+| NATIONAL CHAR[ACTER] VARYING | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^5^ ^7^
 .6+| Datetime Data Types .6+| Date-Time | | Point in time, using the Gregorian calendar and a 24 hour clock system. The five supported designations are listed below.
 | YEAR 0001-9999 +
 MONTH 1-12 +
@@ -360,7 +360,7 @@ FRACTION in 4 bytes +
 | TIMESTAMP                     | Point in time, no time precision | Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 11 bytes
 | TIMESTAMP (with time precision) | Point in time, with time precision | Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 1 byte
 | Interval Data Types |Interval | INTERVAL | Duration of time; value is in the YEAR/MONTH range or the DAY/HOUR/MINUTE/YEAR/SECOND/FRACTION range
-| YEAR no constraint^5^ +
+| YEAR no constraint^4^ +
 MONTH 0-11 +
 DAY no constraint +
 HOUR 0-23 +
@@ -396,21 +396,22 @@ length of 8 bytes.
 * _precision_ specifies the allowed number of decimal digits.
 
 
-1.  The size of a column that allows null values is 2 bytes larger than the size for the defined data type.
-2.  The maximum row size is 32708 bytes, but the actual row size is less than that because of bytes used by
-null indicators, varchar column length indicators, and actual data encoding.
-3.  Storage size is the same as that required by CHAR data type but store only half as many characters depending
-on character set selection.
-4.  Storage size is reduced by 4 bytes for storage of the varying character length.
-5.  The maximum number of digits in an INTERVAL value is 18, including the digits in all INTERVAL fields of the value.
+1. The size of a column that allows null values is 2 bytes larger than the size for the defined data type.
+2. Storage size is the same as that required by CHAR data type but store only half.
+3. Storage size is reduced by 4 bytes for storage of the varying character length field.
+4. The maximum number of digits in an INTERVAL value is 18, including the digits in all INTERVAL fields of the value.
 Any INTERVAL field that is a starting field can have up to 18 digits minus the number of other digits in the INTERVAL value.
-6.  The maximum is 32707 if the national character set was specified at installation time to be ISO88591.
-The maximum is 16353 if the national character set was specified at installation time as UTF8.
-7.  The maximum is 32703 if the national character set was specified at installation time to be ISO88591.
-The maximum is 16351 if the national character set was specified at installation time as UTF8.
-8.  It defaults to 200000 characters and can be declared explicitly by using the TRAF_MAX_CHARACTER_COL_LENGTH CQD.
-9.  It defaults to 200000 bytes and can be declared explicitly by using the TRAF_MAX_CHARACTER_COL_LENGTH CQD.
-
+5. The maximum is 16,777,216 bytes whether the national character set was specified at installation time to be ISO88591 or UTF8.
+6. The number of characters varies depending on the character set.
++
+[cols="2*^",options="header"]
+|===
+| *Character Set* |	*Character*
+| ISO88581	    | 16,777,216, which is divided 16,777,216 by 1
+| UCS2	        | 8,388,608, which is divided 16,777,216 by 2
+| UTF8	          | 4,194,304, which is divided 16,777,216 by 4
+|===
+7. The number of characters is 8,388,608 (UCS2). 
 
 <<<
 [[comparable_and_compatible_data_types]]


[3/5] trafodion git commit: Incorporate Comments 1

Posted by db...@apache.org.
Incorporate Comments 1


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

Branch: refs/heads/master
Commit: 477330e1ee1f261bb973af9c962d2b9208e7316f
Parents: b68ab4d
Author: liu.yu <qw...@hotmail.com>
Authored: Tue Jul 10 10:40:49 2018 +0800
Committer: liu.yu <qw...@hotmail.com>
Committed: Tue Jul 10 10:40:49 2018 +0800

----------------------------------------------------------------------
 .../_chapters/sql_language_elements.adoc        | 43 +++++++++-----------
 1 file changed, 20 insertions(+), 23 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/477330e1/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 43b8b9d..8093145 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
@@ -324,15 +324,15 @@ The following table summarizes the {project-name} SQL data types:
 
 [cols="14%,14%,24%,24%,24%",options="header"]
 |===
-| Category | Type | SQL Designation | Description | Size or Range^1^
-.8+| Character String Data Type .3+| Fixed-length character | CHAR[ACTER]          | Fixed-length character data            | 1 to 16,777,216 bytes ^6^
-| NCHAR                | Fixed-length character data in predefined national character set | 1 to 16,777,216 bytes^2^ ^5^ ^7^
-| NATIONAL CHAR[ACTER] | Fixed-length character data in predefined national character set | 1 to 16,777,216 bytes^2^ ^5^ ^7^
-.5+| Variable-length character | VARCHAR                      | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^6^
-| VARCHAR2                     | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^6^
-| CHAR[ACTER] VARYING          | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^6^
-| NCHAR VARYING                | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^5^ ^7^
-| NATIONAL CHAR[ACTER] VARYING | Variable-length ASCII character string | 1 to 16,777,216 bytes^3^ ^5^ ^7^
+^| *Category* ^| *Type* ^| *SQL Designation* ^| *Description* ^| *Size or Range*^1^
+.8+| Character String Data Type .3+| Fixed-length character | CHAR[ACTER]          | Fixed-length character data            | 1 to 16,777,216 bytes ^2^
+| NCHAR                | Fixed-length character data in predefined national character set | 1 to 16,777,216 bytes^2^ ^3^ 
+| NATIONAL CHAR[ACTER] | Fixed-length character data in predefined national character set | 1 to 16,777,216 bytes^2^ ^3^
+.5+| Variable-length character | VARCHAR                      | Variable-length ASCII character string | 1 to 16,777,216 bytes^2^ ^4^
+| VARCHAR2                     | Variable-length ASCII character string | 1 to 16,777,216 bytes^2^ ^4^
+| CHAR[ACTER] VARYING          | Variable-length ASCII character string | 1 to 16,777,216 bytes^2^ ^4^
+| NCHAR VARYING                | Variable-length ASCII character string | 1 to 16,777,216 bytes^2^ ^3^ ^4^
+| NATIONAL CHAR[ACTER] VARYING | Variable-length ASCII character string | 1 to 16,777,216 bytes^2^ ^3^ ^4^
 .6+| Datetime Data Types .6+| Date-Time | | Point in time, using the Gregorian calendar and a 24 hour clock system. The five supported designations are listed below.
 | YEAR 0001-9999 +
 MONTH 1-12 +
@@ -360,7 +360,7 @@ FRACTION in 4 bytes +
 | TIMESTAMP                     | Point in time, no time precision | Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 11 bytes
 | TIMESTAMP (with time precision) | Point in time, with time precision | Format as YYYY-MM-DD HH:MM:SS.FFFFFF; actual database storage size is 1 byte
 | Interval Data Types |Interval | INTERVAL | Duration of time; value is in the YEAR/MONTH range or the DAY/HOUR/MINUTE/YEAR/SECOND/FRACTION range
-| YEAR no constraint^4^ +
+| YEAR no constraint^5^ +
 MONTH 0-11 +
 DAY no constraint +
 HOUR 0-23 +
@@ -395,23 +395,20 @@ length of 8 bytes.
 * _scale_ is the number of digits to the right of the decimal.
 * _precision_ specifies the allowed number of decimal digits.
 
-
 1. The size of a column that allows null values is 2 bytes larger than the size for the defined data type.
-2. Storage size is the same as that required by CHAR data type but store only half.
-3. Storage size is reduced by 4 bytes for storage of the varying character length field.
-4. The maximum number of digits in an INTERVAL value is 18, including the digits in all INTERVAL fields of the value.
-Any INTERVAL field that is a starting field can have up to 18 digits minus the number of other digits in the INTERVAL value.
-5. The maximum is 16,777,216 bytes whether the national character set was specified at installation time to be ISO88591 or UTF8.
-6. The number of characters varies depending on the character set.
+2. The maximum number of characters depends on the character set. 
 +
-[cols="2*^",options="header"]
+[cols="2*",options="header"]
 |===
-| *Character Set* |	*Character*
-| ISO88581	    | 16,777,216, which is divided 16,777,216 by 1
-| UCS2	        | 8,388,608, which is divided 16,777,216 by 2
-| UTF8	          | 4,194,304, which is divided 16,777,216 by 4
+^| *Character Set* ^|	*Maximum Number of Characters* 
+| For 8-bit character sets such as *ISO88591*	    | Equal to the maximum storage size in bytes, that is 16,777,216, which is divided 16,777,216 by 1
+| For 16-bit character sets such as *UCS2*	      | Half the maximum storage size in bytes, that is 8,388,608, which is divided 16,777,216 by 2
+| For 32-bit character sets such as *UTF8*        | One fourth the maximum storage size in bytes, that is 4,194,304, which is divided 16,777,216 by 4
 |===
-7. The number of characters is 8,388,608 (UCS2). 
+3. NCHAR or NATIONAL CHAR implicitly assumes that the character set is UCS2, whether the character set was specified at installation time to be ISO88591 or UTF8, and the character set (UCS2) cannot be specified or altered. This is true for both CREATE and ALTER statement.
+4. Storage size is reduced by 4 bytes for storage of the varying character length field.
+5. The maximum number of digits in an INTERVAL value is 18, including the digits in all INTERVAL fields of the value.
+Any INTERVAL field that is a starting field can have up to 18 digits minus the number of other digits in the INTERVAL value.
 
 <<<
 [[comparable_and_compatible_data_types]]


[4/5] trafodion git commit: Make edits for accuracy and clarity

Posted by db...@apache.org.
Make edits for accuracy and clarity


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

Branch: refs/heads/master
Commit: a3d2653fab85b6780bfd8093a73a2cf965df7a58
Parents: 477330e
Author: liu.yu <qw...@hotmail.com>
Authored: Tue Jul 10 17:52:29 2018 +0800
Committer: liu.yu <qw...@hotmail.com>
Committed: Tue Jul 10 17:52:29 2018 +0800

----------------------------------------------------------------------
 .../src/asciidoc/_chapters/sql_language_elements.adoc  | 13 +++++++------
 1 file changed, 7 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/a3d2653f/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 8093145..72a6052 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc
@@ -372,7 +372,7 @@ 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 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
+.10+| Numeric Data Types .5+| Numeric^6^ ^7^ | NUMERIC (1,_scale_) to + NUMERIC (128,_scale_) | Binary number with optional scale; signed or unsigned for 1 to 9 digits
 | 1 to 128 digits; +
 stored: +
 1 to 4 digits in 2 bytes +
@@ -383,17 +383,16 @@ depending on precision
 | SMALLINT                      | Binary integer; signed or unsigned    | 0 to 65535 unsigned, -32768 to +32767 signed; stored in 2 bytes
 | INTEGER                       | Binary integer; signed or unsigned    | 0 to 4294967295 unsigned, -2147483648 to +2147483647 signed; stored in 4 bytes
 | LARGEINT                      | Binary integer; signed only           | -2^63^ to +(2^63^)-1; stored in 8 bytes
-|Numeric (extended numeric precision) | NUMERIC (precision 19 to 128)  | Binary integer; signed or unsigned    | Stored as multiple chunks of 16-bit integers, with a minimum storage
+|Numeric (extended numeric precision)^7^ | NUMERIC (precision 19 to 128)  | Binary integer; signed or unsigned    | Stored as multiple chunks of 16-bit integers, with a minimum storage
 length of 8 bytes.
-.3+| Floating point number | FLOAT[(_precision_)] | Floating point number; precision designates from 1 through 52 bits of precision | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes
+.3+| Floating point number^7^ | FLOAT[(_precision_)] | Floating point number; precision designates from 1 through 52 bits of precision | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes
 | REAL                  | Floating point number (32 bits)        | +/- 1.17549435e-38 through +/ 3.40282347e+38; stored in 4 bytes
 | DOUBLE PRECISION      | Floating-point numbers (64 bits) with 1 through 52 bits of precision (52 bits of binary precision and 1 bits of exponent) | +/- 2.2250738585072014e-308 through +/-1.7976931348623157e+308; stored in 8 bytes
-| Decimal number        | DECIMAL (1,_scale_) to DECIMAL (18,_scale_)     | Decimal number with optional scale; stored as ASCII characters; signed or unsigned for 1 to 9 digits; signed required for 10 or more digits
+| Decimal number^6^        | DECIMAL (1,_scale_) to DECIMAL (18,_scale_)     | Decimal number with optional scale; stored as ASCII characters; signed or unsigned for 1 to 9 digits; signed required for 10 or more digits
 | 1 to 18 digits. Byte length equals the number of digits. Sign is stored as the first bit of the leftmost byte.
 |===
 
-* _scale_ is the number of digits to the right of the decimal.
-* _precision_ specifies the allowed number of decimal digits.
+TIP:
 
 1. The size of a column that allows null values is 2 bytes larger than the size for the defined data type.
 2. The maximum number of characters depends on the character set. 
@@ -409,6 +408,8 @@ length of 8 bytes.
 4. Storage size is reduced by 4 bytes for storage of the varying character length field.
 5. The maximum number of digits in an INTERVAL value is 18, including the digits in all INTERVAL fields of the value.
 Any INTERVAL field that is a starting field can have up to 18 digits minus the number of other digits in the INTERVAL value.
+6. _scale_ is the number of digits to the right of the decimal.
+7. _precision_ specifies the allowed number of decimal digits.
 
 <<<
 [[comparable_and_compatible_data_types]]


[5/5] trafodion git commit: Merge [TRAFODION-3132] PR 1634 Add/correct SQL Ref Manual char descriptions

Posted by db...@apache.org.
Merge [TRAFODION-3132] PR 1634 Add/correct SQL Ref Manual char descriptions


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

Branch: refs/heads/master
Commit: 20f8240e4aab974ecac20cc8c663e99664b7c143
Parents: 9f8fc8e a3d2653
Author: Dave Birdsall <db...@apache.org>
Authored: Tue Jul 10 15:15:57 2018 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Tue Jul 10 15:15:57 2018 +0000

----------------------------------------------------------------------
 .../_chapters/sql_language_elements.adoc        | 59 ++++++++++----------
 .../src/asciidoc/_chapters/sql_statements.adoc  |  4 +-
 .../src/asciidoc/_chapters/sql_utilities.adoc   |  4 +-
 3 files changed, 33 insertions(+), 34 deletions(-)
----------------------------------------------------------------------



[2/5] trafodion git commit: Fix Typos

Posted by db...@apache.org.
Fix Typos


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

Branch: refs/heads/master
Commit: b68ab4d64c9c1e8d09851a3b484de82c6a8a2ee9
Parents: f72d026
Author: liu.yu <qw...@hotmail.com>
Authored: Mon Jul 9 17:37:35 2018 +0800
Committer: liu.yu <qw...@hotmail.com>
Committed: Mon Jul 9 17:37:35 2018 +0800

----------------------------------------------------------------------
 docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc | 4 ++--
 docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc  | 4 ++--
 2 files changed, 4 insertions(+), 4 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/trafodion/blob/b68ab4d6/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
index f2462f9..4b4e9a3 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc
@@ -2910,9 +2910,9 @@ CREATE SEQUENCE   employee_seq
 START WITH        1
 INCREMENT BY      1
 MAXVALUE          10000   
-NOCYCLE
+NO CYCLE
 CACHE             20  
-UNSIGNED SMALLINT
+SMALLINT UNSIGNED 
 ```
 
 The first reference to `seqnum(empolyee_seq, next)` will return 10000, and the second reference will return 10001. Each subsequent reference will return a value 1 greater than the previous value.

http://git-wip-us.apache.org/repos/asf/trafodion/blob/b68ab4d6/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
index 126ef7e..1de9b3a 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_utilities.adoc
@@ -1736,8 +1736,8 @@ PURGEDATA object
 [[purgedata_syntax]]
 === Syntax Description of PURGEDATA
 
-_object_
-
+* _object_
++
 is the name of the table from which to purge the data. See
 <<"database object names","Database Object Names">>.