Procedure
-
Double-click tTeradataRow to open its
Basic settings view.
- Fill in the Host, Database, Username, and Password fields with your Teradata database connection details.
-
In the Query field, enter the following
SQL statement to create a new table named person with three columns id, name, sex.
CREATE SET TABLE samples.person, FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL ( id INTEGER NOT NULL, name VARCHAR(50), sex VARCHAR(20) ) UNIQUE PRIMARY INDEX (id)