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 ERROR : "UTY4019 Access module error '4' received during 'File open' operation: 'Requested file not found' " Topic by SYAMALAMEDURI 1 day ago

Hello Everyone,
 
One of our workflow (using MLOAD loader connection) used to fail with the error "UTY4019 Access module error '4' received during 'File open' operation: 'Requested file not found'  File Name : "

20 views
0 replies
TDSQLA 14.10 - Cut & Paste Issue Topic by TDW 1 month 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.

146 views
3 replies, 1 day ago
Hiding password in mload script Topic by kishu 27 Jul 2008

hiI want to hide the password in logon string.please suggest me the way i can do this.Thanks

11954 views
4 replies, 2 days ago
TPT export large table to smaller text files Topic by brockappleby 3 days ago tpt, export, Flat Files

Hello good people
I have a table of ~77 million rows that I need to export to fixed width text files, however I need to impose a limit of 5 million rows per file.
I am currently achieving this with "SELECT * FROM MYTABLE QUALIFY ROW_NUMBER() OVER(ORDER BY COL1 ASC) BETWEEN 1 AND 5000000"

48 views
1 reply, 2 days ago
Stored procedures - calling tables and views Topic by dodo1992 01 Jun 2013 stored procedures, dependancy

I have to analyse 250 stored procedures to identify the tables and views they are using to get data from or inserting into. Is there a view of achieving this other than manually trying to eye-ball code. Even 80% accuracy will suffice. Will be grateful for any directions. Thanks.

869 views
2 replies, 2 days ago
which Teradata process is using this table Topic by v_gabrielli 1 month ago Vinny

need your help,
does anyone have an SQL that lists the processes that are using a specific table.  I would like to enter the table name 
and the results would show me which process has/using that table.. 
 
thank you

85 views
2 replies, 2 days ago
Help with metadata services Topic by DHbrmtnz 20 Jul 2014

hi,

 

In the company we recently used the tool "metabrowse" to upload data to MDS, but by mistake remove a class within the tool "metabrowse" we have the support of the repository,

 but I require to know if using the backup repository, we can see class eliminated again within tool "metabrowse". thank you

71 views
1 reply, 2 days ago
Teradata Administrator References and Procedures Topic by PeterSchwennesen 4 days ago Teradata Administrator References Procedures

When inside Teradata Administrator it is possible to right click on an object and select “References”, to get a list of object where it is used.

61 views
2 replies, 3 days ago
Problem to load data into teradata table by using tpt Topic by kusumayella 03 Dec 2010 tpt

hi,

I am trying to load data into my teradata staging table,
I defined ACTIONTIMESTAMP column as TIMESTAMP but my input file have data like '20101203151515' for ACTIONTIMESTAMP
column but I can load '2010 12 03 15 15 15'.
for that in tpt script I have used substr function just to add space between while inserting into the staging table.
I got an error with the code :3760:String not terminated before end of text.
Do I need to add anything else or is there any other way to aceive the same.
Can any one faced this issue,please share with me the solution if u have any.

6963 views
5 replies, 3 days ago
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'
(

7475 views
23 replies, 5 days ago
Updating an aggregate table from detail table using MLOAD (multiload) or job. Topic by saumil287 1 week 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.

216 views
5 replies, 5 days ago
BTEQ IMPORT EXPORT DATA Topic by Jugalkishorebhatt1 1 week 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; 

96 views
3 replies, 6 days ago
SQL Assistant Web Edition .. discontinued? Topic by danielA 1 week 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

83 views
2 replies, 1 week 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'

4161 views
2 replies, 1 week 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.

17703 views
5 replies, 1 week ago
Verify backward and forward compatibility of TTU 14 Topic by hobrob 1 week 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

34 views
0 replies
Load qouted data with delimiter chanrater in values Topic by hakme 1 week 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

51 views
1 reply, 1 week ago
View Joining two fields of a table Topic by P547853 1 week 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.

74 views
3 replies, 1 week 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.

30943 views
6 replies, 1 week ago
Loading Mutiple Oracle source table into 1 tale in Teradata Topic by JKerena 1 week 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.

66 views
1 reply, 1 week 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.

318 views
4 replies, 2 weeks ago
TPT deadlock Issue. Topic by achikan01 2 weeks ago #TPT

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

75 views
0 replies
TPT OLE DB and TPT moving to version 15 Topic by brcriss 3 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. 

90 views
2 replies, 2 weeks ago
TPT19434 pmOpen failed Topic by brcriss 2 weeks 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.'

76 views
1 reply, 2 weeks ago
Which utilities to choose when compared to TPT Topic by Jugalkishorebhatt1 2 weeks 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.
 

74 views
1 reply, 2 weeks ago

Pages