Let us assume, we have a data warehouse in teradata. Let us suppose that this data warehouse is loaded with a set of scripts. In principle it could be done. The question then arises how the scripts are run. An example could clarify this. The example looks like:
.logon oTDD001.s2.ms.****.com/TOM.VAN-MAANEN, pau26688 .export report file=C:\Users\TOM.VAN-MAANEN\phi.txt .set retlimit 20 SELECT '"'||trim(Ident)||'";"'|| trim(Serial)||'";"'|| trim(Node)||'"' FROM SAN_D_FAAPOC_01.TestUnicode; .export reset; .quit
The first line of this script creates a connection to a Teradata machine. The second line allocates a file that will be used to write data to. The fourth line is standard example where records from a table are exported. The last lines finishes the export and finishes the export from a table.
This scripts is called by a piped command where the script is sent to the bteq:
C:\Users\TOM.VAN-MAANEN>bteq < bteq.txt BTEQ 13.10.00.01 Thu May 22 11:28:08 2014 +---------+---------+---------+---------+---------+---------+---------+---- .logon oTDD001.s2.ms.unilever.com/TOM.VAN-MAANEN, *** Logon successfully completed. *** Teradata Database Release is 14.00.06.05 *** Teradata Database Version is 14.00.06.05 *** Transaction Semantics are BTET. *** Session Character Set Name is 'ASCII'. *** Total elapsed time was 1 second. +---------+---------+---------+---------+---------+---------+---------+---- .export report file=C:\Users\TOM.VAN-MAANEN\phi.txt *** To reset export, type .EXPORT RESET +---------+---------+---------+---------+---------+---------+---------+---- .set retlimit 20 +---------+---------+---------+---------+---------+---------+---------+---- insert into SAN_D_FAAPOC_01.TestUnicode(ident,node,serial) values('Test├╣─ÖSummary','Test├╣─ÖSummary',' 19'); *** Insert completed. One row added. *** Total elapsed time was 1 second. +---------+---------+---------+---------+---------+---------+---------+---- SELECT '"'||trim(Ident)||'";"'|| trim(Serial)||'";"'|| trim(Node)||'"' FROM SAN_D_FAAPOC_01.TestUnicode; *** Query completed. 16 rows found. One column returned. *** Total elapsed time was 1 second. +---------+---------+---------+---------+---------+---------+---------+---- .export reset; *** Output returned to console. +---------+---------+---------+---------+---------+---------+---------+---- .quit *** You are now logged off from the DBC. *** Exiting BTEQ... *** RC (return code) = 0 C:\Users\TOM.VAN-MAANEN>