17.00 - Comments - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Parallel Data Pump
June 2020
Programming Reference

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.