Depending on the configuration of the system SYSPRINT specification or system output settings, BTEQ either displays the results on the user terminal or writes them to the specified file:
.Logon e/fml, password, acctid *** Logon successfully completed. *** Total elapsed time was 3 seconds. .SET SEPARATOR ' | ' SELECT * FROM department; *** Query completed. 5 rows found. 4 columns returned. *** Total elapsed time was 3 seconds. DeptNo | DeptName | Loc | MgrNo ------ -------------- --- ----- 500 | Engineering | ATL | 10012 700 | Marketing | NYC | 10021 300 | Exec Office | NYC | 10018 600 | Manufacturing | CHI | 10007 100 | Administration| NYC | 10011 .LOGOFF *** You are now logged off from the DBC. .EXIT;