Continuing SQL - Basic Teradata Query

A Teradata SQL request is automatically continued from one line to the next unless the line ends in a semicolon.

However, the following conditions are excluded:

exec /* exec macro current; 
*/macro xyz;

create macro xyz as 
(select * from dbc.tables;  
);

create macro xyz as 
(select ‘abcd; 
efgh’;  
);

When a Teradata SQL request is continued from one line to the next, BTEQ translates the line-feed characters at the end of the multi-line SQL requests to carriage-return characters. However, in case of a line-feed appearing inside a quoted string in the request, the line-feed characters are retained as-is.

Example 1: In the following multi-line request, the line-feed character at the end of 1st line will be translated to carriage return:

select 'abcd', 
'efgh';

Example 2: In the following multi-line request, the line-feed character at the end of 1st line will not be translated to carriage return because it is part of a quoted string:

select 'abcd 
efgh';