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.
MLOAD and loading of: Empty Strings and Null Strings Topic by TDDeveloper 4 hours ago

When loading data from flat files (text ascii) to tables I find that if the file is a delimited file with all the fields defined as VARCHAR for the columns the columns with blank values (all spaces not just two consecutive delimitters for a column which is defined in the target table as CHAR or VARCHAR) are loaded as NULLs wheres if the file is a fixed type file with the layout dfined as CHAR f

15 views
0 replies
TPT ODBC Operator Topic by toadrw 3 weeks ago TPT ODBC Operator

The third party ODBC drivers which are required to stream this data are very expensive.  Please consider in a future release of TTU to allow the ODBC operator to be used with any ODBC driver even if it might be a litle slower than the third party drivers.  Thank you.

183 views
6 replies, 4 hours ago
TERADATA PROFILER QUERIES Topic by RS255043 8 hours ago

Hi All,
Can anyone please help me out in extracting the Teradata Profiler queries? I would like to know what kind of queries does the Teradata Profiler make in detail if possible

11 views
0 replies
Cached credentials causing ABU jobs to fail? Topic by Demosthenes 23 hours ago ABU, backups, error 8017

Hello,
We are running into issues with performing backups using ABU.

We are running version 14 of Teradata on 2 nodes.

The specific issue is that the jobs are failing at the initial logon with the error:

Failure 8017: The UserId, Password or Account is invalid.

 

34 views
0 replies
Mload utility is loading unexpected data into table Topic by ksaikrishna 2 weeks ago Mload utility

Hi All,
I have build below Mload script to load the data into table.Sample data and final output in table  also given below
 
.LOGTABLE tdbname.Logtable001_mld;
.logon <Dbname>/usename,password;
drop table dbname.Employee;
drop table dbname.WT_Employee;
drop table dbname.ET_Employee;
drop table dbname.UV_Employee;

99 views
3 replies, 1 day ago
PT job with Oracle and Informix ODBC operator error Topic by xie407 20 Apr 2010

Hi,erveryone
I have a problem in using TPT. When i use the Oracle or informix ODBC operator in my a teradata PT job i received a ODBC connect error
or ODBC driver error.

The following is my machine description:
1: Redhat linux 2.6.9
2: Software:
Informix CSDK 2.9
Oracle database 10g
Freetds0.82
TTU 13.00.00.2

perl 5.8.8
DBI 1.608
DBD-ODBC-1.23
unixODBC-2.2.14-p2

The following is my test step:
1: When i set $ODBCHOME=/opt/teradata/client/13.0/odbc_32 and $ODBCINI=/opt/teradata/client/13.0/odbc_32/odbc.ini,

5203 views
4 replies, 1 day ago
Script Repository Topic by kmiesse 1 day ago script, share, repository

In a regionalized environment where no single administrator has access to all servers, what tool/repository do you use to share scripts between all administrators?
Thanks!

25 views
0 replies
TPT & Quoted data bug? Topic by danielA 1 day ago

HI 
Im curently using TPT 14.10.00.05 with the default configuration:

Native I/O (non-PIPE)

     Data Format: 'DELIMITED'

     Character set: ASCII

     Delimiter = '|' (length 1), x'7C'

     EscapeTextCharacter = '' (length 0), x''

     Quoted data: No

     OpenQuoteMark = '"' (length 1), x'22'

23 views
0 replies
TPT - passing CHAR SET as variable Topic by Gupta_Pieeater 1 day ago

Hi all
I'm new to TPT so please be gentle with me. I have a generic script whcih will load data files to a Teradata table. One if my files contains Unicode (UTF16) data.
I have successfully laoded the data by invoking a TPT script with the following statement:
USING CHAR SET UTF16
DEFINE JOB EXTRACT_TABLE_LOAD
.....

19 views
0 replies
Teradata tpt Topic by akd2k6 2 days ago

Hi All, I am new to this post and in teradata.

I am trying to create one unix script that will do the table sync from one to another for COB sync with tpt utility.

 

I need script to unload from source table and load to target table by tpt and if possible unload file in delimited.But also I need to generate the dml of the unload file and save it for future use.

132 views
3 replies, 1 day ago
confidence levels wrt date of stats Topic by Rahul A 3 days ago stats

Will optimizer check the date on which the stats are collected before suggesting the confidence levels? 

41 views
0 replies
Different Setting of MLoadDiscardDupRowUPI on Teradata 14.10 and Teradata 12 Topic by skywalker69692 5 days ago

Hi all,
we have just migrated from Teradata 12 to Teradata 14.10, we have a problem with mload with duplicate rows, in the old version (TD12) we skypped this rows due to the setting of the MLoadDiscardDupRowUPI = TRUE.
On new sytem (TD14.10) the MLoadDiscardDupRowUPI = FALSE in the TERADATA 14.10 manual is written:

35 views
0 replies
Trimming spaces from fields Topic by u156531 1 week ago

I'm using SQL Assistant to output the results from a query to a file. Is there an option in SQL Assistant to trim the leading and trailing blanks when sending the SQL results to a file? I was hoping to accomplish this without coding a trim function to every field.    
 
Thanks, Mark

53 views
1 reply, 5 days ago
Fast Export Data File Issue Topic by KamleshKhollam 6 days ago #FASTEXPORT #FEXP

Hi,
I am trying to export below column using Fastexport.
 
SELECT
CAST(COL1 as VARCHAR(4000))
from
TABLE;
 
When COL1 actual size exceeds 2559 chars , new record is getting added after that row having only one alphabetic char. 

48 views
1 reply, 5 days ago
Avoid User to work with Bteq, FastLoad, FastExport Topic by marcodom 1 week ago

Hello,
we have Teradata 13.10, and we would avoid some user to launch Utility like FastLoad, FastExport and Bteq.
Do u know if this is possibile ?
 
thanks 
Marco

55 views
1 reply, 6 days ago
28 views
0 replies
How to skip BOM (Byte Order Mark )in BTeq scripts Topic by arbiswas 2 weeks ago

Hi Experts,
 
My script (generated by automated process) has BOM characters. After generation, I need to run it in Bteq. The script is faling because of BOM character. Is there any command / provison / setting in Bteq so that I can recognize / skip the BOM character while execution.
 
Thanks and Regards,
Arindam

 

74 views
3 replies, 1 week ago
SQL Assistant install error Topic by Greyghost 1 week ago

Hello,
I have downloaded the TTU 15 For Windows zip file from the downloads page.  After unzipping, all the components installed properly EXCEPT SQL Assistant.  I downloaded the .zip file a couple more times thinking something was corupt in the original download.  Unfortunatly, SQL Assistant would not install in any of the downloads.

49 views
0 replies
Errors connecting to SQL Server source using TPT Topic by Campdave 1 week ago tpt, odbc, SQL_SERVER

We are trying our first job with TPT and are having problems connecting to our source database.  We are receiving this error...
TPT17101: Fatal error received from ODBC driver:
STATE=IM002, CODE=0,
MSG='[DataDirect][ODBC lib] Data source name not found and no default driver specified'
I am including copies of the files in use as well as a copy of the output.

41 views
0 replies
bteq utility Topic by prasadh_p 1 week ago

i have inserted n records from a job in bteq. i want to know how many records i inserted through bteq

102 views
3 replies, 1 week ago
named parameter - sql assistant 15.00.00.03 Topic by achikan01 1 week ago

If the “named parameter” you’re attempting to use starts with the letter “B” or “C” it doesn’t work.
 
Here’s a clearer example:
 
Prompts correctly for parameter:
select *
from DBC.ALL_RI_CHILDREN
where ChildDB = '?A'
 
Fails to prompt for parameter:

73 views
0 replies
FASTEXPORT MLSCRIPT Getting junk values like p1<96> Topic by BalaChuppala 1 week ago teradata, fastexport, MLSCRIPT, date, TIMESTAMP FIELDS

Hi,
While exporting data from Teradata table with MLSCRIPT option to generate mload script too. I am getting below strings p1<96> or p1 instead of DATE/TIME/TIMESTAMP fields in layout section.
.....
p1<96>.FIELD COLUMN1 * DATE;
p1<96>p1<96>.FIELD COLUMN2 * CHAR(1);
.......

57 views
0 replies
tbuild with -v option Topic by islanderman 1 week ago

Hi, I wanted to run the tbuild command using the local variables file.  Currently I have it running successfully without the -v option, but the local file is in the same path as the tpt script I'm running.  If I use the -v option with the path to the file and file name, it says it can't find the file, but it lists the directory where the script is running, not where I code the script to check.

37 views
0 replies
TPT and Windows PowerShell Topic by raestadilla 1 week ago tpt, powershell

Hi!
I'm trying to run a TPT job using Windows PowerShell but I'm getting this error:

54 views
2 replies, 1 week ago
BTEQ issue with loading CLOB ! Topic by ma255076 2 weeks ago clob, bteq

hello,
 
im kinda new to the tools, I got an issue running my BTEQ script with a ,CLOB column.
when I run it , I get "Teradata Database returned an invalid LOB token"
__________________

.IMPORT VARTEXT ';' LOBCOLS=1 FILE=GIS_SAMPLE.txt;

.QUIET ON

.REPEAT *

USING(

OBJECTID  VARCHAR (100),

 

39 views
0 replies

Pages