Teradata Debugger 1 topic, activity 2 weeks ago
Topics cover the Teradata Debugger product family. For articles, blogs and more, see the Tools section of the site.                   hide recentshow recent
Welcome!
24 views
0 replies
View all Teradata Debugger topics
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.
$LOAD: TPT10507: CLI Error 302: CLI2: BADBUFRQ(302): Invalid buffer size. Topic by padhia 1 day ago

Using TPT loader and DataConnector version 15.10.01.00 produce above error. I am using following script to load about 100M rows
 

10 views
0 replies
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

1608 views
22 replies, 2 days ago
TTU (ARCMAIN) for Linux Topic by GS255023 2 days ago

I want to install TTU Linux (ARCMAIN) on Linux. But I was not able to find it on Public domain.

12 views
0 replies
Installing TTU on Windows Server 2012 R2 Version 6.3 Topic by upriser7 2 days ago #TTU, #WindowsServer

Hey, there is a requirement for a user to install TTU on Windows Server 2012 R2 Version 6.3  So, is the process of installing TTU on Windows Server 2012 R2  similar to installing TTU on our local Windows Laptop/Desktop?  Or is there any other extra tools/softwares we need to install specifically for installing TTU on Windows Server? 

9 views
0 replies
Plugin for Eclipse Topic by DocPhil 3 days ago eclipse, teradata plug-in for eclipse, dtp

There appears to be a problem with the plugin for Eclipse when attempting any of the following:
-Creating a SQL Editor. So for example, right-click on an object and generate DDL.
-Creating a Teradata Project
 

6 views
0 replies
14 views
0 replies
How to change a date column to show only month and year Topic by mrodri81 08 Sep 2010 teradata; date conversion; columns

Hello,

I have a date column in my table reporting_date (date format 'YYYY-MM-DD')
I would like to change the column so I just show the month and year, I do not want the actual day of the month.

I have tried this

select income_month (format 'yyyy-mm'), income from D_CFAEISDB.FTP_INCOME

35281 views
8 replies, 3 days ago
Record rejected to error table if date feild is enclosed with double quotes Topic by Muzammil126 2 months ago

Hi,
 
I am trying to load below two records using TPT( version 15.10.00.00) and able to load succusfully second record but first record is going to error table. The same records gets loaded in TPT version 14.00.00.08 .
File :
"1194","N",,"20150422","","20150422"
"1195","N",,"20150423","","20150423"
 

348 views
20 replies, 3 days ago
TPT Wizard driver error Topic by blackrooster 07 Jan 2015 tpt wizard, odbc

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

 

891 views
2 replies, 5 days ago
TDLOADER Topic by hemanth07 6 days ago

Hi,
 
can we use tdloader to unload data to a file, if so can you please point me to some documentation.
 
Thanks for your time and help
HK
 

17 views
2 replies, 5 days ago
No menu bar in SQL Assistant 14.01 Topic by YHKim 28 May 2013

I have installed the SQL Assistant 14.01. After that, I customised the menu. I continuously removed the menu bar. Finally my SQL Assistant 14.01 have no menu bar. I tried to install the SQL Assistant 14.01 many times. But the menu could not restored. And it is still no menu bar. How can I restore all the menu bar in my SQL Assistant 14.01 ? Please give me guide.

2949 views
3 replies, 1 week ago
Multiload failure Topic by tusharzaware1 2 weeks ago

Script:

 

.LOGTABLE BKP.dwlogtable;

.logon 127.0.0.1/tduser,tduser;

 

.begin import mload tables BKP.customers1;

 

.layout custlayout;

.field ID * varchar(2);

.field NAME * varchar(6);

 

.dml label custdml;

insert into BKP.customers1 values(:ID,:NAME);

 

33 views
1 reply, 1 week ago
TTU Installation Problem Topic by deansiewert 1 week ago

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.

22 views
0 replies
TPT - Delimited Data Parsing error: Invalid multi-byte character Topic by Gupta_Pieeater 19 Mar 2015 tpt multibyte load multi-byte

I am developing a TPT load (Unix envirnoment) for a data file (with UTF-8 encoding) to populate a Teradata table with columns defined as VARCHAR() CHARACTER SET UNICODE. One character in the data file is causing my load to fail. If I remove this character the load completes successfully.

1698 views
9 replies, 1 week ago
BTEQ .SET RECORDMODE ON; in Unix creating illegible characters. Topic by charabon91 2 weeks ago BTEQ EXPORT FILE

I am trying to export an SQL query from a table - this is in a standard query format i.e.
INSERT INTO DATABASE_A.TABLE_B
SELECT
COUNT(*)
FROM DATABASE_A.TABLE_A
WHERE TABLE_A.REF_1 = 0;

24 views
1 reply, 1 week ago
TPT load script fails with incompatible message Topic by boriscb 27 Nov 2013

Hi,
Your advice with the following will be greatly appreciated.
I am using the TTU 14.10 set of tools with a Teradata DB 14.0.2.11
With the OLELoad tool, The Fastload utility works perfectly but for some reason the TPT utility fails with the following message:

3203 views
14 replies, 2 weeks ago
Underflow and Overflow conditions for BTEQ Topic by tulasirn 2 weeks ago BTEQ import overflow

Hello All,
I'm trying to import a tab delimited file into a table.
Overflow condition = number of delimited values of record in import file > number of columns in table
 Behavior – BTEQ silently ignoring the overflow columns that are at the end of the record.

21 views
0 replies
TPT casting w/ format issues Topic by logc 23 Mar 2011

Hi,
Is it possible to format a float when casting in a TPT script? I've tried several iterations using casts w/ formats in my TPT select statement and get the below error. I'm trying to format floats so don't land in scientific notation format in my text file. Thanks!

from TPT select (works find in queryman):
CAST( ( X1 (FORMAT '-(11)9.9999999')) AS CHAR(20) )

This is the TPT error that is returned (error goes away if I remove the format from the cast).

Error:
Teradata Parallel Transporter Version 13.10.00.02

8279 views
4 replies, 2 weeks ago
Using name of Flat File in TPT Load Topic by lopesl 12 May 2011 tpt load

Hi All, I'm new here..

I would like to know if you can help me.

I need to do a script TPT for load Flat File in a Teradata Table.

My problem is:

I have to store the name of flat file that I load, in a column of target table.

How i can do this ??

In this case:
DEFINE OPERATOR FILE_READER
TYPE DATACONNECTOR PRODUCER
SCHEMA Trans_n_Accts_Schema
ATTRIBUTES
(
VARCHAR PrivateLogName = 'dataconnector_log',
VARCHAR DirectoryPath = '/teradata_dev2/',
VARCHAR FileName = 'CG1_0780_20110505121803_5201000_7000.DAT',
VARCHAR Format = 'Delimited',
VARCHAR TextDelimiter = 'TAB',

12336 views
12 replies, 2 weeks ago
FastLoad UTF8 charset issue - for special characters Topic by vprem.vasu 15 Oct 2015 fastload, utf8, charset

Hi,
I am using charset as UTF8 in fastlload, whatever record has special character like box went to Error table (ET). Pls refer the attachment for the sample issued value. Kindly help me how to handle this situation, we need to load data as it is there in source.
Thanks,
Prem.

435 views
5 replies, 2 weeks ago
Why USEXVIEWS=ON parameter has no effect on Teradata Studio ? Topic by vincent91 2 weeks ago

We cannot replace Teradata SQL Assistant and Teradata Administrator by Teradata Studio because the USEXVIEWS parameter has no effect on Teradata Studio.

63 views
3 replies, 2 weeks ago
Multiload + LDAP Topic by tusharzaware1 2 weeks ago

All,
 
I am running muliload job. We have LDAP concept here. Our ID's are in sync with LDAP authentication.
When i am running my mulltiload job I am getting below error:(Also PFA attachment)
UTY1006 CLI error : 244, MTDP : EM_SSOLOGONFAIL(224): SSO logon failed by gateway.
Please help!!!
 
Thanks,
Tushar

66 views
4 replies, 2 weeks ago
TPT Export to a Data Connector question Topic by Tuen 2 weeks ago

I'm trying to setup a generic macro to generate TPT Exports that write to a DataConnector to generate delimited flat files.  The issue i'm running into is that the Export operator appears to have to have a schema defined since it is a producer.

12 views
0 replies
TPT 15.00 is loading NULL data Topic by Shrinivas.Sagare 2 weeks ago

Hello,
We are using TPT 15.00.00.03 (LOAD operator) through informatica 9.6.1 hf2. It is giving weird behavior. It is loading first 5-6 columns correct data and all rest of columns in table as NULL. No error message.
If I run same job in other Teradata system where I have TPT 14.10.00.14 with same version of informatica (9.6.1 hf2), it is loading all data correctly.

21 views
0 replies
How to archive in ARCmain. Topic by wa255015 2 weeks ago arcmain

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

45 views
2 replies, 2 weeks ago

Pages