Teradata is a DBMS that is more or less created to handle massive amounts of data. I now work with it and this DBMS is able to handle 500 million rows in a split second. Brilliant. Teradata has a tool BTEQ that can be used to run scripts. Let us show a very simple script:
.logon 192.168.178.13/tom,********* database tom; select * from invoer; .logoff
This script can be run with the command “C:\Program Files (x86)\Teradata\Client\15.00\bin>bteq<C:\Users\tomva\Documents\s.txt”
The output looks as: