Can ANSI transaction mode be set in TPT script?

Tools & Utilities
Enthusiast

Can ANSI transaction mode be set in TPT script?

Hello,

Converting from Oracle to Teradata gave me some surprises when transferring data (primary index errors, unexpected dupes).  In Oracle we operate in a CASESPECIFIC mode, but I found that by default our Teradata instance is operating in Teradata mode (NOT CASESPECIFIC).    We would like to create tables in CASESPECIFIC mode and treat all of our character columns as CASESPECIFIC.  Is there a way to specify the transaction mode when running a TPT/tbuild script?  I have checked the manual and found no mention of this.

Thanks!

6 REPLIES
Teradata Employee

Re: Can ANSI transaction mode be set in TPT script?

TPT always runs in Teradata mode.

It is hardcoded that way and the user cannot change that.

-- SteveF
Senior Supporter

Re: Can ANSI transaction mode be set in TPT script?

dbs controll field “DefaultCaseSpec”

Determines whether character string comparisons consider character case and whether character columns are considered case specific by default in Teradata session mode.

But this is a system level field!

I would really try to avoid it - case specific fields. Often they are not needed.

Enthusiast

Re: Can ANSI transaction mode be set in TPT script?

Thanks for the replies.  We work with medical data so there are often times where mixed case makes sense.

Since TPT can't log in with ANSI, then I guess we can set CASESPECIFIC on the individual columns in the TPT script's CREATE TABLE statement?  Does that sound correct?

Thanks!

Re: Can ANSI transaction mode be set in TPT script?

hi guys

pls can you provide TPT Material .I am beginner to TPT

Senior Supporter

Re: Can ANSI transaction mode be set in TPT script?

did you read the manuals? There are some good examples for different jobs to start with.

Teradata Employee

Re: Can ANSI transaction mode be set in TPT script?