XMLCOMMENT Syntax - Advanced SQL Engine - Teradata Database

XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kxe1590704060061.ditamap
dita:ditavalPath
kxe1590704060061.ditaval
dita:id
B035-1140
lifecycle
previous
Product Category
Teradata Vantageā„¢
XMLCOMMENT (
  char_value_expr
  [ RETURNING { CONTENT | SEQUENCE } ]
)

Syntax Elements

char_value_expr
A character string.
The data type of char_value_expr can be CLOB, CHAR(n), or VARCHAR(n), where n is as close to 64K as permitted. If the type is CLOB, it cannot be larger than 64K.
If char_value_expr is NULL, the function returns NULL.
If the comment, derived by concatenating '<!-', the character string returned by char_value_expr, and '-->' is not a valid XML comment, an error is raised. For example, char_value_expr should not contain the substring '-->'.
RETURNING CONTENT
The return value is an XQuery document node with the comment node as its child.
RETURNING SEQUENCE
The return value is a sequence with the comment node as its only item. This is the default.