BTEQ - FOLDLINE in Teradata

Splits each line of a report into two or more lines after the specified columns. This compresses the report into a smaller width.

Syntax:
.SET FOLDLINE ON 1, 2, 3 (Columns position);


Example:
.SET WIDTH 40;
.SET SUPPRESS ON 1,2;
.SET FOLDLINE ON 2;
SELECT
e.EmpNo, e.Name,
c.WkEnd (FORMAT 'Mmm-dd'),
c.Hours, p.Description
FROM
employee e, project p,
charges c
WHERE e.EmpNo = c.EmpNo
AND c.Proj_Id = p.Proj_Id
AND e.DeptNo = 500
ORDER By 1,3;


Output:
The output will be folded after the second column.