All Forums Tools
gpolanch 46 posts Joined 12/11
03 Feb 2012
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!

 

feinholz 1234 posts Joined 05/08
03 Feb 2012

TPT always runs in Teradata mode.

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

 

--SteveF

ulrich 816 posts Joined 09/09
03 Feb 2012

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.

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

gpolanch 46 posts Joined 12/11
04 Feb 2012

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!

vchittiprolu 1 post Joined 02/12
15 Feb 2012

hi guys

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

ch.venu

ulrich 816 posts Joined 09/09
15 Feb 2012

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

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Murali R 2 posts Joined 04/11
21 Feb 2012

Go to the below link

http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=TTU14.0&rdsort=Title&srtord=Asc&wNew=True&nm=Teradata+Tools+and+Utilities+14.0.

You will find the materials for TPT.

Knowing is not enough, we must apply. Willing is not enough, we must do.

You must sign in to leave a comment.