All Forums

Covers Teradata-developed applications such as TRM, DCM, etc. For articles, blogs and more, see the Applications section of the site.

You must login to post to the forums.
Getting a Error in BTEQ Import Topic by Jugalkishorebhatt1 06 Feb 2014

Hi Guys,
Below is the code i trying to run to import data throught BTEQ import
.logon home/jbhatt,jugal
.import vartext ',' file=/home/jbhatt/insert.txt
.quiet on
.repeat*
using
f1 (VARCHAR(40)),
f2 (VARCHAR(40)),
f3 (CHAR(40)),
f4 (CHAR(4)),
f5 (VARCHAR(40)),
f6 (VARCHAR(40)),
f7 (VARCHAR(40)),

1224 views
3 replies, 5 years ago
Run an teredata query on linux Topic by vijaysharmapc@gmail.com 11 Feb 2014 bteq, linux

Hi ,

I am in badly need of some direction here :) there is an batch file(.bat) which runs an teredata query on windows, but for some reasons i will have to use Linux server from now on

current set up 

**test.bat***

 

echo off

bteq < D:\commands.txt > D:\output.txt 2>&1

@echo off goto end

:end @echo exit 

1323 views
2 replies, 5 years ago
Why is a CAST required in this statement. Topic by NBGTD 11 Feb 2014

SELECT  CAST(INTERVAL '1223' second as interval  hour TO second)
 

791 views
1 reply, 5 years ago
Bad character in format or data Topic by Jugalkishorebhatt1 06 Feb 2014 bad character format, Bad character in format or data

Hi All,
Not able to figure about the below cause for error. The error is relating to casting. But when i tried cast f12 while inserting the data still i am getting the same error. Please help me to solve this issue.
.logon home/jbhatt,jugal
 .import vartext ',' file=/home/jbhatt/insert.txt
 .quiet on
 .repeat*
 using
 f1 (VARCHAR(40)),

4847 views
2 replies, 5 years ago
TPT : RDBMS error 7551: An EVL LOB instruction has a bad parameter (TransLOBOp: oidclass=2 at line 1697). Topic by M.M@TD 01 Feb 2014

Hi ,
Could someone help me here to understand what this error means.
I am trying to load a datafile that has CLOB Column defined in Schema definition.
Thanks !

937 views
1 reply, 5 years ago
Unity Data Dictionary Refresh Topic by damien.reed 27 Jan 2014

Hi everyone,
We're using Unity to replicate data between Production and DR servers.  I've found something with regards to Unity that I can't explain and am hoping someone out there can.

910 views
0 replies
CLI '215' occurred while connecting to the RDBMS while using TPT utility tbuild on Unix Topic by Premaswarup 02 Dec 2013 tpt, tbuild

Hi All,
We are trying extarct data from DB2 tables and loading into teradata tables and we are using tbuild utility in TPT.
 
Whuile connecting to DB2 we are getting the following error.
 
W_0_o_Test5: TPT10551: CLI '215' occurred while connecting to the RDBMS

1656 views
1 reply, 5 years ago
Limit on a table Topic by Sankalp.C 16 Dec 2013

My senario is like -
I have two table Tab1 and Tab2. Incase, I Tab1 can't have more than 5 milion entries, incase of any thing more old data should be passed to Tab 2.
 
How to do it in teradata?

1263 views
6 replies, 5 years ago
FASTLoad to load UK companies house data Topic by quimbyf 11 Dec 2013 fastload, variable

Hi,

1574 views
5 replies, 5 years ago
select * works but not "select count(*)" via JDBC Topic by vganti 14 Mar 2013 jdbc

I am running queries through a JDBC driver. I am able to execute select * from DBC.AccessRights with no issue. However, when I execute "SELECT COUNT(*) FROM DBC.AccessRights" I get the following error. Any help is appreciated. I can run both queries from bteq on the server.
 

2831 views
5 replies, 5 years ago
FAST LOAD FAILING Topic by diptera 28 Nov 2013

Here is the script -
 
 DEFINE                                   
                                          
  CNT_PON_CTX_ID     (INTEGER)            
 ,CNT_PON_TYP_CD     (CHAR(3))            
 ,PTY_ID             (INTEGER)            
 ,PTY_CNT_PON_TYP_CD (CHAR(3))            
 ,CNT_PON_ADR_TYP_CD (CHAR(3))            

1477 views
1 reply, 5 years ago
How to Change the datatype of an existing Column Of an existing Table. Topic by Sankalp.C 25 Nov 2013

Is there any way to Change the datatype of an existing Column Of an existing Table?

21624 views
2 replies, 5 years ago
Re:Volatile Tables In Stored_Procedure... Topic by gopaltera 18 Mar 2013 #Volatile tables

Hello Every one,
I have come across a problem in td_Stored Proc volatile tables,
Is  it volatile table  not allowed order by clause?
If it is, when i run the entire stored procedure and need to sort the results and here what is the soultions not alllowing of order by clause
 
~gopal

2160 views
1 reply, 5 years ago
ProductJoin join condition of ("LOGGING_KEY = ETL_TEMP_HIX_DEV.TABLE4.LOGGING_KEY" Topic by royhighness 07 Nov 2013

ProductJoin join condition of ("LOGGING_KEY = ETL_TEMP_HIX_DEV.TABLE4.LOGGING_KEY"

I am getting a product join result when explaining the query below:

 

SELECT 1

FROM TABLE1 LLL

INNER JOIN TABLE2 CLL ON CLL.LOGGING_KEY = LLL.CSA_LOGGING_KEY

LEFT JOIN TABLE3 ABR ON ABR.SURVEY_CD = LLL.SURVEY_CD

AND ABR.TBL_NM = 'SRVY_STG'

1679 views
2 replies, 5 years ago
good teradata institute Topic by saminapk 24 Oct 2013

good teradata institute?

1505 views
1 reply, 5 years ago
Getting "<error>" in the column next to the BLOB column while selecting data using SQL assistant Topic by abhigupta1386 18 Oct 2013

Hi All,
We are facing one issue. I have one table which has BLOB column defined in it.
I am trying to select the data using TD SQL assistant, but in result set its not showing correct data in column next to the BLOB column.
I tried swapping the column in my select statement, but always getting the "<error>" text in the column next to BLOB column.
 

2015 views
5 replies, 5 years ago
Teradata DBA Online Training Teradata Developer Online Training Call Us +919000444287 Topic by 21cssindia1 29 Sep 2013 Teradata DBA Online Training Teradata Developer Online Training

Teradata  DBA Online Training

1506 views
0 replies
Profiler pugin for Eclipse 14.10, first steps Topic by xhudik 27 Sep 2013 profiler plug-in for eclipse

Hi,
I've successfuly installed Profiler pugin for Eclipse 14.10. Then I open Teradata DB Express 14.0.3 and mafe some permission changes to sampel DB according to: Teradata_profiler_for_eclipse.pdf (page 2).
I got stuck on page 8, where I have empty Profiler Project Explorer Add Connection. Then when I try to create metadat tables I got error:

1663 views
0 replies
TRM 6.3.1.1 - Setting equal leads distribution in TRM 6.3 Topic by MFaizul_AManap 11 Mar 2013

Hi all, 
 
Does anybody know how to set equal leads distributed in TRM 6.3?
For example, i've 5 campaigns running concurrently and im sending to the same salesperson/banker. how to configure in TRM so that the salesperson can get equally 5 leads for each campaigns?
hope you guys can help me on this :)

2300 views
3 replies, 6 years ago
Always Teradata CommandTimeout error if the query needs more than 30 seconds under .Net Visual Studio 2012 C# Topic by John99 12 Aug 2013

I get always an CommandTimeout error if the SQL query needs more than 30 seconds under .Net Visual Studio 2012 C#.
Even though I have set up the CommandTimeout property to 0 (0=inifinetly) or set the property to 9000, nothing helps.
I get the same error:
[.NET Data Provider for Teradata] [100038] Command did not complete within the time specified (timeout).

2273 views
1 reply, 6 years ago
control check Topic by Madhum 12 Aug 2013

Hi,

1505 views
0 replies
newbie question getting started Topic by GeraldTrost 01 Aug 2013 teradata, express, connecting, login, VmWare Workstation

Hi!
 
I am developer and I am new to TeraData

I downloaded the TD14 VM (40GB) and I started it in
VmWare Workstation 7.1.1
(I do not have a WmWare Server)

Now SuSe linux shows a login dialog.

What can I do to start the database and to connect to the database ?

many thanks in advance
Gerald Trost

 

1660 views
3 replies, 6 years ago
Need instruction for installing PDCR. Topic by ashikmh 14 Jul 2013

We have PDCR installed on production box, but now, we need to install on the dev box as well, so any information regarding the  PDCR installation information will help me.
--Thanks,

1745 views
0 replies
INSERT Failed. 2646: No more spool space in sinpuv Topic by Purushothaman 09 Jul 2013 teradata, spool space error

Hi,
 
Im running with the spool space error when im trying to insert into a table based on the selection i do on the join of a fact and few other dimension tables.
Following are the details:
 
1.      Problem Description
a.      Query Being Executed
 

3350 views
1 reply, 6 years ago
LDAP authentication for Teradata Express Edition 13 Topic by sayaksitex 21 Jun 2013

I have installed Teradata Express edition 13 in windows XP. I have a LDAP server as well. I want to log in to teradata using LDAP authentication.
Please suggest me the steps to achieve the requirement. Appreciate any help.
 
Thanks and Regards,
Sayak Ghosh

1535 views
0 replies

Pages