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)),
|
1249 views
|
3 replies,
6 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
|
1351 views
|
2 replies,
6 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)
|
810 views
|
1 reply,
6 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)),
|
4888 views
|
2 replies,
6 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 !
|
956 views
|
1 reply,
6 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.
|
926 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
|
1682 views
|
1 reply,
7 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?
|
1286 views
|
6 replies,
7 years ago
|
|
1601 views
|
5 replies,
7 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.
|
2859 views
|
5 replies,
7 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))
|
1507 views
|
1 reply,
7 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?
|
21647 views
|
2 replies,
7 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
|
2182 views
|
1 reply,
7 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'
|
1694 views
|
2 replies,
7 years ago
|
good teradata institute
Topic by saminapk
24 Oct 2013
good teradata institute?
|
1524 views
|
1 reply,
7 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.
|
2033 views
|
5 replies,
7 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
|
1518 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:
|
1702 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 :)
|
2318 views
|
3 replies,
7 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).
|
2292 views
|
1 reply,
7 years ago
|
control check
Topic by Madhum
12 Aug 2013
Hi,
|
1526 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
|
1692 views
|
3 replies,
7 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,
|
1766 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
|
3416 views
|
1 reply,
7 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
|
1553 views
|
0 replies
|