Creating a new Teradata database table

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)

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)

Document get from Talend https://help.talend.com

Thank you for watching.

Docs 6.x

0 Comments

Inline Feedbacks

View all comments

Creating a new Teradata database table – Docs for ESB 6.x

Creating a new Teradata database table

My Website Links

Tags