Teradata Cookbook

How to do it...

1. Connect to Teradata Database using SQLA or Studio.
2. Create the following permanent table in Database using the following code; it can be seen in the screenshot of SQLA:

/*Create set table*/CREATE volatile TABLE td_cookbook.EMP_TBL
(EMP_ID INTEGER ,
EMP_Name VARCHAR(20),
Sal INTEGER)primary index (EMP_ID)

3. Let's insert data into the table by using the following code. Also, check the snippet from SQLA:

/*Insert row into table*/
insert into td_cookbook.EMP_TBL values (1,'Andrew',250);
insert into td_cookbook.EMP_TBL values (2,'Rose',232);

Following code is show in snippet from SQLA:

4. We will now copy the data from the table ...