Hi,
Currently, I execute BTEQ scripts via a generated .Bat file with each script having a call to BTEQ similar to below:
bteq <Bteq\"File_1.btq" >> bteq_output.txt 2>&1

Has the Teradata Metadata Services been discontinued since TD 14.10?
Where can I download it , if its available?
 

Hi All,
 

Hi Team,
I am facing issue after installing the TD 14.10 ODBC Driver.
Installation Sequesnce :-

rpm -ivh tdicu/tdicu-14.10.00.04-1.noarch.rpm

rpm -ivh TeraGSS/TeraGSS_linux_x64-14.10.07.01-1.noarch.rpm

rpm -ivh tdodbc/tdodbc-14.10.00.09-1.noarch.rpm

My .Profile :-

#For TD Driver

Hi,
I am new to arcmain. i have witten a simple archive arcmain script but now i have following requirement while archiving a teradata database:
·         How to archive file to particular location (e.g C:\user\backup)
·         How to divide archive file into chunks (like 100mb per file)
·         How to apply compression on archive file

Hi All,
Not sure what I'm doing wrong but I'm trying to load a thorn (þ) delimited file.  Here is a sample record 

"field1"þ"field2"þ"field3"þ"field4"þ"field5"þ"field6"þ"field7"þ"field8"þ"field9"þ"field10"þ"field11"þ"field12"þ"field13"þ"field14"þ"field15"

Multiload script follows :

hi,
how to load different files using multiload into different tables.
File name will contain target table to load  ex: 'target_tablename_timestamp.dat, each file has header.
This header row should correspond to the column names that need to be loaded in the target table. We need to perform upserts on each target table.
Please advic me on this.

Is there a way to lock the history window in SQL assistant to the right bottom corner of the application just like in the older versions if Queryman?

Hi,I am migrating a file from a mainframe box to teradata. On the mainframe the field is stored as S9(9)V99. I need to convert it to decimal format on the teradata box. In the S9(9)V99 format the sign is superimposed with the least significant number, and thus converting it to a text format.Eg:- -123 would be represented in ZD as 12LWhen i use a query to read this field and attempt at casting it into a decimal format it gives me an error(3527) saying "Format string 'S9(9)V99' has combination of numeric , character and graphic values.The query i am using is:-select CAST((Field1 (FORMAT 'S9(9)v9(2)')) AS Decimal(11,2))also triedselect CAST(CAST(Field1 AS FORMAT 'S9(9)v9(2)') AS Decimal(11,2))Can anyone tell me if there is a valid data type to capture ZD usage.

I am trying to provide some assertions to users based on the number of records read from the source and number of records loaded into TD.
Is there any diagnostics functions present in TPT to extract the count of source records processed and number of records loaded into TD.
I have some details in the log file like these below .

Gettting this exception whenever try to open the connection.
 

Hi All,I'm trying to copy an archive file zipped using arcmain sent to me and trying to restore it on my own teradata database. I need to view the contents of the archive before I load it with the copy db script. I need the name of the database name inside the archive and cannot restore the archive without it ?

Hi,
 
Currently, I am trying to transfer data from one data table in TD(teradata) server1, to another TD server 2.

A couple of questions.
 
First, when loading the Teradata Parallel Transport Wizard, I receive the following error message:
Exception in thread "main" java.long.UnsatisfiedLinkError:  C:\Program Files (x86)\Teradata\15.00\Teradata Parallel Transporter\bin\wwhelp.dll: Cant load a IA 32 bit.dll on a AMD 64 bit Platform.
The rest of the error is in the File.
 

I would like to install TPT client on one of my linux server.
May I ask what software do I need to download and where can I find installation document?
 
Linux  2.6.18-238.12.1.el5 #1 SMP Sat May 7 20:18:50 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

Thanks,
Jim
 

Hi everyone,

Hello,
I have a CHAR(12) field in a table.  This field is a last 12 month field, so it provides 12 characters representing each of the past 12 month.  Problem is, the 12 characters in this field could be blank.  So when I go to export, it gets all messed up.  Is there a way to look into a field and convert any blanks into a value; say; x ?  

Hi All,I have date values null in load_date column and it is represented as '?'I want to to replace '?' values with ' '(space)here is the syntax i am usingselect top 10 case when load_date is null then ' ' else load_date end from cust_prof_fctbut when i run this query i am getting an error 3800:Data type mismatch in THEN/ELSE expression.please help me in resolving this issue.

Hi All,
I understand that a Secondary Index is a 2-AMP or an all-AMP operation, and also the subtable that is created and its contents.
However, I am not sure in what scenarios should a secondary index (unique or non-unique) be defined.
I would really appreciate some help here.
 
Thanks,
Aarsh

Hi , 
Can anyone explain me whether TPT Stream Operator(TPUMP) can be used to load data from file to table and table to file. If it is possible could you kindly provide the script for the same. 
In my view, TPT Stream Operator is best suitable for mini batch loads. Could you confirm this also please. 
 
Thank you,
Ramkumar

I am writing a PT script which loads from an oracle source to Teradata.
PROBLEM_COL in Oracle is defined as DECIMAL(10,0). In Teradata PROBLEM_COL is defined as Integer.
The load fails, and all rows are inserted into the error table.
Reviewing the logs I believe I see the problem:
Column Name              Offset   Length Type         

Hello everyone,

Hi Teradata gurus,
 
I have developed a process in Java that read some files, add some fields, and load in some pipes to my TPT script.
In my tests I'm loading 6 pipes with 6 separeted Threads.
To load this I have these Producer Operators:

I am planning to implement Teradata external table in my project. Could anyone give me some insight on Teradata external table. Planning to connect hive table or HDFS files from that.
Is there any relation between Teradata external table and query grid? It would be nice if you can provide me few details on query grid, it's capability, limitation and performance.
 

I was just given a new laptop and I'm re-installing software to get everything back as I had it on the old machine.  I have Teradata-Studio working and I'm now trying to get the tools to load.  Running either the TTU_BASE or TTU_DBM, I get the same error message saying ICU-32 and ICU-64 fail during install.