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.
Code = 2644 No more room in database Topic by Vincent Gabrielli 16 Mar 2006

Hi folks, I need you expert advice once again...the client is trying to execute a procedure and is getting this error message Code = 2644.2644: No more room in database SMB_ETLBASE. Output directed to Answer set windowI verified the Max Perm space of that database and it's Database Name Used Max Perm Space % usedSMB_ETLBASE 2,328,576 21,225,428 11I do not understand why the client would be getting this error message when clearly there is enough room.Anxiously waiting for a reply...

64191 views
11 replies, 3 years ago
Is TOAD compatible with Teradata? Topic by gecko311 13 Oct 2008

Looking to use TOAD software to connect to Teradata...is this possible? Are there any other alternatives to Queryman as my system is x64 bit and apparently Queryman does not work with a x64 bit system.Thanks,gecko

21919 views
4 replies, 3 years ago
550 views
11 replies, 3 years ago
Exporting CSV from TPT Topic by skunkwerk 08 Apr 2016 tpt

Hi,
I have installed FastExport but apparently it cannot output CSV files.
So now I'm trying to get ahold of Teradata parallel transporter, to export a large table (hundreds of millions of rows).
I've read this post and the quickstart guide for TPT, but I still don't know how to export a CSV from a table.

546 views
7 replies, 3 years ago
Receiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQ Topic by 02CSE33 21 Apr 2013 source parcel length in BTEQ

Hi Gurus,
Now I am able to login properly in both Batch as well as Interactive mode through BTEQ.
The problem which I am facing is with IMPORT of data to Database.
Details of the IMPORT.

7590 views
33 replies, 3 years ago
Teradata Studio and Teradata Analyst Pack Topic by k3na 27 May 2015

Hello everybody,

I would like to investigate possibilities of Teradata Visual Explain and I'm using Teradata Express Studio (v. 15.00) to connect our Teradata installation. To use the tool, I need Teradata Analyst Pack. Is the tool available for partners, and if yes, how can we get access to it?

Many thanks!

1377 views
4 replies, 3 years ago
TPT load to table which contains special characters in name and column names Topic by Darych 27 Mar 2014 tpt, quotation, quotes, blank name

Hi to all,
I want to load data using TPT utilities into table which has special characters in table name and column names. In my code I build dml statement:
`INSERT INTO "aidar"."AID ! test"( "1ID", "2ID", "3ID", "DATA !11", "Ch <!-- eck") VALUES (:"AID !_0_1ID_00001", :"AID !_0_2ID_00002", :"AID !_0_3ID_00003", :"AID !_0_DATA !11_00004", :"AID !_0_Ch <!-- ec_00005");`

2216 views
10 replies, 3 years ago
WINCLI32.dll Topic by mdegruchy 05 Apr 2016 WINCLI32.DLL missinng

Does anyone have a wincli32.dll for BTEQ?

141 views
2 replies, 3 years ago
How to Trim multiple characters from a string Topic by Juanetta 31 Mar 2016

Hello
 
I found this code on your forun but need help to tweek it a bit:\  
My list has two delimiters Comma (,) and Line (|) (see below)

130 views
2 replies, 3 years ago
How to extract the count for source & target records in TPT Topic by rnekkanti 03 Mar 2016

Good Morning TPT experts!
I need some help to extract counts from TPT.
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.

206 views
5 replies, 3 years ago
fast export and mload with unicode column type and value Topic by akd2k6 09 Jul 2015

Hi All,
I am trying to unload data from one table by fexp script to file and then load the file to another same DDL table by mload.
But the records are getting rejected and going to error table when I encountered a column defined as unicode and it has special har.
column 
MERCH_NM_TXT VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC,
fexp script

2575 views
32 replies, 3 years ago
MLOAD will not read in null timestamps Topic by jking108 28 Mar 2016 6760, timestamp, mload

I am using mload to load in a large data set. However, I can't get any of hte data to load because of the error 6760. I know it deals with the timestamp.
 

305 views
1 reply, 3 years ago
Tools and Utilities 15.000 Download for Linux Topic by GNS 14 Sep 2015 tools and utilities, download, linux

Hello,
 
I will like to know where I can find this download. I ave been looking with no luck.
 
Thanks in advance

749 views
1 reply, 3 years ago
Teradata SQL Assistant Topic by totalzoom 24 Mar 2016

How can i convert the below SAS function to TEradata
input(substr(scan(dirct_advtsg_src_cd, 5, "-"),1,4),8.) >= 700 
 
dirct_advtsg_src_cd = 123_234_456_523_708000_7896564
 
 
 

373 views
2 replies, 3 years ago
TPT Branching Topic by rluebke 29 Dec 2009

Is there the ability to do conditional branching in TPT (similar to .IF operator in BTEQ)? I have looked in the ver 12 documentation and don't see anything like that and I am hoping I just missed it.

R

2451 views
3 replies, 3 years ago
Teradat TPT attributes to export data to a delimited file where data from individual column is enclosed in quotes Topic by rkuppala 21 Mar 2016

Hello
 
Would someone be able to help me out in what attributes should be added to the TPT script to extract the data with a delimiter and the values of individual column are enclosed in single quotes.

161 views
1 reply, 3 years ago
343 views
4 replies, 3 years ago
TPT - Handling Delimited File with Embedded CR\LF in field Topic by thompsonhab 17 Feb 2014 tpt, Carriage Return, CR\LF

Hi,
I have a file which is comma delimited with fields in double quotes and some comment fields have embedded CR/LF within the fields. How do I preserve the CR\LF and load the file using TPT Load Operator? I keep getting the error - Delimited Data Parsing error: Too few columns in row nnnnn because it treats the CR\LF within the field as a new row.

1229 views
2 replies, 3 years ago
Usage of multiple sessions by Teradata utilities like FL/ML/FE/TPT job ? Topic by SG255017 16 Mar 2016

Hi All
Can someone explain working of multiple sessions used by Fastload/Multiload/TPT/FastExport job ?
I understand that max no. of sessions by a job should not be greater than total no. of amps in the system.
 
For example,
Let say one particular FastExport job is using 10 sessions. Expected rows to be exported are 100

215 views
3 replies, 3 years ago
Date Diff in Teradata Topic by krishna.a 26 Apr 2007

Hi,can one help me in finding the diff between two dates in Teradata excluding saturdays and sundays.Thanks in advance.

16102 views
2 replies, 3 years ago
TPT : multiple sources in an operator ? Topic by py 14 Mar 2016

Hello everyone,
I tried to find if it was possible to have two sources in the selectStmt of an UPDATE operator (SELECT in oracle WHERE in teradata in my case), or imbricate two operators ?
I have found nothing so I guess it's impossible but I preferred to ask before giving up.

218 views
4 replies, 3 years ago
TPT script: error while executing TPT script Topic by devallu_y 24 Aug 2012

Hi,

Iam new to Teradata and need to develop TPT script to load data from file to teradata table.

I have developed the script and while running iam getting the error like:

TPT19404 pmOpen Failed Requested file not found(4)

TPT19304 Fatal error opening file

 

Could any one help on this.. Its urgent.

 

6954 views
16 replies, 3 years ago
TPT15.10. The need for TWB_ROOT ? Topic by Willimoa 14 Mar 2016 TPT TWB_ROOT

Hello,
We are getting errors when running TPT 15.10 on Solaris 10.  Output is :
Teradata Parallel Transporter Version 15.10.00.04 64-Bit
TPT_INFRA: TPT02002: Error: TWB_ROOT environment variable is not defined.
 
However, The TPT 14.10 User Guide says:  "Replaced TWB_ROOT with the following variable: TPT_install_directory."

231 views
3 replies, 3 years ago
BTEQ for linux installation Package Download Topic by Karthickvijay 31 Jul 2012

Hi,

 

Where can I download BTEQ utilities to install in Linux machine?

 

I have Teradata  installed in Windows machine. I am just planning to connect Windows Teradata machine through BTEQ linux machine. For this I need download ODBC driver and BTEQ utilities. Please help me to download these softwares.

 

Thanks,

Karthick

3969 views
2 replies, 3 years ago
Receive an error message while trying to use fast load Topic by Prashant_20986 10 Mar 2016 fastload, connection, Error:8017

Hi, I receive error message 8017: The UserId, Password or account is invalid while trying to load data using fast load. All the files are saved in Desktop.
 
********** Fast Load Script**************
 

logon 10.61.59.93/796207,Wpwp123;

 

drop table DATAMDL_SNDBX.QA_FL_PD;

drop table DATAMDL_SNDBX.ERROR_TABLE_ucv;

362 views
4 replies, 3 years ago

Pages