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?
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.