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.

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

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
 

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.

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

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,

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
 

Hi All,

Please help me suggesting a query to find

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

Hi All,

Please help me suggesting a query to find

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

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

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?

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

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

Folks,

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

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

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

I have this table:

Book

Task

Assignee

723983

A5Q

Maria

723983

A5Q

Ken

723983

A5Q

Phil

723983

WC13

Brian

724025

FRMDS

Jacob

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.

Hi all,

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

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

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.