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.
Sql assistant complaining about dot net framework Topic by pramodnair65 10 hours ago

Hello,
 
I am trying to install the Teradata utilities package but the sql assistant wont install. It keeps complaining that the dotnet framework aint present but I have installed the same. Please help!!!!!
 
Regards
Pramod

1 view
0 replies
Teradata Wallet Topic by Cesco 1 month ago

Hello!
I'm trying to use teradata wallet for encrypt user password on some script.
I have insert an item named PWD_SSF_DEV and then I've crete the script deptquery.txt.
This is the source code:
.logon 11.51.71.141/US_FND_SSF_DEV,$tdwallet(PWD_SSF_DEV)
.logoff
.exit

131 views
5 replies, 14 hours ago
TPT - BUFFERMAX error Topic by arfsoft 20 hours ago TPT 19003, tpt, BUFFERMAXSIZE

Hi all, I'm pretty new to using TPT and am working with Version 14.00.00.07.  In the last week or so I have been finding that almost all of my jobs involving a simple load from one csv into one table are failing.

16 views
1 reply, 11 hours ago
TPT/Easy Loader delimiter Topic by logc 2 days ago

Do TPT and Easy loader (13.10.00.02, moving to 14.10 later this year) support the use of ASCII control characters as delimiter? If so, how would x01 (Crtl A) be represented in the TPT script/tdload command? Tried below with no luck:

tdload -h td -u loaduser -p xxxxxx -f file1 --TargetTable mytable -d '\001'

 

30 views
1 reply, 1 day ago
TPT - Assigning default values for columns not present in a file via TPT to load a table Topic by tddev1984 3 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.

102 views
3 replies, 1 day ago
SELECT statement in a TPT EXPORT script Topic by terasum 2 months ago tpt, fastexport

Hi,
 
I am trying to export data from a sql uery to a file using TPT Export operator.
My Sql query is running fine in sql assistant but when it is run through TPT it is giving non-existent syntax errors.
I have used two single quotes wherever I have one single quote in my query.
My requirements:
1) Want a TAB delimited file

165 views
4 replies, 1 day ago
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

14875 views
6 replies, 1 day ago
Multiload error Topic by tdice 15 Jan 2011

Below is the multiload script
-----------------------
.logtable mload_log_tab;
.logon a/b,pwd;

.BEGIN IMPORT MLOAD TABLES
b.EMP, b.EMP1
WORKTABLES b.WRK_EMP
ERROR TABLES b.EMP_ET
,b.EMP_UT;

.LAYOUT FILEIN;
.field empno * char(10);
.field ename * char(30);
.field DeptNo * char(10);
.field salary * char(10);

.dml label emptab;

INSERT INTO b.EMP
(empno,ename,DeptNo,salary)
values(:empno,:ename,:DeptNo,:salary);

.dml label emp1tab;
UPDATE b.EMP1 SET SALARY= :SALARY+2000 ;

7714 views
9 replies, 2 days ago
TTU Installation on Linux RedHat Topic by islanderman 1 week 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.

87 views
2 replies, 2 days 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;

10829 views
17 replies, 1 week ago
TPT10508: RDBMS error 2583 error in teradata tpt Topic by aneelkumar04 1 week 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)

72 views
1 reply, 1 week ago
Question about Teradata Hadoop Connector Topic by crorella 1 week 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.

46 views
1 reply, 1 week ago
SQL Assistant Tree Collapse/Expand Icon? Topic by spockihana 1 week ago

Does anyone know how to change the database tree collapse/expand icon in SQL Assistant?
I've noticed in screenshots that the default is the plus/minus, but mine shows a triangle. I've changed to every SQL Assistant theme and it doesn't change. I'm running SQLA 14.10 on Windows 7.
I've been going through the settings xml but not having much luck so far.
Thanks :-)

9 views
0 replies
30 views
0 replies
where to download the installation for Teradata Schema Workbench Topic by wenjin 1 week ago

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

39 views
0 replies
BTEQ - Parametrize output File Topic by alvaroapi 1 week 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

55 views
1 reply, 1 week ago
Fastloading csv file with double quotes Topic by Koentje 2 weeks 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?

62 views
2 replies, 1 week ago
Show View Definition - Teradata SQL Assistant 14.01.0.04 Topic by chris b 2 weeks 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

71 views
2 replies, 1 week ago
SQL Assistant Copy Errors 14.10 Topic by vbdcb 2 weeks 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

60 views
2 replies, 1 week ago
IMPORT issue with Teradata SQL assistant. Topic by Rafe 1 week 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)

 

82 views
2 replies, 1 week ago
SQL ASSISTANT Topic by mahadevan.sureshkumar 1 month ago

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

104 views
2 replies, 1 week ago
TPT Topic by Gnana Reddy 2 weeks 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.

66 views
3 replies, 2 weeks ago
BTEQ Import Invalid Date Issue Topic by taruntrehan 3 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 :

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

144 views
6 replies, 2 weeks ago
Error: "specified DSN contains architecture mismatch" Topic by WAQ 2 weeks 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.

44 views
1 reply, 2 weeks ago

Pages