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.
Teradata SQL Assistant Intellisense feature Topic by asu_cs 21 Jan 2013

Hi all,
As a company we are using Teradata SQL Assistant 13.10 for query execution, we are new for Teradata and our editor has no intellisense feature. My question;
Is there any plug in to Teradata SQL assistant to activate intellisense feature or can you suggest me some other  teradata sql editor which will provide intellisense and better performans?
Thanks in advance.

4460 views
1 reply, 6 years ago
INSERT INTO new table from existing query output Topic by BBerszoner 16 Apr 2013 INSERT INTO, create table

I am trying to put into a table the output from a previous query (saved as a volatile table).  I am creating a new table PROC_STATS to hold the output and then using INSERT INTO followed by a SELECT query to get the data inot PROC_STATS.  When I run the code in SQL Assistant, I get a message that 1 row was returned, which is the correct value.  However, when I run SELECT * FROM PROC_STATS, no r

15138 views
1 reply, 6 years ago
TERADATA ONLINE/CLASS ROOM TRAINING @KPHB BY REALTIME EXPERTS Topic by mkinfotech.kphb 13 Apr 2013

MK INFOTECH@KPHB
TERADATA ONLINE/CLASS ROOM TRAINING @KPHB BY REALTIME EXPERTS
 
 
304,Padmaja’s Raja Enclave, Opp.RS Bros,
Near KS Bakers, KPHB, HYDERABAD, AP,INDIA
 
ph:09247758121,040-65767999
 

1713 views
0 replies
Teradata Fastload Topic by dannana27 11 Apr 2013

 

I'm trying to load a flat file using Teradata Fastload.

The data file has been created using python script and the delimiter is Ctrl+A which I believe is equivalent to '\x01'. Here's the syntax I used 

SET RECORD VARTEXT '\x01'; 

The same file works with a pipe '|' or comma ','  delimiter. Can you please suggest.

1943 views
0 replies
bynet install issue during installing Teradata 13.0 Express Edition Topic by Tim_Qiu 21 Mar 2013

 

I'm trying to install Teradata 13.0 Express edition using VMware virtual OS (Win7 32bit). I click on the first installation step which is to install the bynet(x86) driver. But get the error: "Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor."

2335 views
3 replies, 6 years ago
How to optimize the query? The Explain plan is given below. Its showing no more spool space. Topic by sayaksitex 12 Mar 2013

Explain SELECT
LDA_RDM_JPMCC_NM_ADDR_MTH_V.CUSTOMER_OBJECT_ID,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.ACCOUNT_NUMBER,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.WORK_PHONE_NUMBER,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.SRC_SYS_CD,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.CRE_RUN_ID,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.ETL_SRC_FILE_NB,
LDA_RDM_JPMCC_NM_ADDR_MTH_V.ETL_ROW_NB,

3662 views
2 replies, 6 years ago
inserting string value in to table Topic by SeenuGuddu 26 Feb 2013

Hi All,
 
i am just  trying to insert the million records if values into table but having the issues with this
i had the data in this formate 'PYE:879'-"sd4696' and i am not able to insert the records
Insert into Tab1 (Col1,COl2) Values ('Data','PYE:879'-"sd4696');
Can you please help on this issue
 
Thanks
 

3647 views
3 replies, 6 years ago
Query to find Topic by vandy 31 Jan 2013

Hi All,

 

Please help me suggesting a query to find

1885 views
1 reply, 6 years ago
Please help me suggesting a query to find 1.the scale of the column in teradata 2.the foreign keys of a table in teradata 3. ... Topic by vandy 31 Jan 2013

Hi All,
Please help me suggesting a query to find
                                                                 1.the scale of the column in teradata

2073 views
3 replies, 6 years ago
1734 views
0 replies
SQL to pull data Topic by thisisKumar 11 Jan 2013 sql

Hi, I have one scenario and I am looking for your help.
we have large DW with almost 10 different soruces with 400 tables. So, I want to know what are all sources are populating each table. 
in all these tables SRC_CD is Mandatory.
sel DISTINCT '?ACCT' as "TABLE_NM",
 

6728 views
5 replies, 6 years ago
Query to get the first name , middle name and surname from a given name Topic by sayaksitex 10 Dec 2012

Let a name be 'Sayak chandra venkateshwar'
I want the output as
first name: Sayak
second name: chandra
surname : venkateshwar

4066 views
1 reply, 6 years ago
Experience of TRS Topic by Random_Thought 21 Jul 2009 trs

Does anyone here use TRS?

If so is it reliable?

How much Data do you replicate? All or just a few tables?

How many TB or GB do you replicate per day?

7925 views
12 replies, 6 years ago
Query on Big Table sized approx 1 TB Topic by Khushbu 18 Oct 2012

HI,
 I have a very big fact table named F_BASE_SALES_TRANS_LINE and the size as aprrox 1 TB. This table contains detailed dat at
calendar_date, ITem_id, Store_num, TRANS_line_id... You can say the smallest granularity of each transaction at Retail store.
  Table structure is below..

3315 views
1 reply, 6 years ago
Query to convert Decimal(15) to date format 'yyyy-mm-dd' Topic by sayaksitex 24 Sep 2012

Can anyone help me with the query to convert a decimal eg (19890523) to date format (1989-05-23)....

7163 views
4 replies, 7 years ago
MQ WebSphere Teradata Topic by EN186010 21 Sep 2012 mq websphere teradata

Folks,

3362 views
0 replies
To find if the column is notnull, if the column contains ( , ,'',-), if the column is valid decimal(15) in a single query Topic by sayaksitex 11 Sep 2012

we want a single query for checking

1. if the column is null or not

2. if it is not null then we should check that it doesnt contain  , - '' 

3. if the above 2 cases are passed , we want to check if it is a valid decimal(15) or not

 

thanks

3327 views
0 replies
Renaming Name field to return date value Topic by TRMyoung 10 Sep 2012 renaming name field to return date value

I have a query and want to return the date as the field name. What do I need to do to turn the date value as a field name?

select Suppress_Cd, supp_desc,

count(distinct STHD_KY)  as CAST((CAST(DATE AS FORMAT 'MMMDD')) AS CHAR(5)) from testble

 

thanks

 

3095 views
0 replies
Bteq script required to validate record count of Source and target table. Topic by sayaksitex 04 Sep 2012

I have a source and a target. I want to make a post session failure command based on the record count of my source and target tables.

Thanks

4424 views
6 replies, 7 years ago
IF Column1 = Column2 => Merge data of Column3 in one cell Topic by Theena 30 Aug 2012

I have this table:

 

 

Book

Task

Assignee

723983

A5Q

Maria

723983

A5Q

Ken

723983

A5Q

Phil

723983

WC13

Brian

724025

FRMDS

Jacob

3467 views
3 replies, 7 years ago
Teradata Query resolving Topic by mohan.mscss 21 Jul 2012

I have the following in Column A

28VNC
JR2KL
29C9O
PQS11

I'd like have this result

28
2
299
11

How would I achieve this. Appreciate any help.

4498 views
1 reply, 7 years ago
TPT 13.0 is compatible with Windows 7?? Topic by Mishti 01 Mar 2012

Hi all,

9697 views
7 replies, 7 years ago
exception handling in Store Procedure Topic by emilwu 08 Oct 2009 exit handler

How to handle exceptions raised within the cursor iteration? Basically what I have here is a For cursor and I want to handle the exception and exit the for loop. The exception handling are MULTIPLE SQL statements which cleans up and record error messages. The Teradata documentation's example shows only one SQL statement for handler action statement. I tried to enclose multiple by using BEGIN ... END block the code looks like this
exception handling syntax is:

/*** Previous logic codes here **/
BEGIN --(1)begin the block for record process and error handling

20337 views
5 replies, 7 years ago
JMS ADAPTER - TERAJMS_VARIABLES not used ? Topic by a.kumar 10 Jan 2012 jms universal connector

Hi,

I have a requirement to alert (using email) a user/usergroup in case jms adapter stops. I see couple of variables in TERAJMS_VARIABLES table like

1) emailReceiver

2) smtpServer

3)emailLevel

 

4) portNumber

 

7304 views
0 replies
JMS Adapter. Topic by Claudia 22 Oct 2009 jms adapter

Does anyone use JMS Adapter?

I have some issues with this tool:
1) When the queue has too many rows JMS Adapter try to insert into teradata with some value mixed. For example, into the field date it puts a number. And the row goes to the error table in Teradata.
2) When exists some NULL value JMS Adapter can not insert into Teradata.

9084 views
4 replies, 7 years ago

Pages