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 Teradata 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 Teradata Database. If a semicolon is not used, the comment is sent to Teradata 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 Teradata Database and a syntax error is returned.