GENERIC JDBC and Teradata Databases

Database
Enthusiast

GENERIC JDBC and Teradata Databases

Hello All,

Could plz help me understand the difference between these two connections.

Is it like when i connect a user with GENERIC JDBC, the session is ANSI. Eg. When i create table. By default, it is created as MULTISET table. Whereas if i connect a user using Teradata Database the session is Teradata Semantic and when i create a table, by default it is created as SET. I am right?

1 REPLY
Teradata Employee

Re: GENERIC JDBC and Teradata Databases

When you specify the JDBC connection parameter TMODE=ANSI, then the CREATE TABLE command's default behavior is to create a MULTISET table.

When you specify the JDBC connection parameter TMODE=TERA, then the CREATE TABLE command's default behavior is to create a SET table.

In either transaction mode, you can override the CREATE TABLE command's default behavior by specifying the SET or MULTISET attribute explicitly.