Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the scope of the Warehouse comment (*) character ?

April 26, 2017character comment SCOPE warehouse

0

Posted

What is the scope of the Warehouse comment (*) character ?

1 Answer

0

Posted

Unlike some languages where a comment indicator applies only to the physical line it occupies, the Warehouse comment character (*) applies to a logical line, where a logical line is composed of one or more physical lines. Hence the scope of a Warehouse comment is one or more physical lines. In the following OPEN statement, the Warehouse continuation character (&) is used to extend the statement across multiple physical lines : open db & remote sol22 user=qa password=homer & oracle scott/tiger home=c:\oracle\ora81 sid=ora816 When Warehouse encounters a comment character in the script, it looks for trailing continuation characters, and discards all continued physical lines that immediately follow. Warehouse then resumes its detailed parsing at the next un-continued line.