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.
TPT multiple instances using mainframe host (Syntax error). Topic by Om 11 Aug 2011 tpt, mainframe, syntax error, multiple instances

Hi all,
I am doing TPT from mainframe. I have data connector -- producer reading from file and load operator loading the file. The script runs fine without multiple instances. If I add [n] for multiple instances to the script, I get below syntax issue and unable to resolve it. Any help is appreciated.

Below works.

/* JGB. JM */

DEFINE JOB LOAD_TABLE
DESCRIPTION 'LOAD PTY TABLE'
(

7446 views
23 replies, 5 hours ago
Updating an aggregate table from detail table using MLOAD (multiload) or job. Topic by saumil287 1 day ago mload, fload, job

Hi All,
I am new to teradata and done some findings on FLOAD, MLOAD and manually creating a job to load data from 1 table to another.
I am able to do FLOAD, mload for loading the data from 1 table to another table.
The thing is
I am not able to update the aggregate table created from the detail table using mload, I am trying from last 4 days but with no success.

107 views
5 replies, 15 hours ago
BTEQ IMPORT EXPORT DATA Topic by Jugalkishorebhatt1 3 days ago BTEQ IMPORT EXPORT DATA

Hello All,
When i ran the below code, all the 3 rows got exported to a text file. From there on, im importing it in the same script. When i do so the 1st record of the exported data is not getting loaded in the Target Table.
.run file=./logon.txt
.SET WIDTH 25;
.SET PAGELENGTH 50;
.SET SEPERATOR 0;
.SET PACK 2;
.SET SUPPRESS ON; 

73 views
3 replies, 1 day ago
SQL Assistant Web Edition .. discontinued? Topic by danielA 4 days ago sql assistant web edition

Where can I find the installation for this ?
Or has it been discontinued ? I cant find it on v14 or v15 of the tools & utilities

71 views
2 replies, 2 days ago
TPT Job Variables Error: Missing Concatenation Topic by BLaughner 21 Aug 2011 tpt job variables

Hi,

I am creating a job variables file for my TPT scripts. However, I am seeing a strange error when tbuild reads the job variable file and I don't know how to resolve it.

Here is the job variable file I am using:

MyTdpId = '10.7.4.107'
,MyStageDB = 'edw_stg_db'
,MyTempDB = 'edw_stg_db'
,MyLoadDB = 'edw_dev_db'
,MyUserName = 'MyUser'
,MyPassword = 'MyPass'
,MyTargetTable = 'edw_stg_dev.CURR_CVUEPISICCODE'
,MySourceFile = 'CURR_CVUEPISICCODE.dat'

4153 views
2 replies, 3 days ago
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.

17693 views
5 replies, 3 days ago
Verify backward and forward compatibility of TTU 14 Topic by hobrob 3 days ago version compatibility, TTU14.10

Hi,
Our risk people want assurances that TTU 14.10 will work with our current RDBMS version 13.10 and will still work after our forthcoming upgrade to 15.10. I'm pretty sure the answer is generally yes but some features may not work etc, but is there a compatibility matrix that I can use to provide them with more detail?
Many thanks
Rob

27 views
0 replies
Load qouted data with delimiter chanrater in values Topic by hakme 4 days ago

Hi,
Can we load the below data using Bteq/Mload 13.0 . Please suggest
3 columns with ',' as delimiter and enclosed by quotes with ',' and qoutes possible in values. Can escape the quotes in the values with another quote.
Values:
"abcdef","ghi,jkl","mn""o,p"
Thanks

49 views
1 reply, 4 days ago
View Joining two fields of a table Topic by P547853 4 days ago

Hi All, 
I have a table with Calendar Month(ex.10) & Year(ex.2014) as two different fields ( Month Number & Year).
But i will have to create a view on this table where user can just pass one value ex. 201401 where 2014 has to be passed to year column and 01 to month column of the table and fetch the respective record.

70 views
3 replies, 4 days ago
Problem in importing data from text file to teradata database using bteq Topic by kishu 01 Mar 2008

When i export the data from a table to any text file using bteq then data is written correctly in text file. But when i again import the same data from text file (skipping the title line) to same table, data is inserted successfully but some garbage value instead of the actual data.

30932 views
6 replies, 4 days ago
Loading Mutiple Oracle source table into 1 tale in Teradata Topic by JKerena 5 days ago Load Utility

Hi,
I have a requirment to move the data from 16 instanaces in Oracle to 1 table in Teradata using single script.
Lets say i have a customer table in 16 different schemas/instances with same layout in Oracle, my requirment is to load all these 16 customer table from Oracle into one single customer Table in Teradata. What utlity should i use and how to acheive this.

60 views
1 reply, 5 days 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.

303 views
4 replies, 1 week ago
TPT deadlock Issue. Topic by achikan01 1 week ago #TPT

When trying to insreat into log table getting deadlock on TPT script

63 views
0 replies
TPT OLE DB and TPT moving to version 15 Topic by brcriss 2 weeks ago

I uninstalled all old versions and installed the 15 Client tools.  I installed this: OLE DB Provider for Teradata and I can no longer find the OLE DB wizzard.  When I try to open my amj files, there is no program. 

86 views
2 replies, 1 week ago
TPT19434 pmOpen failed Topic by brcriss 1 week ago

TPT19434 pmOpen failed. General failure (34): '//OLE_DB_AXSMOD_Jobs/Job is not present in the Access Module Job.
I get this error running a TPT load.  It appears to continue, but I don't like this error in there and I'm not sure I can live with it.  I have 14.10 OLE DB installed.
 
 
the rest of the output:

Jobs/Job is not present in the Access Module Job.'

73 views
1 reply, 1 week ago
TDSQLA 14.10 - Cut & Paste Issue Topic by TDW 3 weeks ago SQLA 14

Hello,
I can no longer call myself a newbie (2 year anniversary with my job), but I am still green on some issues.
I searched this site - as well as the Internet - and could not find an answer.

120 views
2 replies, 1 week ago
Which utilities to choose when compared to TPT Topic by Jugalkishorebhatt1 1 week ago TPT and utilities

Hello All,
On what basis does should a developer opt for TPT when compared to the other utilities
From the following which is the best to use in which situation:
TPT LOAD vs FASTLOAD
TPT EXPORT vs FASTLOAD
TPT UPDATE vs MLOAD
TPT STREAM vs TPUMP.
 

63 views
1 reply, 1 week ago
Multiple queries in one connectiong through Teradata studio / Eclipse plugin Topic by gstoel 2 weeks ago sqlassistant, TeradataStudio, eclipse

Hi,
In SQL Assistant it is possible to run multiple queries in parallel (after setting some of the settings correct). I prefer to use Teradata Studio, the eclipse plugin, but couldn't find a setting to do so. Is it possible anyway to run multiple queries in parallel? I now have to wait for my queries to finish before I can continue.
Regards,
 
Geoffrey

87 views
2 replies, 1 week ago
Using the Append statement to write the results from 2 queries to one txt file. Topic by u156531 1 week ago

Hello,  I need to write/export the results from two or more queries into a txt file. The I'm attempting to accomplish this using the Append statement. So I'm appending two queries to execute after one another. When I submit the queries through the Execute button the first query runs and produces output however the second query never starts and I get an query failed error message.

71 views
1 reply, 1 week ago
Get a Thousand Separators Using BTEQ Export Script Topic by murthy1234 2 weeks ago
(FORMAT 'G999999999D99' )

Hi
I am using BTEQ script to export the data returned by a query (say like below) to a file called sample.txt
sel
salary
from employee
Now I am getting the sal as 100000.but I want the output in my sample.txt as 100,000with thousand separators).
I tried to use the FORMAT G9999999999D99.#

332 views
5 replies, 2 weeks ago
TSET Topic by shirsat17laxmi@gmail.com 2 weeks ago

Hi All,
Can anybody guide me regarding Teradata system emulation tool. Is it allowed to change number of nodes, PEs, Amps using TSET.
Thanks in advance :)
Cheers,
Laxmi

86 views
3 replies, 2 weeks ago
ABU 14.10 table restoring error Topic by calvinlkn 3 weeks 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.

80 views
2 replies, 2 weeks ago
EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement Topic by Minatkumarverma 06 Jun 2014 tpt, EXPORT_OPERATOR, UTLITIES, tools

Hi ,
The subject might be old, but I was unable to figure out my solution, so please take a look once.
Trying to TPT using the below Script :

738 views
7 replies, 2 weeks ago
Quoted qualifiers in TPT Topic by TDRookee 2 weeks ago

Hi,
 
I have a pipe demimited file which looks like below and also some fields are starting and ending with quotes. But as you see the highlighted part there is a qualifier with in a text field and my TPT script is not able to parse the file.
I am using Teradata 14

71 views
2 replies, 2 weeks ago
TPT script to load data with embedded qualifiers Topic by TDArpit 2 weeks ago tpt, qualifier, error

Hello,
We are trying to load a pipe delimited flat with qulaifiers as " utlizing the TPT script but our loads seems to be failing since there is a embedded " in certain fields. Its just sending the error record to a error file and failing after that. Do we have some option or add on in the TPT script to load this data as is.

204 views
7 replies, 2 weeks ago

Pages