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.
Teradata Bteq Optimization Topic by ambuj2k50 1 day ago bteq, Teradata Optimization, query tuning

Hi All,
We have a requirement to apply optimization to the exting Bteq Scripts.
What are all possible scope of optimization in a Bteq ?
Is there any best practices document or coding standard guidelines in Teradata Official documentations ?
Thanks,
Ambuj

69 views
5 replies, 1 hour ago
TPT extract failing - TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval Topic by balaji.bgdev 3 weeks ago

I am getting following error while doing TPT extract.
EXPORT_OPERATOR: connecting sessions
EXPORT_OPERATOR: TPT10508: RDBMS error 5407: Invalid operation for DateTime or Interval.
EXPORT_OPERATOR: disconnecting sessions
 
Problem is only when I export  the SQL in the SelectStmt, only for timestamp columns, it is giving this error.

78 views
2 replies, 7 hours ago
TPT Extract - Newline character in data causes number of records mismatch Topic by balaji.bgdev 7 hours ago tpt new_line_character oreplace_function

I have written a script which will generate tpt export script based on the parameters passed.
Since I am generating this script it has to be generic in nature it works for all kinds of table and data type.

20 views
1 reply, 7 hours ago
Exporting to Multiple files in Fast Export Topic by ambuj2k50 6 days ago fast export, Multiple Files in FastExport

Hi  All,

Can we export the output of multiple select statements specified with in .begin export and .end export to multiple outfiles ?
If we create multiple .begin export and .end export blocks with in a single fast export job, are they executed in parallel or sequencially ?
 
Thanks
ambuj

91 views
3 replies, 7 hours ago
Error Starting SQL Assistant v14.10.0.4 Topic by BkAZ 1 day 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'.

 

37 views
1 reply, 1 day ago
FASTEXPORT Looping Topic by Jugalkishorebhatt1 2 weeks ago FastExport IF ELSE condition

Hi All,
Can somebody write a simple FastExport script with IF ELSE condition. THe example given in info.teradata.com. I am not able to understand it.
 
THanks in Advance
Jugal

160 views
7 replies, 1 day 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

 

4383 views
3 replies, 1 day ago
Fastload to non-empty table Topic by padthai_noodles 2 days 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

54 views
0 replies
BTEQ Output: Unicode Column wider as defined in DDL or FORMAT Topic by hans-peter 31 Jan 2012 unicode, utf8, bteq export, export width, column width

my question is about the output of a UNICODE column in BTEQ.

If I select a column defined like this...
   txt VARCHAR(11) CHARACTER SET UNICODE CASESPECIFIC,
.. it is not 11 characters wide , but it is 33 characters wide
(3 times the number of VARCHARs)

The bteq session character set is UTF8: .set session charset 'UTF8';

9918 views
11 replies, 5 days ago
FAILURE 2673 SOURCE PARCEL LENGTH DOES NOT MATCH DATA THAT WAS DEFINED Topic by TD_DEV245 14 Feb 2013 bteq, export, bteq dataimport eventlog, oracle to teradata, failure 2673 source parcel length

Hi,
I am trying to export data from oracle to Teradata.I use the following script to load data to flat file
 
 
 
CONNECT usr_id/pwd
SET SPACE 0
SET LINESIZE 300
SET PAGESIZE 500
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING ON
SET COLSEP '|'
Spool /home/dev_team/oracle_test/test.DAT

3672 views
7 replies, 6 days ago
How to read/retain the Western European characters(Windows-1252) Topic by srikanthTD 1 week ago

Our manufacturing client, uses an Informatica ETL tool to extract the data from the SQL Server through ODBC driver setting the IANAAppCodePage to "Western European (WIndows-1252)" and loads the data to Teradata DW. In this method, the extraction and loading of the data preserves the Windows-1252 characters. Data is perfectly matching when validated between these 2 systems.

53 views
0 replies
Bug in SQL Assistant 15.00 Topic by PeterSchwennesen 1 week ago Bug SQL Assistant 15.00

I think you have introduced a bug in SQL Assistant 15.00, changes I am making to the setup are not maintained after a restart.
The (CTRL+D) to toggle the comment on/off are not predefined. Therefore I am manually doing this setup.

44 views
0 replies
TPT scripts Topic by raju197402 1 week 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,

98 views
1 reply, 1 week ago
SQL Assistant v.15.00 Keyboard Shortcut problems - Comment Topic by PeterSchwennesen 1 week ago SQL Assistant 15.00 TTU

I just installed the new TTU 15.00 SQL Assistant, but I having problems with the keyboard shortcuts. In previous versions the (CTRL + D) turned text to and from comments. If no text selected then the line with the curser was transformed to/from single line comment with “--“, if block of text was selected then it was transformed to/from comment block with “/*   */”.

47 views
0 replies
SQL Assistant v.15.00 Keyboard Shortcut problems - Comment Topic by PeterSchwennesen 1 week ago SQL Assistant 15.00 TTU

I just installed the new TTU 15.00 SQL Assistant, but I having problems with the keyboard shortcuts. In previous versions the (CTRL + D) turned text to and from comments. If no text selected then the line with the curser was transformed to/from single line comment with “--“, if block of text was selected then it was transformed to/from comment block with “/*   */”.

30 views
0 replies
TPT_INFRA TPT01057 Error Insufficient main storage for attempted allocation Topic by fabianoal 1 week ago #TPT, #DataConnector

Hi guys,
I've no ideia of what could be the cause of this error. On TD Docs (http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/General_Reference/B035_1096_112K/TPT.41.1267.html), the explanation doesn't say how to solve the problem.

59 views
1 reply, 1 week ago
RDBMS error 3029: Associated LSN was not found Topic by jorfradec 24 Mar 2012 fastload, error, rdbms 3029

Hello Everyone, I am trying to import data from a flat file to teradata table with FASTLOAD, but after a few seconds throws error. The log :

4572 views
3 replies, 1 week ago
TPT - Scripts from 13.10 doesn't work with 15.10 using named pipes Topic by EricSantAnna 2 weeks ago tpt, ASXMOD, named pipe, TTU15.00

Hi,
I'm was using TTU 13.10 until now, when I upgraded my production machine with TTU 15.00.
But now I'm getting this error:
TPT19435 pmRead failed. EOF encountered before end of record (35)
The process that load data to the named pipes doesn't have time to connect to the pipes.
When I uninstalled 15.00 and installed 13.10 again everything back to normal.

107 views
4 replies, 1 week ago
TPT export timeout issue Topic by mkravikumar 2 weeks ago TPT timeout TPT10508

A TPT extract that creates a very large extract (about 100GB uncompressed size) times out in approximately 1 hour after completing about 40% of the extract.  This has happened repeatedly with different number of instances and different buffer sizes.  This is the largest extract in our system.  We didn't have this issue with any other extracts.
The error is:

64 views
1 reply, 1 week ago
TPT_ISSUE Topic by kusumayella 11 May 2011 fatal eeror, pmopen failed

hi,

anybody has any information about the following error messages.

Any manuals or documents related it ,please share with me.

6641 views
8 replies, 1 week ago
Teradata to Oracle data transfer Topic by raju197402 1 week ago

Currenty I have BTEQ scripts written to move data from schema1 to schema2. However there is a plan to move schema2 to Oracle DB from Teradata. Can BTEQ scripts be used to move data from Teradata to Oracle. OR what is the best alternate for me to achive this please?
Thanks in advance,
Cheers

67 views
1 reply, 1 week ago
Fast load Error Topic by Rohit Ranjan 2 weeks ago

Hi 
I am getting error while trying to run a fastload script. The error says " FDL4822 DEFINE statement rejected".
Below is the script:
.logon abcd/passwd;
.set record vartext " ";
create table abc
(
eno. interger,
ename varchar(20),
dno integer,
sal decimal(10,2)
)
unique primary index(eno);
.DEFINE

83 views
3 replies, 2 weeks ago
XML IMPORT IN CLOB COLUMN USING sql assistant Topic by BITeraData 2 weeks ago IMPORT XML

Hi ,
Sorry if I am posting over wrong thread. 
I am  new to teradata. I am trying to Import XML file in volatile table using SQL ASSISTANT IMPORT UTILITY .
The error I am getting is 'Large Objects and Binary and data values are not allowed in Direct Substitution'
 
replace procedure  XMLDATA()

BEGIN

79 views
0 replies
Fastload Problem: Invalid Fastload Statement Topic by tdfan 1 month 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

172 views
6 replies, 2 weeks ago
SQL Assistant problem Topic by edo-4172 11 Apr 2007

I'm trying to import a CSV file with 4 values/row into a 4 column table - should be pretty easy, but I'm getting the following error:"The positional assignment list has too few values"with this insert statemnent:insert into tableName values (?, ?, ?, ?)I can't seem to find that error message anywhere to diagnose...

20019 views
3 replies, 2 weeks ago

Pages