Suppressing Title Text and Titledashes in Exported REPORT Format Output - Basic Teradata Query

The following example demonstrates how to suppress the generation of column headers and titledashes at the top of an exported report.

.LOGON mydbs/myid, mypwd
CREATE TABLE Employer_Location (EmpNo INTEGER, Location CHAR(5));
INSERT INTO Employer_Location VALUES(1, 'LA');
INSERT INTO Employer_Location VALUES(2, 'NYC');
INSERT INTO Employer_Location VALUES(3, 'ATL');
.SET TITLEDASHES OFF
.EXPORT REPORT FILE=myfile1.exp
SELECT EmpNo (TITLE ''), Location (TITLE '') FROM Employer_Location;
.EXPORT RESET
.SET TITLEDASHES ON
.EXPORT REPORT FILE=myfile2.exp
SELECT EmpNo, Location FROM Employer_Location;
.EXPORT RESET
.LOGOFF
.EXIT

Output for myfile1.exp:

1  LA
2  NYC
3  ATL

Output for myfile2.exp:

      EmpNo  Location
-----------  --------
          1  LA
          2  NYC
          3  ATL