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 create a new forum topic.

Fast Load I/O error Topic by abhisiue 07 Jan 2009 Hi,
I am trying to load oracle table named TST1 and its data into teradata v12.0. I am using OleLoad.
Datatypes in pl sql for CONFIG_ID and MD_SOURCE_SYSTEM are NUMBER(15) and rest of them varchar2.
when i run the OleLoad tool it does following:

.SET SESSION CHARSE...
2242 views
1 reply, 1 day ago
A few questions about Teradata SQL Assistant/Web Edition version 13.00.00.02 installation to windows 2008 Topic by Janne_Myntt 1 week ago Hi, Do you have any experience about installing TSAW to windows 2008 server. I have read Teradata manual B035-2407-088A and there is now knowledge about installing TSAW to windows 2008. Before installing TSAW to server it needs Microsoft Internet Information Services, ASP.NET for Windows, Micro...
102 views
1 reply, 1 week ago
TPT Stream Operator Bug? Topic by joemm 04 Dec 2009 Hi, We're using TPT Stream operator through Informatica 8.6. The operation I am trying to do is quite simple. Here is some outlines 1) I have a table with Identity column defined as UPI. 2) We're planning to do insert and update to the table based on Identity column 3) In Informatica, I u...
356 views
6 replies, 1 week ago
fastload script insert phase error. Topic by teradataguy 27 Feb 2008 Hi all teradata gurus,

This fastload example gives an error in the as shown below, any ideas how to correct it,

**** 15:35:51 Number of recs/msg: 414
**** 15:35:51 Starting to send to RDBMS with record 1
**** 15:35:51 I/O Error on File Read: 35, Text: EOF enc...
24265 views
6 replies, 1 week ago
special characters Topic by ratu 1 week ago Hi, I have a dilemma…

I have a table A that has some special characters in a column aa. When inserting into table B, the following SQL gives the untranslatable character error

Insert into B.bb
sel
CASE
WHEN A.aa IS...
83 views
0 replies
Test teradata database status Topic by Paddu 1 week ago Hi All

I have requriment to test a database is up or down.

I selected BTEQ to do my testing and below is my logic. As bteq is continously trying to logon, my script is running continously with out existing.

BTEQ Interactive Mode:

$
$
103 views
0 replies
FLOAD CANNOT OPEN FILE,RETURN CODE 12 Topic by simranjitsingh86 2 weeks ago Cannot open file:
'file'
====================================================== =============
= =
= Logoff/Disconnect =
= ...
72 views
1 reply, 2 weeks ago
Building excel sheet from bteq Export having more then 65K rows Topic by d.choudhary 2 weeks ago Hi All, I have requirement where I have to build(genrate) an excel sheet from a table but it can have more then 2Lakh - 3Lakh records and as we all know one excel sheet cant have more then 65K records so more then 65K records should be on next sheet in the same excel sheet and this process wi...
152 views
5 replies, 2 weeks ago
Building excel sheet from bteq Export having more then 65K rows Topic by DP 2 weeks ago Hi All,

I have requirement where I have to ­build(generate) an excel sheet from a table but it can have more­ then 2 -3 lakh records and as we all know one excel sheet­ cant have more then 65K+ records so more then 65K records­ should be on next sheet in the same excel sheet and...
58 views
0 replies
No Views or Tables in SQL Assistant 13.0 Topic by dmarp 2 weeks ago Hi, I'm running Win7 64bit and am connected to a v6.2 Teradata db in SQL Assistant 13.0, however none of the Views or Tables are showing up in the Data Source Explorer. I can query the Views just fine; just can't see them in the tree view. Any thoughts/suggestions? Thanks in advance!
100 views
2 replies, 2 weeks ago
Fast Export not returning all rows Topic by John Rowan 2 weeks ago I have just upgraded my Teradata client utilities to version 13.0 and my fast export processes are not working correctly. Specifically, fast export is not returning all of the rows from the source table. Examining the log file does not help much, but it does appear to be an incomplete log file....
92 views
0 replies
Mload failure Topic by vickyejain 2 weeks ago All,

I'm facing an issue with mloading of a table via Informatica - I get a "Broken Pipe" error which I believe is a very common error. I tried the usual steps of releasing the mload lock and deleting the work tables but the issue is still unresolved. I'm working in a shared and cont...
198 views
3 replies, 2 weeks ago
Error loading ICU library (v12 windows) Topic by zsolt 14 Jul 2008 Hi,

After installing v12 tools on my PC (op: windows XP SP2) and then running bteq or fastload I get the following error message:
"CLI error: CLI2: ICULOADERROR(510): Error loading ICU library."

I have tried almost everything with no success. I have uninstalled com...
8841 views
3 replies, 2 weeks ago
Loading space into a Decimal(15,2) column Topic by Anand JP 05 Sep 2006 Hi,

We are facing issues in loading a text file from a Mainframe system to Teradata database using Mulitload. Here are the details.

Problem Description :
In the text file that we are loading most of the records has "spaces" instead of packed decimal values for t...
23279 views
7 replies, 2 weeks ago
ACCOUNT STRING FOR TPT OPERATORS Topic by rluebke 13 Jul 2009 Anyone know how to set the account string in TPT for the DDL and LOAD operators? Normally this is the 3rd parameter in the LOGIN statement in BTEQ. Is this the same as the AccountID in those operators?
1317 views
2 replies, 2 weeks ago
TPT, Oracle, ODBC, load operator Topic by janus 7 weeks ago Hi All,
I'm trying to use TPT to load data directly from an Oracle table to Teradata. BUT.. I'm having a little problem with numeric data types.
In oracle, I have a lot of different NUMBER(10,0) and other columns.
Lets take one for example a column called DURATION. The actual da...
242 views
1 reply, 2 weeks ago
TPUMP ERROR DUE TO CONTENTION Topic by BI_JOY 2 weeks ago Hi All,

I hope I am posting my problem in right forum.

I have two datastage jobs which inserts data into a same table using tpump utility. One of them fails when both the jobs triggers at the same time.

These datastage jobs first deletes data from the table ...
78 views
0 replies
Where do i download TTU 13.00 64 bit from? Topic by atlzbest 3 weeks ago Hi all, I cannot seem to locate the TTU pack 13.00 64 bit online for download? We have the 12.00 CD but it doesnt have 64-bit install. Is there someplace online i can download the TTU 64 bit? It seems like a very common download but i cant seem to locate it in the downloads section. Thanks!
81 views
2 replies, 2 weeks ago
mload in Informatica truncates float data type Topic by rychitre 2 weeks ago I have float data type in sql server (SS) and float in Teradata (TD). I am reading from SS and pass directly to TD. If I use odbc, data moves as it. eg 1.2 moves as 1.2 in TD. But if I use mload in Informatica, it rounds data. So, 1.2 becomes 1.0, 1.5 becomes 2.0.
Does anyone know how to f...
89 views
0 replies
mload rounding decimal data Topic by johns_maverick 4 weeks ago I have a decimal (17,2) field which has a default value of 999999999999999.99 (9(15).((2)). When mload'ing that data to teradata the value is being rounded to 1000000000000000.00 (1 followed by 15 0's.00) which is causing a decimal overflow error. Also the default value is being modified.
I...
310 views
3 replies, 2 weeks ago
SQL Assistant 13 won't run second query Topic by Draven 4 weeks ago After installing .NET 3.5 and Mapinfo 10 SQL Assistant 13 will freeze when running a query a second time from the query window. You can open a new window run a query, and then the next query will freeze. It just keeps showing the query is running, but in the back ground the query has completed. ...
137 views
1 reply, 3 weeks ago
Tpump utilty Topic by Vinay Kumar 5 weeks ago Hi All,

Can tpump load data on a real time basis? as per the document provided by teradata we can use tpump for real time dataware housing .

in tpump we read from a file which is in a predefined format. so does that mean that while tpump is reading from a file we can hav...
314 views
2 replies, 3 weeks ago
Error while executing stored Procedure in BTEQ Topic by tmrmodest 3 weeks ago Hi all,
I have installed Teradata Demo version 12.0 in my PC. While i compiled a simple stored procedure the following error was prompted.
Error: C/C++ compiler is not installed.

Does C/C++ compiler is required for running Stored Procedure?
Where can i get this comp...
160 views
1 reply, 3 weeks ago
Teradata Forums migration imminent Topic by Host 3 weeks ago Dear users,



Per recent communication, we are pleased to announce the consolidation/merger of the Teradata Discussion Forums and the Teradata Developer Exchange Forums. The integration of the forums will create a single location - http://forums.teradata.com - for you to ...
88 views
0 replies
Will Teradata work in Vista??? Topic by MKK 3 weeks ago HI All.... Will Teradata work in Vista installed PC....? If yes ..pls lemme knw........
75 views
1 reply, 3 weeks ago
You must login to create a new forum topic.