Hi!I want to know how can I use these commands (from SQL Server) in Teradata because i need to obtain the similar functionality: and .For example:SELECT FIELD FROM TABLE1 WHERE (DATEDIFF(ss,(SELECT FIELD1 FROM TABLE1), SOME_DATE));SELECT CONVERT(VARCHAR(23),ACM_DATE,121) FROM TABLE1;Thanks for help,Anderson

hi,this is regarding the BT/ET feature, in reference to the post 'Transaction' on 05/19 and Fred's response (good info!)I am just trying to understand.....if coding as BT;stmt 1;stmt 2;stmt 3;ET;doesnt really make it as a one single explicit transaction (meaning stmt one is not rolled back if stmt 2 fails) andcoding as BT;stmt 1;stmt 2;stmt3;ET; makes it as one implicit transaction (even without BT & ET which is true)----> what is the use of the explicit BT/ET feature?I referred TD manual..but is sounds like both format revert all sql stmts in case of failure.........any thoughts??thx

Hi !
First, i want to apologize for my english. I'm french and my english is very bad.
I have a problem with an extract with MLoad.
When i try to converte a VARCHAR like '70,37' in DECIAML(6,2) with :
CAST('70,37' as DECIMAL(6,2) format 'ZZZZ,ZZ')
Teradata return 7037,00 not 70,37

The Teradata Certified Professional Program is excited to announce the release of  the first Teradata Aster Certification Exam – Teradata Aster Basics 6.10.  Passing this exam will earn you the Teradata Aster Certified Professional Credential.  Start preparing today and you’ll be one of the first to get Teradata Aster Cert

I am newbie to databases and TeraData and MS TD SQL assistant.
I am trying to create a TBL from 4 different queries run seperately(manually)
I have a code for Select queries to Pull data but I do not know how would I create MyTable from 4 queries + additional 5 columns have to be added in a New Table that are not a part of any Table/View or Query.

What are factors to decide how much time it should take for "collect statistic" and "refresh statistic"?My question is related to time it takes for "collect statistic" and "refresh statistic"?

Hi Everybody,
I have few questions around online backups.
Sol& Tools: Currently we are planning to use Teradata DSA(TDSA) solution with NetBackup  tool. The amount of data to be backed up is currently around say 10TB. Backing to disks not the tapes
** Abbreviations:
(TDSA)- Teradata Data stream architecture solution.
TDATA-Teradata

I am writing sql for 2 different lines of business. Everything in the code is the same except for 2 table names (where I'm selecting from and inserting into).I would like to use the macro but it doesn't work with how I'm writing it. Any suggestions? This would help so much on maintenance becuase everything is the same except for the 2 table names.Here's what I have so far that isn't working.CREATE MACRO CRTCL (RPT_TABLE VARCHAR(40), SO_TABLE1 VARCHAR(40)) as (INSERT INTO hs_rpt_tbls.tps_work2SELECT RP.per_end_dt, BE.rgn_no, BE.assigned_ctr, SOSP.tps_spc_cd,SOSP.tps_idy_cd,SOSP.so_typ_cd,count(SOSP.so_dt)FROM :SO_TABLE1 SOSP,(SELECT per_end_dt, acctg_yr_sta_dt from hs_db.rptg_per group by 1,2) as RP,(SELECT rgn_no, assigned_ctr, un_no FROM hs_db.bugroup by 1,2,3) as BEWHERESOSP.so_crt_dt between RP.acctg_yr_sta_dt and RP.per_end_dtAND SOSP.un_no=BE.un_noGROUP BY 1, 2,3,4,5,6;);I would execute it using the following:EXECUTE CRTCL (‘dbname.so_table', ‘dbname.final_table);

My friend told me I could useDIAGNOSTIC USESTATS ON FOR SESSION; to get recommended statistics in an Explain Plan for a Query. I have tried this in BTEQ and in Teradata Assistant and not been able to get it to work. Does anyone know how?Thanks.

Hi All,
Currently am trying to connect to Cloudera 5.4 Hadoop from Generic connector which is with Webhdfs from latest Teradata Studio, am not able to login I get the following error as in the screenshot. Is there any steps I need to follow to install some TDCH rpms in cloudera or use different drivers from studio. Any inputs will be so much helpful.

Hi

I am new to the Topics in Teradata and having the Column Table is

UPDATE_DTS TIMESTAMP(0) NOT NULL

and the data in the Columns is '2009-01-16 02:29:08'

i want to select the data based on the Column for the Particular Month. any help will be appreciated

SELECT *
FROM Table
where Update_dts >= '2001-01-01' and Update_dts <= '2001-01-31';

i have tried with different scenarios but having the issues ...

SELECT *
FROM Table
where Update_dts = '2001-01-01' ;

SELECT *
FROM Table
where Update_dts = '2001-01-01 4:05:30 PM'

We've a SET table defined with a UPI that has 9.3 Million rows on a 1400 AMP, V2R6 Teradata system. Please look at the numbers below. The AMP that has the MAX rows has 3.47 times more rows than the AMP with the MIN rows. This does not make sense to me given the fact that we've a UPI and a high volume of rows in the table for an even distribution.xTimesGreaterMaxAvg - 1.56xTimesGreaterMaxMin - 3.47Mx - 1393664Avrg - 890657.07Mn - 401920CurPerm - 1282546176Can someone please shed some light on this? Is there something we can look at to improve data distribution? Any help would be greatly appreciated.PS: The table also has a PPI defined on a date field which is part of the UPI (if this matters).Thanks,Sayee.

I want to create shared page with the ecosystem explorer job configured to show only certain columns.  I was successful creating a shared portlet to do this.  But, when I do this, the ability to click on the job and drill down into the job execution details is lost.  When I attempt to create a shared page, the ecosystem explorer is not one of the limited portlets available for this page.  The o

I have a column in source strdate1 as VARCHAR(23) and the value being '20090310181010'.I am unable to insert this record into target table column whose data type is timestamp(0) using this query within the insert statement of course:-select cast (StrDate1 as TIMESTAMP(0)) from table OR select cast ('20090310181010' as TIMESTAMP(0))it says invalid timestamp.Please help

Problem:
-----------
I have code as below,
sel * from testdb.maintable WHERE STATUS not in (10,11,13,16,17,20,21,23,26,27);
I need to remove the above hard coded status values and parametrize this piece of code. 
 
Solution:
-----------
To parametrize, I'm using another parm table below where I have the above status values put it. 

We have no events in the esm repository where the uowid is blank or null.  But, the 'Jobs' portlet displays a lot of rows with blank / null uowid, uowTS.  The "Status" column has a value of "NEW" in every case where the uowid is missing.  What is happening and how can I prevent this behaviour?  I tried adding a filter of UOWID <> '' or UOWID > 'a'.  These are return no data even though

We recently upgraded to ESM from TMSM in our dev / test environment.  It looks like the 'job' in the ESM explorer corresponds with the resourceid and not the JobName.  For example, an application "general ledger" (gl-prod) runs a data load that has multiple jobs.  The very first 'load' step has a job name like 'glload'.  Subsequent jobnames for the 'gl-prod' resourceid / applicationid, are like

Is there a way or option in datamover to send email notification on job completion (failure/cancelled/successful)?

What are the changes in V2R6.1 and TTU8.1?

Hello,
 
There are few Aster Jobs which are pulling data from hadoop using load_from_hcatalog function. However, we couldn't see these jobs on Hadoop (as Active). Any idea how the data is being pulled from Hadoop? From where can we trace what is the Application ID against that job on Hadoop ?
 
Regards,
Laeeq -

Can Teradata be a back-end fo SAP BEx tool ? Are there any connectors now available ? Any best practices or watchouts ?
Anybody outhere already using BEx against Teradata ?
 
Regards,
Suresh

Hi ,
  I am trying to write a select statement for converting a string to timestamp(6) and if string value  is missing or invalid timestamp , then it should have a default value as '0001-01-01 00:00:00:000000' . source field type is varchar(50). 

Hi
The TSM has been configured, TARA server and TARA Server Gui has been configured, I can see all the databases from target Teradata.
Arcmain itself works (just to confirm all connection details , IP and previliges for arc_user capable to run a backup to filesystem as flat file).
tarattdsmc work with "query tsm" I can see node platform as Teradata within TSM

My source Data is in oracle and Target Data is in Teradata.Please  suggest any tool to compare Records between 2 diffrent RDBMS.
There are 500 Tables need to be compared.

Hi all,I have a column coming down from an As400 extract. the format of this date column is m/d/yy, take the following date example1st of April 2009 ---> 4/1/09 on extract.I want to format this field as 'DD/MM/YYYY'.I keep getting an invalid date error.Any comments will help!!Thanks guys.