Hi TD Forum,
I am running on TD Ver 14, and have SQL Assistant 15.00, and when I run a query that has a prompt for two dates to be inout bythe user, the paramter promts of something like:
where date_col between '?date1' and '?date2'

I wanted to install from this link http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package. Teradata tool and utilities - base 15.00000 but get error "The installation of shared ICU-32 bit appears to have failed. Do you want to continue?"
 
Restart of installation didnt help. I`m using win7 32 bit.
 
 

I am using SQL Assistant 14.10.0.02, and i want to change settings for multiple answerset. Currently its opening in multiple tiles, making 4 tiles - 1 for Query,1 for History and 2 for Answerset(more depend on queries). How can we merge Answer set in one tile with multiple Tabs, the way multiple Query window works. Please guide.

Hi,
I'm new to Teradata, I would want to know if there is any utlity within Teradata which allows user to capture changed data from database. The identification of changed data should be done at system log level whenever a DML has fired in recent past and not in query level where an exisiting column in the database is already capturing change capture data time stamp.

Hi there,
 
I'm new to TPT and have got it working.  I'm wanting to use Job Variable files to house things such as username and password and have got this working with the main script by using tbuild -f and -v.

Hello, 
I am having issues performing data conversions specially with dates and timestamps while using fastload. My script is pasted below. All my rows are being imported and sent to error_1 table because of column CLR_DT with error 2665. My table is being is created before using the fastload utility. Any commentary is appreciated.
 
Destination Table DDL:

I need to perform a database backup but I am not able to find a place to download the tool or a package containing the tool. I think it might be included in a previous version of the utilities but I am not able to find the previous versions download? Would somebody be so kind to help? 

Hello All.
 
I am writing a bteq which is saving the output in the One file.Bteq has 3 different queries.
I need to save outout of all the three queries in three seprate files using one BTEQ.is it possible?
Also can we call bteq file within a bteq?
Regards 
Vc

Hi,
I am using Teradata Rest Service and trying to pass a parameter for my query:

select ? as ip_address
from my_database.ip_table as g
where internallib.ip2ip3(ip_address) between g.start_ip and g.end_ip
;

This is how my request looks like:

Hello:
When exporting data to a flat file we seeing that decimals with over 18 precision are being returned as zero.  MaxDecimalDigits is set to 38 so is there something else we are doing incorrectly here?
Columns 1, 3 and 5 are being exported as zero. So the first column 2687.350 ends up in the flat file as 0.  
Using Teradata 15 and TPT 15.

On running the following mload script :

If TPT Attributes INTEGER SkipRows = 1 and Varchar SkipRowsEveryFile = 'N' (There are more than 1 file), how will the loader know, for which file the row is to be skipped? How will the loader behave if it faces such scenario?

Hi,
 
I am writing a fastload script to load a 13M files to a teradata table.
I received error 
     ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 14.10.00.07               =

I've been searching for this in documentation all day, maybe someone knows this already.
I have read that since version 15.0, it's possible to go from a TPT script directly into HDFS. Right now my script creates the file in local, then uploads it, then deletes it. Anyway to to this more efficiently? Maybe a code sample I can reverse engineer?

Hi!
I'm trying to run a TPT job using Windows PowerShell but I'm getting this error:

I am new  to TD. Can someone please tell me what this line does.
bteq << !  >> /export/home/din/dba/dbc_hist.log_ 'date '+%m%d%y_%H%M' '   2>&1

Hi All,
 
I am trying to load the 8 mil rows into the target table and when I try to insert into target table then I get the below issue
 
* 16:46:18 UTY1802 Processing Import Sequence 1, Source Sequence 800000.
* 16:46:22 UTY4014 Access module error '17' received during 'pmReadDDparse'

I am not able to use enclosedby and escapedby arguments in Teradata hadoop connector. I get the following error when I pass these arguments. here I am trying to set enclosedby with a double quote and escapedby with forward slash. The error goes away when I remove the enclosedby and escapedby arguments. The below command is being run from a Linux Centos machine.

Hello,
 
I am working with an Informatica application where the most recent TTU supported is 14.10.
The Teradata RDBMS will be upgraded to 15.10. Could you let me know if the  TTU and all its components (TPT, ODBC BTEQ etc.) will be able to function properly with this version (15.10)?
 
Regards,
VA

I am loading a file from HDFS into Teradata using Teradata Hadoop connector. All my records are getting rejected due to error code 6760 (invalid timestamp). All the timestamp fields are of format yyyy-MM-dd HH:mm:ss.S with sample values being 2015-05-06 10:55:16.0, 2015-08-14 04:45:33.0.

Hi,

Hi,

I am trying to load data from HDFS/Hive into Teradata using the method batch.insert. 
Is there a way to set errorlimit property for the load so that the job will not fail when X-1 or lesser records were not loaded for when the errorlimit is set to X.
As per the TDCH doc the errorlimit property is applicable only for fastload and not for batch.insert mode.
 
 

When I try to use TPT wizard to connect to SQL Server using odbc DSN I am getting: There was an error initializing the driver for usage.

My configuration is the following:

Teradata RDBMS version 14.10.03.06

64bit Windows Server

TTU is patched to 14.10.15.00

My history window no longer appears at login and I can't select Show History from view window, the Show History text is greyed out. I can still access SQL history in a database but it is much easier to view and name my history when in the application.