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.
TPT 14.10 problems loading data from SQL Server using TPT Wizard Topic by WB255000 5 hours ago TPT 14.10

Hi.
Recently I made an version upgrade to TTU 14.10 but I'm having some problems that I didn't have in 13.10.
I tried to use the TPT Wizard to create a load Job to retrieve data from "SQL Server", but the Log File says that no rows are exported. That is weird because If I submit the SQL in the source, It returns data.

11 views
0 replies
TPT log file location Topic by stevehager 12 hours ago TPT ; private log;

I've been running TPT on one (SLES-based) server for quite some time.  I decided to move some existing (running) scripts to a new (SLES-based) server, but TPT fails with:

49 views
1 reply, 8 hours ago
Issues with TPT when escape character comes in the data Topic by abhipsa_beuria 3 days ago

Hello,
I am using TPT to export data. I am using delimiter as |  and escapetextdelimiter as \ . Also I have arequirement to replace \ with \\ when \ comes in data. So I tried using oreplace function in my view. After using that any row which has \ in the data the next delimiters got missed.
 
Example:

77 views
2 replies, 1 day ago
bteq export and import for _ET dataparcel Topic by tdurbin 20 Feb 2012 bteq, export, export/import, _et

Hi,  I'm new to Teradata and need to do the following:

I'm on a Unix system, using verision 13.0. 

We're inserting data into the "Stage" table from a delimited text file (bell is the delimeter \007)

1.  export the dataparcel field from the _ET table to a file  (delimited text if possible)

2.  fix the contents of the file

8557 views
23 replies, 1 day ago
Help with metadata services Topic by DHbrmtnz 2 days ago

hi,

 

In the company we recently used the tool "metabrowse" to upload data to MDS, but by mistake remove a class within the tool "metabrowse" we have the support of the repository,

 but I require to know if using the backup repository, we can see class eliminated again within tool "metabrowse". thank you

28 views
0 replies
Informatica 9.1 with Teradata V14 using TTU 13 Topic by rychitre 4 days ago

Does Informatica 9.1 works with Teradata V14 using TTU 13? Has anyone have similar architecture?

30 views
0 replies
Scroll Bars in SQL Assistant 15.0 Topic by levinra 4 weeks ago

How do I change the appearance of the scroll bars in Teradata SQL Assistant 15.0?  There's nothing for me to grab, just a solid line.  I don't remember it looking like that when I installed it, so I must have accidentally altered their appearance, but I don't know how to put it back.
 

92 views
1 reply, 4 days ago
SQL Assistant key not found error Topic by EdSteck0717 5 days ago

I am currently using SQL Assistant version 14.10.0.02 installed on a MS Windows 7 client and am receiving the following error dialog:
Key Not Found Parameter Name: key
Unexpected Error. Refer to the following file for details:
C:\Users\<username>\AppData\Roaming\Teradata\SQL Assistant\SQLAError.txt

27 views
0 replies
TPT - LOAD TWO FIELDS IN ONE COLUMN (concatenate) Topic by dreis 1 week ago tpt load, two fields one column, concatenate

Hi everyone,
I need to load a column that is a concatenation from two fields of a file. One field is a date other is time type. I would like to load both resulting in a timestamp field but i wanted to do it during the tpt load. Is it possible? How can i concatenate two fields in the insert statetment?

81 views
3 replies, 6 days ago
Fastload Problem: Invalid Fastload Statement Topic by tdfan 1 week ago

Hi Guys,

 

Need your help to figure out where the problem is.

 

Thanks in advance!

 

 

**** 18:33:38 Teradata Database Release: 14.10.02.08

**** 18:33:38 Teradata Database Version: 14.10.02.08

**** 18:33:38 Number of AMPs available: 180

**** 18:33:38 Current CLI or RDBMS allows maximum row size: 64K

82 views
5 replies, 6 days ago
Unity Datamover standalone to update standby database Topic by mt186042 6 days ago

Standby Teradata Database,
 
I was recently commissioned by a client in Australia to do the high level design for their DR standby database.  The main requirement was to use Datamover in standalone mode.  
I found out later that the method we came up with to do this job was very similar to another job that had been done in the US.

46 views
3 replies, 6 days ago
TTU 15.0 Topic by raj_tddba 6 days ago TTU 15.0

Hi guys,
 
I have installed TTU 15.0 on my machine connection to TD DB 14.10. when i am using sql assistant to connect with database its hanging and its for very log period.
Is this bug? i have not seen this issue in existing TTU version except TTU 15?
Any insight?
 
Thanks, - Raj

29 views
0 replies
Trying to import data into my table Topic by tmcrouse 1 week ago

I have a csv file and I am trying to import the data into my table and it says invalid query. I am very new to Teradata.
Here is my code:
[code]
.import data file=c:\users\ad36742\documents\communication.csv,skip=3
.quiet on
.repeat *
using comm_id(integer),
comm_type varchar(50)
insert into dl_qpt_cqe.communcation
(comm_id,

55 views
2 replies, 1 week ago
Studio Express installer can't find java Topic by ronnotel 20 Aug 2013

I'm installing Studio Express nt-x8664 on Windows 7 (64bit). In a command window, "java -version" returns "java version 1.7.0_25".

900 views
4 replies, 1 week ago
SQL Assistant error? "Submit only the selected query text, when highlighted" not working Topic by BkAZ 1 week ago sql assistant, highlight

(version 14.10 of SQL Assistant)
Is there a bug with this option?
Tools, Options, Query: "Submit only the selected query text, when highlighted" 
If I have a line with -- at beginning (standard SQL comment syntax since always) and I highlight ONLY the text following the -- characters, it will not execute ONLY the highlighted text (error is "Query is invalid").

56 views
1 reply, 1 week ago
*** Warning: RDBMS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS. Topic by newb1 1 week ago BTEQ RDBMS CRASH


Your use is subject to the terms and conditions of
            the click through agreement that brought you to this
            screen ("TERADATA EXPRESS") EVALUATION AND DEVELOPMENT
            LICENSE AGREEMENT), including the restriction that this
            evaluation copy is not for production use.
TDExpress14.0.3_Sles10:~ # bteq
70 views
1 reply, 1 week ago
SQL Assistant - History window no available Topic by WB255000 26 Sep 2013 sql assistant, History error, History window

We've installed the "SQL Assistant 13.10.0.05", but when we want to view the history window this is disabled.
Some web sites told us we need to run the AccessDataBaseEngine.exe and we did it, but It didn't work.
Could you help us with this?
Thanks.

534 views
1 reply, 1 week ago
Download TTU v 13.10 Topic by rychitre 2 weeks ago

From where I can download TTU v 13.10? I see only TTU v 15 available to download?

61 views
1 reply, 1 week ago
Question on Failed TPT Load Topic by islanderman 1 week ago

If a TPT load fails and the restart is not working can someone tell me what has to be done to get the load to start over again.  I know that I have to drop the load table and the tables with the extentions _ET and _UV.  I believe there is a lock file placed somewhere, but can someone clarify that?

37 views
1 reply, 1 week ago
Speed up imports in BTEQ or SQL Assistant Topic by Crow.King 01 Feb 2012 bteq, sql assistant, import, slow, upload

When using BTEQ or SQL Assitant to upload data into tables, I'm only getting about 2 records per second speed. Unfortunately, I don't have access to Fastload. I know its not the network as my down speed is blazing and Oracle is uploading normally. All of the files are in pipe delimited text and I've tried a few variations, but the speed doesn't change.

17341 views
11 replies, 1 week ago
FASTLOAD ERROR Topic by zeesh49 1 week ago #Fastload

Dear All,
I am trying to fload a flat file, the file contains 44 columns (44 'Û' delimiters). 
Following is the sample header and data rows (header is removed from the actual file being loaded):

HEADER:

72 views
5 replies, 1 week ago
TPT Script to load multiple data types from a delimited file Topic by andydoorey 2 weeks ago tpt

I have a file to load which doesn't seem to be in too unusual a format, but I'm not sure if it is possible to load it using TPT.  Can anyone let me know whether this is possible, or if I have to write some unix script to edit the file before I can load it.
 
The data looks like this:

SVC_NAME,OPUNIT_NO,DEPOT_CODE,OPU_TYPE,REGION_NUMBER

"Aberdeen",7240,"051","M",4

49 views
0 replies
3706 expecting something between beginning of the request and SELECT Topic by AB75151 2 weeks ago

SELECT * FROM CUST.MEMBER
This simple SQL runs just fine if I type it on SQL Assistant. But if I copy paste this from notepad SQL assistant throws this 3706 error. There are times, to debug a code, I need to copy paste few 100 lines of working code to SQL assistance and it makes me type the whole code to execute it. what a waste of time :( did someone experience this before?

57 views
0 replies
Download TTU v 13.10 Topic by rychitre 2 weeks ago

From where I can download TTU v 13.10? I see only TTU v 15 available to download?

26 views
0 replies
Issues happening after TTU13.10 upgrade Topic by Dominiq 2 weeks ago TTU 13.10, ab initio

Recently we installed TTU13.10 upgrade as many users were facing temporary connectivity issues for ABI and unix servers.
Post upgrade we are getting to hear all new things from users.

35 views
0 replies

Pages