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)),

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 

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

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)),

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 !

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.

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

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?

Hi,

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.
 

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))            

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

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

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'

good teradata institute?

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.
 

• Teradata DBA Online Training

• Teradata Developer Online Training

Teradata  DBA Online Training

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:

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 :)

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).

Hi,

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

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,

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
 

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