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.
|
4498 views
|
1 reply,
7 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
|
15164 views
|
1 reply,
7 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
|
1728 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.
|
1952 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."
|
2355 views
|
3 replies,
7 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,
|
3688 views
|
2 replies,
7 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
|
3669 views
|
3 replies,
7 years ago
|
Query to find
Topic by vandy
31 Jan 2013
Hi All,
Please help me suggesting a query to find
|
1903 views
|
1 reply,
7 years ago
|
|
2094 views
|
3 replies,
7 years ago
|
|
1748 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",
|
6757 views
|
5 replies,
8 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
|
4080 views
|
1 reply,
8 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?
|
7946 views
|
12 replies,
8 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..
|
3338 views
|
1 reply,
8 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)....
|
7224 views
|
4 replies,
8 years ago
|
MQ WebSphere Teradata
Topic by EN186010
21 Sep 2012
mq websphere teradata
Folks,
|
3381 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
|
3337 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
|
3107 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
|
4456 views
|
6 replies,
8 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
|
3488 views
|
3 replies,
8 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.
|
4514 views
|
1 reply,
8 years ago
|
|
9711 views
|
7 replies,
8 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
|
20372 views
|
5 replies,
8 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
|
7315 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.
|
9104 views
|
4 replies,
9 years ago
|