Comments - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
ioq1544831946920.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata TPump supports C language style comments. A comment begins with a slash asterisk “/*” and all subsequent input is treated as a comment until a terminating asterisk slash “*/” is encountered. Comments may nest and they do not occur within string or character literals. For an example, a “/*” within a quoted string is not treated as the beginning of a comment.

Comments are written to the message destination. Substitution of values for variable names continues within comments. If the variable name is required, two “&”s should be coded. Note that recursive comments are permitted, which means that to end the comment, the number of terminating “*/” sequences must match the number of start “/*” comment sequences that are outstanding.

Comments can be optionally sent to the database. If a comment is used together with a Teradata SQL statement, a semicolon may be placed as a terminating character to end the comment. The semicolon tells Teradata TPump to strip out the comment so that it is not sent to the database. If a semicolon is not used, the comment is sent to the database together with the Teradata SQL statement.

Nested comments are supported when they occur before or after Teradata SQL statements. Nested comments within Teradata SQL statements are not supported. Nested comments must terminate with a semicolon. If a semicolon is not appended, the comment is erroneously sent to the database and a syntax error is returned.