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.
TPT10508: RDBMS error 2583 error in teradata tpt Topic by aneelkumar04 1 day ago dnoeth, ulrich, Adeel Chaudhry, Raja_KT, Fred, CarlosAL

Hi,
I am trying to insert data from prod to dev by using TPT Update operator. By mistake i have deleted all error tables including work table, log table.
Agin when i submit the script am got TPT10508: RDBMS error 2583 error in teradata tpt Error. Can you please suggest me how  resolve this issue.
Error :
UPDATE_OPERATOR: preparing target table(s)

18 views
1 reply, 12 hours ago
fastload error message: Not enough fields in vartext data record number: 1 Topic by mrodri81 31 Aug 2010 teradata, fastload, error, sql, vartext

Hello everyone,

I am new to teradata and I am trying to upload a file using fast load.
When I run the batch file I get the following error in the log file:

Not enough fields in vartext data record number: 1

In the teradata table, I have varchar (100) for all the colums, so not sure what is going on.

My script is the following:

sessions 1;
errlimit 10;
logon DWSANA/username,password;

set record vartext;
begin loading D_CFAEISDB.FTP_profile_fl01 errorfiles d_cfaeisdb.Err1,d_cfaeisdb.Err2;
RECORD 1;
DEFINE FILE=\\is-m-54lxx-fs12\DBP_PLANNING\Fast Load\FTP profile.txt;

10712 views
16 replies, 12 hours ago
Question about Teradata Hadoop Connector Topic by crorella 1 day ago

Hi,
after using the Teradata Hadoop Connector to load some data to a table in Teradata I noted the parameter "sourcepaths" assumes the folder is located in the hadoop machine assigned to the machine where I'm running the command.

14 views
1 reply, 14 hours ago
8 views
0 replies
where to download the installation for Teradata Schema Workbench Topic by wenjin 1 day ago

Do you know where to download the installation for Teradata Schema Workbench?
Thank you!
 

19 views
0 replies
TTU Installation on Linux RedHat Topic by islanderman 1 day ago

Can anyone tell me how I can get hold of the TTU download for Linux RedHat?  I've seen a few posts for requests but the only answers I've seen is pointing to documentation about the installation.  The only available download is for Windows.  I wanted to try to setup BTEQ but without the TTU download I can't do it.  Thanks.

24 views
0 replies
BTEQ - Parametrize output File Topic by alvaroapi 2 days ago bteq, export, Parametrize output file

Hi all,
 
I need to export data from Teradata to text files (Windows).
The first one is a .BAT file that only call the BTEQ application:
1 - bteq < file.sql
 
The second one exports the data:
2 -
.logon myhost/myuser,myuser

 

.EXPORT FILE=out.txt

select col1, col2

from table1;

 

.EXPORT RESET

38 views
1 reply, 1 day ago
Fastloading csv file with double quotes Topic by Koentje 1 week ago fastload Teradata quotes separated

How are you fast loading a csv file where the fields are enclosed by double quotes?
Eg.
“Field 1”;”Field 2”;”Field 3”
“Fi””eld 1”;”Field “”2”””;”Field 3”
What is the method you’re using?

51 views
2 replies, 2 days ago
Show View Definition - Teradata SQL Assistant 14.01.0.04 Topic by chris b 6 days ago

Hi
After installing a new teradata SQL assistant (version 14.01.0.04) I can't activate "show view definition" with a right click anymore, but my collegues can, using the same version of the SQL assistant.
Does anyone have an idea???
Thx

49 views
2 replies, 2 days ago
SQL Assistant Copy Errors 14.10 Topic by vbdcb 6 days ago ttu 14.10 error

I have been having significant issues with simple windows functionality in SQL Assistant. Trying to copy text in the editor window throws the following error: 

*******************************************************

4/10/2014 3:20:03 PM

SQLA Version: 14.10.0.2

Driver Version: Teradata.Net 14.11.0.1

42 views
2 replies, 2 days ago
IMPORT issue with Teradata SQL assistant. Topic by Rafe 5 days ago Import using SQL Assistant.

Hello,

 

Some Background:

I am trying to IMPORT a .csv file using SQL assistant... there are few columns which doesn't have values so ideally it should load NULL values (?) in the table, BUT... its loading ZEROS (incase of numeric fields) instead of NULLs. (incase of char fields its loading SPACE/Blank)

 

62 views
2 replies, 3 days ago
SQL ASSISTANT Topic by mahadevan.sureshkumar 1 month ago

Hello,
Can we run TERADATA Utilities such as BTEQ, MLOAD through SQL Assistant?
-Suresh.
 

96 views
2 replies, 5 days ago
TPT Topic by Gnana Reddy 1 week ago

Can any one suggest how to load duplicate records using TPT.
I have tried with TPT LOAD operator into MULTISET with NOPI table. But all the records are inserted into ERR1 table. Since load operator using FLOAD.
As UPDATE operator will use MLOAD operator, Please provide the sample code with UPDATE operator to load flatfile with ~ delimiter having duplicate records.

60 views
3 replies, 1 week ago
BTEQ Import Invalid Date Issue Topic by taruntrehan 2 weeks ago bteq, invalid date, import data

Hi All,
I am trying to port data from a flat file to TD via BTEQ.
The table definition is :

172 views
2 replies, 1 week ago
TPT load to table which contains special characters in name and column names Topic by Darych 2 weeks ago 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");`

131 views
6 replies, 1 week ago
Error: "specified DSN contains architecture mismatch" Topic by WAQ 1 week ago

Hi,
I have recently downloaded TD 14 Vmware on my windows 7 (64 bit) along with the all the client utilities installed as well.

34 views
1 reply, 1 week ago
Fast Export and Fast Load Error Topic by Jugalkishorebhatt1 2 weeks ago fastload, fastexport

Hello All,
Below script i exported the data using Fast Export and tried to import the data using Fast Load. While doing so. I am getting a error in FastLoad. Plz help me understand. Where i am going wrong.
 
FastExport Script
.LOGTABLE DB.errors;
.LOGON jugal/jbhatt,bhatt;
.BEGIN EXPORT;

105 views
5 replies, 1 week ago
USE OF SERIALIZE ON in TPump Topic by TD_mc.ph 1 week ago tpump, Serialize ON, Serialize OFF, blocking, locking

Hi guys,
just want to ask the purpose of Serialize ON in TPUMP. How is it related to the types of blocking or locking if it is not specified in a TPUMP? Are there any circumstances that would affect the blocking or locking?
 
Thanks! :)
 

39 views
1 reply, 1 week ago
Different Modes and Format Topic by Jugalkishorebhatt1 2 weeks ago Modes and Format

Hello All,
I am new to teradata.
Could u help me understand the advantages of using different MODES and FORMAT in Fast Export and Fast Load.
MODE RECORD[INDICATOR] FORMAT BINARY[FASTLOAD,TEXT,UNFOMAT]
 
Thanks in Advance.

92 views
5 replies, 1 week ago
Fastload Utility Locks due to abort- .FILLER command- possible solution? Topic by Dominiq 3 weeks ago #Fastload, #Locks, #utilities, #FILLER

While using utilities like Multiload, when any job ends abnormally, Teradata still holds locks and we get error 'Table is being mLoaded'.
While in case of FastLoad/TPT end, we get error 'Table is being loaded'. Even after dropping error/log/work tables, we still get same error. What I do now is just drop these tables, and recreate them.

112 views
4 replies, 1 week ago
TPT : Infrastructure Setup Errors Topic by taruntrehan 2 weeks ago TPT Errors, TPT01155, TPT02057, TPT01006, TPT01008, TPT02429

Hi All,
I am trying to run a TPT script and facing the following series of errors :

38 views
1 reply, 2 weeks ago
TPT - Assigning default values for columns not present in a file via TPT to load a table Topic by tddev1984 2 weeks ago

Hi,
I am trying to use TPT utility to load data from a file into a table. I create INPUT, SELECT and INSERT schemas a part of this and it usually loads the file into the table without any issues.

66 views
1 reply, 2 weeks ago
TTU 14.10 downloaded from TD Dev Exchange corrupts Windows 7!!!!!! Topic by garrett@data-design.com 09 Oct 2013 urgent

I downloaded TTU 14.10 for Windows from TD Dev Exchange.  After unpacking the zip file, I looked for setup.exe as directed by the web page.  There are multiple versions of that executable in each of the sub-folders for the tools, but no setup.exe in the TTUExpress folder.  However, there are 3 executables, TTU_Base.exe, TTU_DBM.exe, and TTUListProducts.exe.  I guessed and ran TTU_Base.exe.  Aft

617 views
3 replies, 2 weeks ago
End of Record marker with TPT Topic by tstrick4 4 weeks ago tpt, delimiter, load, csv, export, ttu

I have a CSV file that I'm attempting to load via TPT.  I have created the CSV file in Excel.  When I try to load the file with the appropriate number of delimiters, I am getting a BUFFERMAXSIZE error.  When I add another delimiter to the end of each record, the file loads just fine.  This isn't a huge issue, but I'm just confused and would like to understand more about end of record markers.

151 views
9 replies, 2 weeks ago
TPT Error using DATACONNECTOR PRODUCER Operator Topic by Jugalkishorebhatt1 3 weeks ago tpt

Hi All,
Please help me where I am going wrong. The error im getting is relating to the FileName given.
This is the First time i am using TPT.
Below is the TPT Script:
 
DEFINE JOB FlatJOBS
DESCRIPTION 'FLAT FILE FORMAT'
(
DEFINE SCHEMA Schemas
DESCRIPTION 'Schemas'
(
EmpId INTEGER,
EmpName VARCHAR(10)
);

146 views
8 replies, 2 weeks ago

Pages