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.
TPT Inserter Operator Topic by Cvinodh 1 day ago #TPT, #Fastload

Hi,
Does TPT SQL Inserter operator supports error limit attribute?. Looking at the manual it seems it doesn't. But Stream operator does seems to support it. currently we are looking for alternatives to Load operator for low volume imports but our alternative solution must support error limit and skip row features.
 
Thanks,
Charles

53 views
0 replies
Need explanation on an unexpected error raised by the SOAP application. Topic by MaoTseTongue 2 days ago soap, api

Hi,

I encountered an "unexpected" error when using your SOAP application.

Error below:

> An unexpected error occurred (Error ID: api01/1432714249395). Please retry your request.

How know what happens, in order to fix it ?

48 views
0 replies
TPT: system variables with result count Topic by SebastianE 16 Jul 2012 tpt, parallel transporter

Hi everybody,

In the current implementation of our load scripts with multiload and tpump we are using the system variables holding the result count(&sysinscnt, &sysupdcnt, &sysetcnt, &sysuvcnt)  for logging and further processing.

4480 views
14 replies, 2 days ago
Teradata Studio and Teradata Analyst Pack Topic by k3na 3 days ago

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!

131 views
1 reply, 2 days ago
data provider for Ole DB Topic by wmmiteff 3 days ago oledb, 15.10

I know that functional updates are not being added to the data provider for OLEDB but I was curious if it was being updated for 15.10 and if it will be in the same path as the other executables/libraries.

63 views
0 replies
Question reg. TTU Support for RHEL on PowerPC platform Topic by s_reddy 4 days ago ttu, support platform

Hi,
From Product support matrix.TTU is currently not supported for the RHEL on PowerPc platform.
Is there any Roadmap planned to support RHEL on PowerPc architecture?
Thanks.

71 views
0 replies
TDGeoimport on Linux Topic by gl255000 1 week ago tdgeoimport, linux, install

Hi everyone! I've been using the TDGeimport Tool on Windows but I have to migrate all the ETL process to Linux, and now I have to Install TDGeoimport on Linux, is there a version for Linux? Or there is one single version that works with Windows and Linux?

 

If there is only one single version, does anyone knows how to install it?

 

Thanks for the help!

346 views
2 replies, 4 days ago
Not able to export data from SQL Server using TPT ODBC Operator Topic by M.M@TD 06 Nov 2013 TPT ODBC, SQL Server export

Hi TD Experts,
Please help me in identifying the cause for below issue.
 
I am able to fetch data from the MS SQL Server using Teradata SQL Assistant .
But when I try to fetch the same data using TPT ODBC Operator no data is returned.(Using the same ODBC Connection)
 
Here's the part of the TPT Script:
 
DEFINE SCHEMA Test_S
(

1542 views
5 replies, 1 week ago
Perm Space Value in BTEQ Export Report file incorrect Topic by parxv 1 week ago

Hi All,
I am trying to write a simple script to report tables which have not been used since last 90 days. i am using below code to get the values (some specific tables have been renamed)

.SET WIDTH 254;

.EXPORT REPORT FILE= unused_tables_VD.txt

185 views
2 replies, 1 week ago
TPT19003 Number of characters in column 20 (65537) exceeds maximum allowed (65536) Topic by MukhtarMohammed 1 week ago TPT19003, exceeds maximum allowed, (65537) exceeds maximum allowed (65536)

After TTU upgrade from 13 to 14 on unix, same tpt script is failing with below error which was running fine with earlier version
Script exports data from table to a pipe delimited file
Note: script runs fine if table has less records , say lesser than 500 records , but if same sript runs with 1000 records it fails
 Error:

166 views
3 replies, 1 week ago
bteq Topic by siva3699 1 week ago

hi anyone there for online training on teradata performance tuning

110 views
1 reply, 1 week ago
Join on Non indexed columns Topic by EsampalliSridhar 1 week ago

Hello ,
I have an interview question ..
What will happen internally in teradata when we try to join 2 tables to find the matched rows on EMP_Name column where EMP_ID column is index but not EMP_Name  ?
Is there anything will happend at AMP's side in processing anything like rearrange data  ? and what is rearrange in teradata ?
Thanks,
Sridhar.

142 views
1 reply, 1 week ago
Mload Error - UTY3403 Only one statement per line is allowed. Topic by nerdgirl 1 week ago

I have an Mload script which gives the following error. 

UTY3403 Only one statement per line is allowed.  Extra characters were detected beginning in column '43'.

 

I have verified the same script against my other scripts and its fine. There are no syntax problems. 

Is this error got something to do with the import data file format 

191 views
5 replies, 1 week ago
FASTLOAD Date format issue Topic by EsampalliSridhar 2 weeks ago

Hello Team,
could you please help me on below issue with date formate at Define statement of FL

.LOGON 127.0.0.1/TDUSER,TDUSER

 

DROP TABLE SAMPLES.EMP_PERS;

 

 

CREATE TABLE SAMPLES.EMP_PERS

(EMP_ID INTEGER NOT NULL

,EMP_NAME VARCHAR(50)

,SALARY INTEGER

,DEPT_ID VARCHAR(20)

,LOC  VARCHAR(20)

242 views
1 reply, 2 weeks ago
TPT Permission error Topic by Cvinodh 2 weeks ago tpt

 

307 views
6 replies, 2 weeks ago
TPT API - Errors when building getbuffer sample Topic by gpolanch 2 weeks ago tpt, tptapi, getbuffer, declspec, dllimport

Hi Folks,
The Teradata TPT API could be very useful in our department to tailor the operation of TPT.  I tried building the getbuffer 64-bit sample program with Visual Studio 2010 and I'm getting 23 errors,  all similar to the following.   I know my way around C++, but dont understand anything about dllimport/dllexport.

230 views
1 reply, 2 weeks ago
TPT Job was terminated even if the "Highest return code encountered = '0'" Topic by ramsesredido 2 weeks ago TPT Job terminated

Hi, I worked in TD Managed Services and I am not good in TPT. One of the users reported that his TPT job was terminated but he can't find anything from the logs that indicates the cause of the job termination. Here is the TPT job log messages.... (original database name and table name are masked).

Gather_Logs.000||start|Start|

teradata-load|start||

236 views
1 reply, 2 weeks ago
TTU 15.10 Windows installation paths Topic by wmmiteff 2 weeks ago sqla, windows, ttu, 15.10

Why was the default installation path for SQL Assistant change to not Teradata SQL Assistant in the path?  Why did the sample ODBC program also get moved to be located in the folder with SQL Assistant?

190 views
0 replies
BTEQ IMPORT SKIP Command Topic by EsampalliSridhar 3 weeks ago

Hello ,
I need help on using BTEQ SKIP Command while Importing data from File to Table, with the help of few posts in this forum i understand that skip command should be used like below

 

.Import Vartext',' file=C:\Users\Sridhar\Desktop\teradata\BTEQ Scripts Outputs\sridhar4.txt, SKIP=10;

 

288 views
2 replies, 2 weeks ago
DUPLICATE RECORDS USAGE Topic by RATHOD 3 weeks ago

Hi All,
I am confused with the usage of multiset table in real time.
what exactly i mean is 
where do we require the duplicate rows and what is the use of complete duplicate row in real time.
why we store complete duplicate records and uses of it???
In which environment the complete duplicate record is useful??
 

228 views
1 reply, 2 weeks ago
TTU for Mac OS Topic by Badri_V23 3 weeks ago #TTU, #Mac, #BTEQ

Hi, Can you please tell me if TTU is available for MAC ? My requirement is to run BTEQ from terminal.app. 
Thanks in advance for your help.

311 views
4 replies, 3 weeks ago
FASTEXPORT with MLSCRIPT option Topic by Gnana Reddy 1 month ago

I have exported 809GB data to data file using fast export with MLSCRIPT option sucessfully. I imported to table again using ml script which is generated by fast export script. I did the row count validation, found 1 record mismatch.
fastexport script:
=========================
.logtable db.log;
.logon xxx/xxxx,xxx;
.BEGIN EXPORT ;

451 views
3 replies, 3 weeks ago
Loading into Views using TPT Topic by hakme 22 Nov 2011

HI All,

 Can we use TPT  load/Update operator and insert into Views instead of Tabless directly? In the Reference document, for the attributes of  Load/Update Operator, only VARCHAR TargetTable is mentioned in the syntax. But in user guide

Basic Processing

Teradata PT can load data into, and export data from, any accessible database object in the

6925 views
8 replies, 3 weeks ago
Can the wallet password resupply automatically using script after server reboot? Topic by s_reddy 3 weeks ago tdwallet

As we need to resupply the wallet password after every server reboot to access the password-protected item values.

Can we automate this process by supplying the passowrd using script?

205 views
0 replies
FastLoad Error -incorrect number of bytes returned Topic by BeingHuman 26 Jun 2009

Error occured while running following script :Error :incorrect number of bytes returned from a File ReadExpected 72,Received : 33Script Source :Chapter 1: IntroductionA FastLoad ExampleTeradata FastLoad Reference 1 – 35Error occured while running following script :sessions 2;errlimit 25;logon tdpid/username,password;CREATE TABLE employee (EmpNo SMALLINT FORMAT ‘9(5)’ BETWEEN 10001 AND 32001 NOT NULL,Name VARCHAR(12),DeptNo SMALLINT FORMAT ‘999’ BETWEEN 100 AND 900 ,PhoneNo SMALLINT FORMAT ‘9999’ BETWEEN 1000 AND 9999,JobTitle VARCHAR(12),Salary DECIMAL(8,2) FORMAT ‘ZZZ,ZZ9.99’ BETWEEN 1.00 AND 999000.00 ,YrsExp BYTEINT FORMAT ‘Z9’ BETWEEN -99 AND 99 ,DOB DATE FORMAT ‘MMMbDDbYYYY’,Sex CHAR(1) UPPERCASE,Race CHAR(1) UPPERCASE,MStat CHAR(1) UPPERCASE,EdLev BYTEINT FORMAT ‘Z9’ BETWEEN 0 AND 22,HCap BYTEINT FORMAT ‘Z9’ BETWEEN -99 AND 99 )UNIQUE PRIMARY INDEX( EmpNo ) ;set record unformatted;definedelim0(char(1)),EmpNo(char(9)), delim1(char(1)),Name(char(12)), delim2(char(1)),DeptNo(char(3)), delim3(char(1)),PhoneNo(char(4)), delim4(char(1)),JobTitle(char(12)), delim5(char(1)),Salary(char(9)), delim6(char(1)),YrsExp(char(2)), delim7(char(1)),DOB(char(11)), delim8(char(1)),Sex(char(1)), delim9(char(1)),Race(char(1)), delim10(char(1)),MStat(char(1)), delim11(char(1)),EdLev(char(2)), delim12(char(1)),HCap(char(2)), delim13(char(1)),newlinechar(char(1))file=insert.input;show;begin loading employee errorfiles error_1, error_2;insert into employee (:EmpNo,:Name,:DeptNo,:PhoneNo,:JobTitle,:Salary,:YrsExp,:DOB,:Sex,:Race,:MStat,:EdLev,:HCap);end loading;logoff;Comments Appreciated

5815 views
9 replies, 3 weeks ago

Pages