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 13 Explorer View doesn't show all tables Topic by Kathryn 11 Mar 2010 explorer tree tables

Teradata experts,

I use Teradata Assistant to view our SQL Server. I recently upgraded to v. 13, and I can no longer see all my tables in Explorer view, though I can still query them. It looks like Explorer View is only allowing a set number of tables (around 40).

3 replies, 3 years ago
TPT Export issue -- Not able to export large tables Topic by rnekkanti 20 Apr 2016

Good morning  Gentlemen,
I am facing a weird issue while doing a TPT export on linux . I am facing this issue when I am trying to export more than 4million records(not sure of the row size) .
The same code ran fine for  fewer records (apprx ~ 3 mil) .  

3 replies, 3 years ago
Multi Load UTY0006 Input error in the FIELD command Topic by rajudevolla 09 May 2016 #multiload, #filed error

I am trying to load a table from a file generated from fast export. I am getting below error.

UTY0006 Input error in the FIELD command at position 31: "(15)"
snippet from script 

.field IBNRSkadeestimat *FLOAT(15);
I shall post the complete script tomorrow.
Plz advise.

1 reply, 3 years ago
TPT without schema for STREAM Operator Topic by Naveen_K 09 May 2016

Hi All,
With TTU 14, we could create templates for TPT without the need to specify SCHEMA definition. I was able to successfully implement it for EXPORT, SELECTOR and LOAD operator. However, I am unable to do it for STREAM. I get the following erorr when I try it on the same lines of LOAD. Please find the script and the exact error.

12 replies, 3 years ago
TPT how to combine parameter value with flat file data ? Topic by pelda 10 May 2016

Hi all,
I am using TPT to load flat files into TD, using OPERATOR IMPORT_OPERATOR TYPE LOAD. Like this:
        APPLY (
                'INS INTO ' || @StageDatabase || '.t_payment

1 reply, 3 years ago
Error Starting SQL Assistant v14.10.0.4 Topic by BkAZ 26 Aug 2014 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'.


5 replies, 3 years ago
Issues in Multiload, Insert and Update for Multiple tables Topic by SeenuGuddu 27 Apr 2016

Hi Gurus,
I just need the information about the   Candidate records not applied is 1 and i am not able to find the information about that.

1 reply, 3 years ago
1 reply, 3 years ago
TTU programs fail to open Topic by caryroberts1 14 Aug 2013

Hello everyone,

2 replies, 3 years ago
How to get values from TPT log file? Topic by ajaymathe 03 May 2016

This is my TPT log file
Teradata Parallel Transporter Version
Job log: /opt/teradata/client/14.00/tbuild/logs/mytest-175.out
Job id is mytest-175, running on xxxxxx
Found CheckPoint file: /opt/teradata/client/14.00/tbuild/checkpoint/ mytestLVCP
This is a restart job; it restarts at step MAIN_STEP.

1 reply, 3 years ago
DSA logs Topic by JustMe 09 Apr 2015 DSA, backup, restore, bar

I ran a restore using DSA, and received an error in the postscript.  Where can I find the DSA logs so that I can further investigate my error?  I'm guessing it's on the BAR media server, but I need the directory path.

4 replies, 3 years ago
ARC MultiStream & ARC Server Questions Topic by cmedved 18 Apr 2016 arc, arcmain, arc server

Hi! I have some questions about the arcmain utility that I'm hoping someone could answer... I couldn't find documentation to specifically answer...
1. In order to use the "multistream" option, is an arc server required? (I assume yes)
2. As far as ARC servers go, I believe both TARA and the Data Mover Agent act as arc servers.... correct?

1 reply, 3 years ago
TPT wizard finish button to run is not doing anything Topic by user1973 01 May 2016

I am using TTU 15.00 (TPT wizard) to transfer data from one source to another. There is no rsponse when i click on finish button to run  the job. Did anybody had same issue and how it was resolved?

1 reply, 3 years ago
TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11 Topic by shindeswapnali 10 Sep 2013

Hello Everyone,
I'm loading a Teradata table from an Oracle table using TPT utility.
I am facing below error while running the script:
Teradata Parallel Transporter Version
Job log: /opt/teradata/client/13.10/tbuild/logs/abadap1a-254.out
Job id is abadap1a-254, running on cash070f

6 replies, 3 years ago
Error 1311 : Source file not found error while trying to install SQL Assistant 14.10 Topic by Sharath_007 18 Aug 2015

I am trying to install X86 version of SQL Assistant version 14.10 on a 64 bit OS - windows 7 and i am getting an error stating "Error 1311. Source file not found: C:\Users\User Name\APPDATA\LOCAL\TEMP\wzaf61\TTUExpress\x86\SQL Assistant\Data1.Cab. Verify that the file exists and you can access it."

3 replies, 3 years ago
Problem during acceesing the function created on the top of the JAR file installed on the database Topic by Nishant.Bhardwaj 26 Apr 2016 java, judf, eclipse, Wizard

Hi Tom,

We are in process of creating a Java user defined Function and in order to achieve that  we have deployed the JAR File in the database and

 creating a function/procedure on the top of it  using the below two approaches :


Approach 1) Using the Teradata JUDF wizard Plug -ins in the eclipse  as per below steps:


1 reply, 3 years ago
Meta Data Services Topic by hotspear 30 Dec 2004

Hello,Is there an easy way to import ERWIN models into Teradata MDS?Thanks a lot

4 replies, 3 years ago
Teradata procedure creation || Aquadata studio Topic by ChandanTD 26 Apr 2016

Hi all,
I am using Aquadata studio and was trying to create Procedure and everytime it can not compile and gives error. While that works with "Teradata Studio Express" does any one know or faced similar issues and potential fix? Any help will be greatly appreciated.

4 replies, 3 years ago
TPT api UpdateDriver why fail ?? Topic by Kahan 26 Apr 2016 tpt api, odbc

/* teradata odbc sample */

#include <stdio.h>
#include <iostream>
#include "connection.h"
#include "schema.h"
#include "DMLGroup.h"
#include "sqlunx.h"
#include <sql.h>
#include <sqlext.h>
#include <stdlib.h>

#define TRUE  1
#define FALSE  0

#define MAX_STR  256
#define MAXLINE  1000000
#define MAX_NAME_LEN 50
#define MAXCOLS  2048
2 replies, 3 years ago
1 reply, 3 years ago
Execute Oracle's stored procedures from tpt Topic by py 04 Apr 2016

Hi everyone,
I found a subject where I see it is not possible to delete from tpt on Oracle, but I was wondering if :
it's possible to launch Oracle's stored procedures from tpt ?
Or doing updates on Oracle's tables from tpt ?

6 replies, 3 years ago
Suppressing TPT warnings Topic by kallu2020 20 Apr 2016

Just wanted to check if there is a way to supress warnings arised during TPTLOAD. Our requirement is to receive RC 0.

4 replies, 3 years ago
TPT script generator and PDCR query to find AJI Topic by anand82 19 Apr 2016 tpt, pdcr

Hi Friends,
I am new to this forum.
I hav 2 queries. Kindly request your help.

1 reply, 3 years ago
0 replies
TPT Error loading CSV as Double Quotes Topic by 31_resu 14 Apr 2016 #TPT #flat file

Hello, I'm loading a set of CSV files, some of which will have an occational double quoted text field, with a header. With this examples below, I keep getting a TPT error: DataConnection Error, Delimited Data Parsing error: Column Length overflow(s) in row 1.

7 replies, 3 years ago