All Forums

Covers the world of Teradata Tools & Utilities. This includes topics such as SQL Assistant, BTEQ, TPump, FastLoad, TPT, etc. For articles, blogs and more, see the Tools section of the site.

You must login to post to the forums.
BTEQ and OReplace Topic by KellnerK 12 Aug 2016

I have written a SQL statement using the oReplace function and it works fine within SQL Assistant.  When I run the .sql file through BTEQ however and output the resulting file as a .CSV, every column after the first column that uses the oReplace function does not get output.

183 views
3 replies, 3 years ago
Any way to find the original query that created a table? Topic by ruhickson 12 Aug 2016

Hi everyone,
Is there a quick way to find the query used to create a table in SQL Assistant? Not the SHOW TABLE function, but a function to recreate the original query?

269 views
3 replies, 3 years ago
teradata utilities doesn't work with python on Mac Topic by Naveen_K 11 Aug 2016

Hi,
I installed TTU 14.10 on my Mac. When I execute the command from shell like bteq, tbuild etc., it works fine. When I invoke the same command from python, it fails.
 
>>> my_cmd = "bteq"

>>> 

>>> os.system(my_cmd)

dyld: Library not loaded: libicuiotd.46.dylib

111 views
0 replies
Fastload error: I/O Error on File Open 34 Topic by mpmchic 05 Aug 2016

I have a large text file with 366 columns, pipe delimited.   Fastload fails with this error: Error : I/O Error on File Open: 34, Text: pmUnxDskOpen: fopen error (Invalid argument)
 
 
This is this script being run:

SHOW VERSION;

SESSIONS 4;

ERRLIMIT 500;

 

RUN file C:\scripts\fastload_logon.prn;

 

200 views
3 replies, 3 years ago
TPT load failure - Please suggest Topic by tddev1984 05 Jun 2014

Dear Experts,
We are facing a failure during loading a file into a table using TPT utility. We loaded files a lot of times successfully but this time, its a very huge file (>100 GB) probably causing the issue.
Errror Observed :
FILE_READER: TPT19350 I/O error on file '/dev/aps/file123.dat.
FILE_READER: TPT19417 pmRead failed. Buffer overflow (17)

4775 views
33 replies, 3 years ago
Complete TTU removal Topic by josephmichael.navarro 09 Aug 2016 #TTU, #uninstall, #remove, #TTUListProducts, #silent_uninstall

When I run TTUListProducts.exe, it shows that I still have the following apps even though I already uninstall it.

Version                 Display Name

--------------------------------------------------------------------------------------------------------------------

15.10.01.00           Teradata Index Wizard 15.10.1

201 views
0 replies
Reg: SQL Assistant download for Mac OS Topic by abhilash.dwbi@gmail.com 08 Aug 2016

Hi,
I am looking for Teradata SQL Assistant for MAc Os, but am unable to find exact location/link to download  if any body provide me the download link and also installtion steps?  TIA

191 views
1 reply, 3 years ago
Queries for Teradata Fast Export Utility Topic by indra91 28 Jul 2016

We need to offload huge volume of data from a Teradata table to a network attached filesystem using the FastExport Utility.

The database will be a standalone server while the Fastexport script will be executed from the edge node of a hadoop cluster.

124 views
1 reply, 3 years ago
Record count from worktable in mload Topic by ananthaisin 11 May 2011

Hi All,

I need some clarification on mload worktable. While Mload process is still going on how to check the record count in worktable?

If i put select Count(*) from wt_tabl1;

its not showing any records.

Rgds
Anantha

7699 views
4 replies, 3 years ago
Export with header using TPT Topic by srivigneshkn 26 Jul 2016 column header, tpt export, table header

Hi,
I am using TPT export for doing data export from TD to a file and want to include column headers to the generated file.
I would like to know if there are any attributes that is included with newer version of tpt that we can use for this., I am using TPT version 14.10
 
Regards,
Srivignesh KN

227 views
4 replies, 3 years ago
Teradata Parallel Transporter - error with automatic schema Topic by grzegorz_osik 02 Aug 2016 tpt, teradata parallel transporter, 15.00

Using Teradata parallel transport with simplified syntax we get error 

TPT02638: Error: Conflicting data length for column(3) - "sr_abo_netto_do_oferty". Source column's data length (16) Target column's data length (8).

 

Source table:

236 views
0 replies
MLOAD APPLY WHERE condition which is not an equality Topic by stevehager 01 Aug 2016 multiload, mload, import

I have a very simple working MLOAD and have a new requirement to block data from being INSERTED.  I see many examples where the WHERE of an APPLY statement is specified as equality (=) and am sure I've done that in the past successfully, but my new requirement is to skip based on 'not equal to'.
 
 
Layout of file:

.LAYOUT INFILE_LAYOUT;

238 views
1 reply, 3 years ago
SQL Assistant 15.00 Cursor lagging problems Topic by stanley20924 11 Jan 2016 #database #teradata #TTU #SQLAssistant

Hello, 

260 views
4 replies, 3 years ago
HELP cannot display long field names Topic by auatospw 27 Jul 2016

Does anyone know how to let HELP in SQL Assistant to display field names longer than 30 char?
I use Teradata 15 so the field names can be up to 128 chars long. However when I use HELP to list the fields the long field names are all truncated to 30 chars.
 

146 views
2 replies, 3 years ago
Need Help regarding TPT ODBC Operator Topic by Arpan.Roy 10 May 2016 tpt, ttu, DataDirect TPT ODBC Operator

Hi All,

I create one ODBC Connection entry in ODBCINI file defined in .profile. OS is RHEL (Red Hat Enterprise Linux Server release 5.9 (Tikanga)). TPT Version is 14.10.00.08.

2198 views
30 replies, 3 years ago
Delimiter issue in Fastload Topic by sravana 27 Jul 2016

Hi All,
when I was loading CSV file into staging table by using Fastload getting below issue
In my script delimiter is "," but few fields in CSV file was having comma (,) is a part of the data since data was not loading respective columns in table.
e.g.
Data available in CSV file is as mentioned below
eno,ename,sal
"101","narsi", 1000

166 views
2 replies, 3 years ago
not Sign Delimiter issue in Fastload Topic by sravana 27 Jul 2016

Hi All,
In my flat file delimiter is “¬". This file I need to run in UTF8 format.
Can any one of you guide me how to run fastload script in UTF8 form in windows command prompt?
 
Regards,
Narsi
 

97 views
1 reply, 3 years ago
Ctrl-A delimiter with TPT Export. Topic by srivigneshkn 25 Jul 2016

Hi, 
I want to use CTRL-A as delimiter for TPT exports, I would like to know how to specify this in the TPT script.
Thanks & Regards,
Srivignesh KN

181 views
2 replies, 3 years ago
TPT 15.10 ODBC Operator : Bundled DataDirect Drivers ! Topic by Willimoa 28 Sep 2015 DataDirect TPT ODBC Operator

Just so everyone knows:
A topic that has come up several times with the TPT ODBC Operator is that some of us (including me - dev only!) have used the non-supported ODBC drivers.  

786 views
2 replies, 3 years ago
Upload files .dat in Teradata Topic by Valeria 17 Feb 2016

Hello ,
I have a question concerning the upload of files in Teradata.
Is it possible to upload in files .dat in Teradata? Files .dat are files with fixed record lengths, without tab or any other coloumn delimiter.
Thank you and best regards,
Valeria

246 views
7 replies, 3 years ago
can not download presto JDBC/ODBC client package Topic by hanx5520 24 Jul 2016

Hi, I cannot download client package from the following link, I can only download a 6 byte file. Can somebody help me? Thank you in advance.
http://www.teradata.com/Presto-Download-Get-Started/?LangType=1033&LangSelect=true
 
/Xiaoyong.

106 views
0 replies
SQL Error highlighting w/.Net connector not working (SQL Assistant v15) Topic by srjilek 24 Jul 2016 #TTU #SQLAssistant

I've got 2 installs of SQL Assistant, and neither are highlighting the error line when running queries, and I'm using the .Net connector.  One of them is the latest version, and a clean install on a new PC.

 

A coworker has his working and he's on v14 or v15 I beleive.  Is there some setting that I should check to enable this feature?

 

Windows(x64)

132 views
0 replies
Installing Teradata ODBC on AIX Topic by jmooney 22 Jul 2016 AIX ODBC

Hi,
I am in need of installing Teradata ODBC on AIX 7.1.
I have downloaded the AIX Teradata ODBC file.  According to it's read file:

122 views
1 reply, 3 years ago
Determine #sessions to set for load / exp jobs Topic by KN 18 Jul 2016 #Sessions

Hello Gurus
Is there a rule of thumb that one should follow for determining the number sessions that should be set for a load or fexp jobs?
Suppose if my system is a 4 node system with 40amps/node , what would be the best practice?
 
regards
KN

288 views
5 replies, 3 years ago
TPT - Scripting Topic by KN 19 Jul 2016 TPT#Scripting

Hello Folks
I have a requirement to move 90 tables totalling up to 200 GB from one Teradata system to an another Teradata system.. While i know there are different options i plan to use TPT to move them..All the column data has to be moved..

202 views
7 replies, 3 years ago

Pages