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.
ABU 14.10 table restoring error Topic by calvinlkn 1 day ago

Hi, 
I have installed ABU14.10.
-- To backup a table for testing by option "Backup Selected Objects" , tried to backup particular table for testing.
Steps :
1. Select option "Backup Selected Objects" for backup testing table test123
2. Drop the table test123.

29 views
1 reply, 8 hours ago
Facing TPT error while lading data from flat file to Teradata Topic by richa.prvr 4 days ago

Hi,
Below is my TPT script to load data from flat file to Teradata 15.00.
DEFINE JOB LOAD_TPT_TEST2
DESCRIPTION 'LOAD A TERADATA TABLE FROM A FLAT FILE'
(
DEFINE SCHEMA FILESCHEMA
(
EID  INTEGER,
EMPNM VARCHAR(10)
);
DEFINE OPERATOR DATACONN_C2
TYPE DATACONNECTOR PRODUCER
SCHEMA FILESCHEMA
ATTRIBUTES

61 views
3 replies, 9 hours ago
Getting error on Fastload..."nvalid state for Load" Topic by vniri.teradata 10 Mar 2009

Hi , I am getting the following error when doing a fast load.**** 15:21:00 RDBMS error 2635: Error tables are invalid OR TFL_SALE is in an invalid state for Loaddoes this mean the is a fastload lock on the table.Need help in solving this...Thanks Nick

4927 views
4 replies, 10 hours ago
Restarting Fastload if we have error with the source data file Topic by ppad001 24 Mar 2013 fload

Hi,
I had encountered today a failure with fastload. There was some issue with the source file for which the fastload got paused. I corrected the data and restarted the run, but it didnt succeed.
I got the error:
**** 21:36:29 RDBMS error 2634: Existing ERROR table(s) or Incorrect
              use of unit_Inf  in  Fast Load operation.

1384 views
2 replies, 10 hours ago
Teradata FLOAD error table 1 creates unwanted newlines in Dataparcel data. Topic by yugeshshrestha 1 week ago #Fastload #Dataparcel #FLoad error table

I have a fastload utility to load data from txt file into Teradata table. I am trying to get the data from Teradata error table 1 into a structured format in a separate file. But Currently, the data generated from each Data Parcel for each row inserts a new line character after every date type data.
For eg: If my source file has following data

88 views
3 replies, 10 hours ago
TTU 15 Installed, SQL Assistant Error Topic by robinsu 23 May 2014 ttu 15

After install TTU 15, The SQL Assistant show Error:
=== Entry Point Not Found ===
The procedure entry point __crtInitializeCriticalSectionEx could not be located in the dynamic link library MSVCR110.dll
 
OS is Windows 7.
Are you have similar experience on TTU 15? Please advise me and thanks a lot.

158 views
1 reply, 1 day ago
TPT 64bit on Windows 7 sits on FINISH indefinitely Topic by vnaicker 30 May 2013 TPT 64bit

I have TPT 14.10 64bit installed with PATH pointing to JRE 32bit. When I define a job, it goes until FINISH but does nothing when clicked. I have Run Job Now checked already. Removing the check from there does not do anything either (save). I have to only cancel, when I get a warning that the job is not saved. What am I missing? My machine is Windows 7 (64bit).
Thanks.
Venky

1522 views
14 replies, 1 day ago
Teradata Decision Experts (TDE) Topic by maniamenon 4 days ago

Can anyone help me some documentation on Teradata Decision Experts (TDE)?
Mani

32 views
1 reply, 3 days ago
Error Starting SQL Assistant v14.10.0.4 Topic by BkAZ 3 weeks ago special directory, My Documents, sql assistant

I cannot start SQL Assistant, and the error message is:

System.IO.DirectoryNotFoundException: Could not find special directory 'My Documents'.

 

115 views
2 replies, 4 days ago
Error Starting SQL Assistant v13.10 Topic by stansle 06 Apr 2012 sql assistant v13.10, special directory

I receive the following error when starting SQL Assistant v13.10 in Windows 7 Professional. 

Could not find special directory 'My Documents'.  Unexpected Error. ...

Has anyone seen this error and can assist.

Thanks.

Len

 

4435 views
4 replies, 4 days ago
DBSCONTROL dont display data Topic by gdvaldesh 4 days ago dbscontrol display

Hi, a few days i opened dbscontrol to view a flag, "GENERAL DISPLAY" and showed me the information correctly, but now that I try to enter does not show me anything, the command continues processing but never ends.

 

The other commands continue works (MODIFY, QUIT, HELP), DISPLAY command only don't works.

 

35 views
1 reply, 4 days ago
TPT - Oracle Date to Teradata Timestamp(0) Topic by jgleaso 17 Apr 2007

I just upgraded from ttu8.1 to ttu8.2. I am loading a Teradata table via the TPT wizard from an Oracle table via fastload (load). When selecting the source table and fields, the tpt wizard does not know how to define the Oracle date field and requires me to edit the definition from a dropdown list. Has anyone else experienced this?Every combination that I have used from the dropdown list has failed when trying to load to a Teradata timestamp(0) field. Has anyone else had any success moving data from and Oracle DATE to Teradata TIMESTAMP(0)? If so, a sample script would be greatly appreciated! I suspect it might be an ODBC problem. I am selecting the 'Oracle Tables' option from the source versus the 'ODBC DSN' option. The 'ODBC DSN' option always me to see the source tables in the schema I select, but fails when I try to access the fields in any table.Thanks in advance for any input you may provide,jgleaso

23571 views
5 replies, 4 days ago
TPT scripts Topic by raju197402 1 month ago

Currently I have TPT scripts which transfers data from schema1 (Teradata  box1) to schema2 (Teradata box2). There is a plan to move the contents of Teradata Box2 to Oracle.
Will the TPT scripts written can be reused to tranfer data to Oracle. If so does it require any major changes to be done to make it work for Oracle. If not what is the alternate way?
Thanks,

138 views
2 replies, 5 days ago
TPT Export Error TPT01403 Topic by stat 1 week ago TPT Errors

Hello, 
I am trying to export data from a Teradata table wm_ad_hoc.Table1 using TPT to a delemited file format in  UNIX. That table has around 11 million rows and the export works fine using BTEQ.
But when used TPT, only 8 million rows got exported and then errored out with the message

53 views
1 reply, 6 days ago
Downloads from downloads.teradata.com are blocked by Norton Topic by satrn_grl 1 week ago

I've tried to download TTU 15 Installer from https://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows-installation-package
which leads to d289lrf5tw1zls.cloudfront.net
 
Which is blocked by Norton:
http://safeweb.norton.com/report/show?url=d289lrf5tw1zls.cloudfront.net

62 views
3 replies, 6 days ago
Fastload to non-empty table Topic by padthai_noodles 4 weeks ago

Hi,
What is the exact reason we can fastload to non-empty tables. I know we cant update the existing tables but what stops in just inserting to the non-empty table.
Regards,
Am

175 views
3 replies, 1 week ago
BTEQ Data Truncation while Exporting Topic by stat 1 week ago bteq export

Hello,

 

109 views
4 replies, 1 week ago
Query not working in Teradata SQL Assistant with Teradata .Net while the same query is working with ODBC connection & vice versa Topic by EUsha 1 week ago

I am facing an issue where i have a query which has the WHERE clause defined as WHERE sample_dt <> '01/01/2010' (that is with format 'DD/MM/YYYY'). This query when run in  TD Sql Assistant with ODBC connection provider was running perfectly but the same query when with Teradata .Net provider it was failing with below error:

101 views
2 replies, 1 week ago
Easy Loader Target Working Database Topic by toadrw 1 week ago easy loader, tpt

Hello:
I posted a few weeks ago here just for some background.
http://forums.teradata.com/forum/tools/easy-loader-issue 
I'm finding I can't use Easy Loader to load a Target table unless that table is created under my default logon directory and that table is qualified in the command line with my default database.  

34 views
0 replies
Multiload Error Topic by megamic 09 Oct 2008

HiI am trying to get Mulitload to read from a UNIX fifo which I will write to from an external script. I have specified the record format to be VARTEXT.

17592 views
4 replies, 1 week ago
How to find the number of columns in each table in Teradata ?? Topic by info9891 1 week ago teradata, find, number, of, columns, table
75 views
3 replies, 1 week ago
Installing TD 15.0 Topic by David_Angevine 1 week ago Install TD 15.0

I am running into a problem with downloading TD Studio 15 in that the 2nd step asks for my JRE directory.   I know that I have JAVA 1.7, but I cannot find the right directory to move the install forward.  Please advise.

56 views
1 reply, 1 week ago
218 views
1 reply, 2 weeks ago
10061 WSA E ConnRefused: The Teradata server is not accepting connections Topic by nagendratrpth 2 weeks ago 32-bit connection

Hi,
I downloaded td-ttu-15.00_for_Windows on my personal computer and created a DSN using my public ip over internet as IP server for DSN.
While connecting the DSN on TDA i am getting "10061 WSA E ConnRefused: The Teradata server is not accepting connections".
Thanks,
Nagendra

61 views
0 replies
Issues in querying Informix Database using Teradata SQL assistant via ODBC Topic by verma_a 2 weeks ago

I am trying to query an Informix database via an ODBC created on IBM Informix ODBC driver version 4.10.00.15364 from Teradata SQL assistant.

86 views
1 reply, 2 weeks ago

Pages