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
I had a similar problem when we first upgraded to Version 12 utilities. The fix that worked for me was to switch from using the Oracle provider in ...
chris34662002
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
Please note. ...there is no knowledge about...
Janne_Myntt
TPT Stream Operator Bug? Topic by joemm 04 Dec 2009
Tags:
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
Why use 2 targets? You can do updates and inserts in one TPT Stream target. It's probably locking the table with the 2 targets, if you aren't ac...
SuperJetJoe
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
you need to press (Enter) on the last record. Because on the last record Fastload fails to find a EOF character & terminates abruptly. So you ne...
tolik
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
It looks like the output has been edited to remove timestamps and such. It would be best to provide as much of the output as possible without any e...
Lavanya
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
you can write the data into Excel XML format, which supports multi-sheet, convert the following simple program at below link into perl should be a ...
ChinaGuy
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
Tags:
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
This probelm "SLQ Assist 13. I get a 'HYT00: Query timeout ­expired'" was resolved by changing my Teradata ODBC Driver Options by ''removing the ...
benpearson
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
Steve, Thanks for your inputs, turns out the DBA had not deleted some of the error tables which led to this failure. Sorry for the incorrect refer...
Ankit Gandhi
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
I also have the same problem . But according to your solution i am unable to find those files in my system32 folder. so how can i solve this proble...
RP
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
I dont know why you selected this topic to post your question. Open up a new topic for your question. also, the information you have provided is ...
df
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
There is an attribute AccountId, for both DDL and load operators. You can use that to specify the account string.
df
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
Actually, in TPT the number of bytes allocated for a DECIMAL(10,0) is different than what Oracle allocates and returns through odbc drivers. TPT OD...
df
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
Thanks Walter, i'll look into that.
atlzbest
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
Did you find answer? I am facing the same issue.
rain512
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
I am having the same problem. I did not see the problem ­until I ran a particular query that I was debugging (I got an ­untranslatable character ...
ccurry
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
Thanks for the reply Ravi. That's a good example to use INMOD. i would surely go thru the document for INMOD. Just one more help. can you pleas...
Protegrity
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
Hi, I am fairly certain that if you read through the documents that are supplied on the TD12 demo DVD, it mentions having to download a compiler as...
boicool
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 need to completely turn off UAC, then install and run TD as normal
ChinaGuy
You must login to create a new forum topic.