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.
2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD- Topic by anilkumar922 29 Jun 2016

Hi all,
When I tried to load the table using mload I'm getting below error
2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD-

could you please suggest how I can overcome this issue??

133 views
1 reply, 3 years 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

13609 views
26 replies, 3 years ago
SQL Assistant: Shortcut creation for "Sel top 10 * from" Topic by poptcorn 29 Jun 2016

Hi all,
I'm fairly new to SQL assistant as I have mostly used SSMS previously. In SSMS you were able to assign queries to shortcuts, and one of the queries I used religiously was "Select top 10 * from". Effectively you could highlight database.table and hit your shortcut and it would run your query on the selection.

104 views
0 replies
Look up in TPT Topic by Niruban 28 Jun 2016 tpt, lookup, Join.

Hi All,
Can anyone kindly let me know is it possible to perform look up in TPT ? I am having around 100K record in a file. I want to load it into a table by looking up another table(by joining a column between file and Table). Can someone kindly let me know is it possible. Thanks in advance!

133 views
1 reply, 3 years ago
TDwallet installation Topic by don.brown 28 Jun 2016

I'm new to using Teradata and would like to use tdwallet in some of the scripts I am creating.  The person who installed our client software (RedHat Linux) did not install tdwallet.  I've read through the installation guide which indicates tdwallet must either be installed before CLI2 or be installed in the /opt/teradata/.... directory path.

116 views
0 replies
FastExport : SET SESSION SEARCHUIFDBPATH Topic by tonez01 25 Jun 2016

Hi,
How do I go about issuing a SET SESSION SEARCHUIFDBPATH for a UIF in a fastexport? 
 
thanks

221 views
1 reply, 3 years ago
How do people handle no file found error in BTEQ IMPORT on Network Attached systems? Topic by TDDeveloper 27 Jun 2016

When the IMPORT file is missing BTEQ issues an error and continues with the next SQL Statement in the Network attached system. In the mainframe systems this ab ends the script.   This behaviour in the network system causes concerns and makes me wonder how other folks deal with this issue.  I don't like the idea of writing a script to make sure that the IMPORT files exist before the BTEQ.  Is th

240 views
4 replies, 3 years ago
TPT Failure : Output schema mismatch - Output varies from Server to Server. Topic by srivigneshkn 22 Jun 2016 #TPT #flat file, tpt schema

Hi All, 

 

I am facing a strange issue with TPT script, I am trying to run TPT script against the same table in 2 different servers.

 

In the First Server :

 

1. TPT executes fine with no issues and exports data to a file.

2. The version of TPT in this server is - Teradata Parallel Transporter Version 14.10.00.10

 

144 views
1 reply, 3 years ago
Need help with Conflicting Column Count in TPT Topic by philxbates 23 Jun 2016

I have a TPT job that is getting the following errors:
TPT_INFRA: TPT02640: Error: Conflicting column count. Source column count (12) Target column count (27).
$EXPORT: TPT12108: Output Schema does not match data from SELECT statement
Job step STEP4 terminated (status 12)
Here is the script below  - it it terminating in STEP 4
 

99 views
1 reply, 3 years ago
Need help with Conflicting Column Count in TPT Topic by philxbates 23 Jun 2016

I have a TPT job that is getting the following errors:
TPT_INFRA: TPT02640: Error: Conflicting column count. Source column count (12) Target column count (27).
$EXPORT: TPT12108: Output Schema does not match data from SELECT statement
Job step STEP4 terminated (status 12)
Here is the script below  - it it terminating in STEP 4
 

107 views
0 replies
TPT Work/error Tables always protected (FALLBACK) ? Topic by stami27 21 Jun 2016 TPTSTREAM, WORK TABLES, fallback table

Hi,
can anyone tell me if I can affect on tptstream
that the work or error  tables could be created as NO FALLBACK?
Currently in the version tptstream1500 (15.00.00.04-1)
the work tables are always created as FALLBACK.
We run with TD 15.00 and tptstream1500-15.00.00.04-1
see image
Thanks in advance

252 views
6 replies, 3 years ago
Tdload failing with TPT02638: Error: Conflicting data length Topic by mani.atkuri 18 Mar 2016

We are trying to use tdload to export data from one system and load it to another in same job.It is throwing error like Conflicting data length for column, source column length is (16)  target column length(8). The data type for this column is decimal(30,0) on both source and target systems.

388 views
3 replies, 3 years ago
Bteq - Maintain Audit Info Topic by tusharzaware1 26 Nov 2015

ALL,

292 views
3 replies, 3 years ago
Not able to download SQL Assistant Topic by pankaj.pandey.007 08 Jul 2015

Hello there,
I have been trying to to download SQL assistant multiple times, however, I am not able to download that and getting error message for unsuccessful downloads.  I am able to download other tools.  So, could you please advise on this?
Thank you in advance!!!
Regards
 
 

773 views
4 replies, 3 years ago
TPT Restartability Topic by srivigneshkn 21 Jun 2016 tpt, restartability, TPT restart, checkpoint

Hi, 
 
I would like to know if there is a way in which i can disable TPT restartability, each time TPT executes i would like to run it from the beginning and it should not restart from the last checkpoint.

185 views
2 replies, 3 years ago
TPT API C program usage Topic by archana_2016 02 Jun 2016

Hi,
Found this piece of code
#include "connection.h"
#include "schema.h"
#include "DMLGroup.h"
using namespace teradata::client::API;
int returnValue = 0;
char* errorMsg = NULL;
TD_ErrorType errorType;
cout << "*** Export Driver Example ***" << endl;
Connection *conn = new Connection();

393 views
12 replies, 3 years ago
TPT Load Operator error table being loaded? Topic by lagerg 10 Nov 2010

Using the tpt load operator i received an error stating my error limit has exceeded. so when i go to look at the error tables is says the select operation is not allowed and that my error table is being loaded. How do i know what the error is if i can't see the contents of the error table? version TPT 12

22953 views
16 replies, 3 years ago
Easy Loader Skip Column in Flat File Topic by toadrw 20 Jun 2016 tdload, easy loader, skip columns

Hello:
Is there a way to only load specific columns from a flat file using tdload?  Say my flat file has five columns, but I only need the last three.  Is there anyway to specify the first two columns as dummy columns or something equivalent maybe in the schema?  Thanks for your help!

201 views
2 replies, 3 years ago
Using Geospacial Import/Export java tools Topic by rupert160 26 Apr 2013

 
I hope this is the right forum for this question. I am working through the Orange book(Teradata Spatial Release 13.0 Users Guide) on this and am stumped with the example code on page 25, likely because it's been a while since I've done java on a windows system...
 

2176 views
4 replies, 3 years ago
Usage of GetRow method in TPT API for exporting table data into csv Topic by archana_2016 17 Jun 2016

Hi
By using Getrow method to export data into a file, resulted in no data in the csv file even though ther is data in the table.
Is there any issue in the format that has to be mentioned while exporting into csv from table data?
Documentation says that getrow and putrow supports indicator mode of format is this the cause for empty file?

146 views
2 replies, 3 years ago
TDCH-TPT Interface Topic by h.r.thejas@gmail.com 14 Jun 2016 #TPT #flat file, TDCH-TPT

Hey Guys,

411 views
9 replies, 3 years ago
Problems with multibyte tdload / TPT19134 !ERROR! Topic by rododendron 15 Jun 2016 tdload, multibyte
[1] $FILE_READER[1]: TPT19134 !ERROR! Fatal data error processing file 'input_import.csv'. Delimited Data Parsing error: Invalid multi-byte character in row 221, col 1.

[2] freetext VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC
197 views
3 replies, 3 years ago
Macro problem in SQL Assistant 13.0 Topic by lucasfilm 26 Apr 2010

I tried out the Macro possibilities inside SQL Assistant. Unfortunately I saved it to the Letter "A". So now the Macro is run everey time I hit this character... Does anyone know how to delete a recorded Macro inside SQL Assistant?

11168 views
8 replies, 3 years ago
Downloading Previous versions of Teradata Studio Topic by myosko1 15 Jun 2016

Is there a place where previous versions of Teradata Studio can be downloaded? I am looking for a version 14.?? instead of the current version 15.

96 views
1 reply, 3 years ago
TPT Data Connector Error reading JSON Topic by babar.sattar 26 Apr 2015 JSON, teradata v15, tpt, data connector operator

Dears, 
I have been unable to read JSON data from a flat file into Teradata v15. Here is my setup.

1930 views
5 replies, 3 years ago

Pages