HowToTeraData: Beginners guide to teradata.

1. Getting the software and installing it:-
Get the demo version from http://www.teradata.com/dwdemo

2. Logon using BTEQ

From command mode run bteq or bteqwin( for windows version).

default userid is /dbc
default password is dbc

C:\Documents and Settings\Hasim>bteq

Teradata BTEQ 13.00.00.03 for WIN32.
Copyright 1984-2009, Teradata Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.logon

.logon
UserId: dbc
Password:

*** Logon successfully completed.
*** Teradata Database Release is 13.00.00.12
*** Teradata Database Version is 13.00.00.12
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.

*** Total elapsed time was 2 seconds.

BTEQ -- Enter your DBC/SQL request or BTEQ command:

If facing the following error then Check HowToTeraData: CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database

3. Create user/database
---- Need to see -----
create user hasim_tdt from dbc as
permanent = 1000000
,password = hasim_tdt
,spool = 2000000
,fallback protection
,dual after journal
,default journal table = hasim_tdt.journals
,account = '$dbc';

4. what are the tables in DBC?

--- NTS ----

5. How to interrupt execution in bteqwin/bteq if something wrong happens?

--- NTS ---