0 - 28 of 28 tags for dnoeth

Hi Team,
 
I have a requirement like below.
Col1 
ABC
DEF
and if my COL1 has any of ABC or DEF then it should make another entry say 'XYZ' like below.
COL1
ABC
DEF
XYZ.
When i use a case statement like below.

Hi All,
Please find the below two queries. I need to know, is both the queries will give the same result? if yes then which one will consume more spool.
FYI: TABLEA contains 4billion records, TABLEB contains 10 million records and TABLEC contains 1million records.
 
SELECT * FROM TABLEA
INNER JOIN TABLEB

I am new to Teradata, and have this requirement at job. In below table i have three columns given (REF_ID,Seq_Nbr and depth). I need to create a new_column which should have values based on Depth.

I am having one column where it can have position 3-5 as blank. It can be as position 3 as blank or position 4-5 as blank.

Hi,
I am trying to insert data from prod to dev by using TPT Update operator. By mistake i have deleted all error tables including work table, log table.
Agin when i submit the script am got TPT10508: RDBMS error 2583 error in teradata tpt Error. Can you please suggest me how  resolve this issue.
Error :

Hi,
Can anyone help me to convert the below query in Teradata.
SELECT TO_CHAR(SYSDATE-7,'DD-MON-YYYY')||'|'||TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE,11)),'DD-MON-YYYY') FROM dual;
I am trying very hard, but as new to teradata, so couldnt workmuch.
Please help me asap

Hi All,
 
Wish you a very Happy new Year 2014
I have a very simple requirement of just taking back up of existing table , so I have followed folowing steps
 
1. created a back-up table very similar to existing table (using SHOW SELECT * FROM <tablename> )

Hi,
I am having an issue when using Bteq in Linux. 
Let's say I have a table in teradata that has two columns:
Article            Date_issue
 Article1         12/18/2013
When I qu ery this table from Bteq in Linux the result is:
Article            Date_Issue
Article1          13/12/18

Hi All,

 

I have below mentioned Script . I am not completely clear with the use of (IGNORE DUPLICATE UPDATE ROWS,INSERT FOR MISSING UPDATE ROWS,IGNORE MISSING UPDATE ROWS) in the Script could any 1 help me with the same.

 

 

/**************************************************************/

/* */

My source is Oracle, and my staging tables are in Teradata. Should I create staging tables with PI or shall I create NOPI tables?
What is recomanded?
Thanks,
Sayak.G
 

Hi All,
I am getting TPT_INFRA: TPT04101: Warning: TMSM failed to initialize warning while using TPT Fast Export Script but it runs successfully. 
Can any one please help to remove or explain the warning for the same.
Regards,
Amit Terse

Hi all,
When am trying to run the query, it is taking 20hrs to run the query.
we done the collect stats for all the tables by giving Diagnostic collect stats
help me to improve the query performance.
SEL Col1,Col2,Col3,.... Col200 From
Table18 Left Join
(Table1  Inner Join  Table2
On  Table1=Table2  

Hello Experts,
 
Can some please explain what is meant by Title Stacking? I came acorss a question asking "Does the AS Clause allow title stacking'?
 
Thanks

Hi All, Please help me to fix the partition violation error.
When am tring to load datas into my target table, am getting 5728 partition violation error.
Partition range mentioned below,
PRIMARY INDEX ( CUST_ID )
PARTITION BY ( RANGE_N(ENDT  BETWEEN DATE '1991-01-01' AND DATE '2004-12-31',

Hi all, could you please help me to group the records based on date. sample data and the excepted result given below.
 
Table
ID  TYPE  STDT   ENDT
 
1    A     1Aug    10Aug
1    A     11Aug  20Aug
2    B     21Aug  30Aug
2    B     31Aug  9Sep
1    A     10Sep  20Sep
 

help me to group the records as the resultset given below.

Table

ID TYPE STDT ENDT
1 A 1Aug 10Aug
1 A 11Aug 20Aug
2 B 21Aug 30Aug
2 B 31Aug 9Sep
1 A 10Sep 20Sep

Below is the expected resultset

ID TYPE STDT ENDT
1 A 1Aug 20Aug
2 B 21Aug 9Sep
1 A 10Sep 20Sep

Hi -
I have req such that , i need to call a procedure inside another using dynamic sql.
there is permanent table, which has procedure column, which will be loaded from java.
 
Once it is loaded a report procedure will be called through perl script.

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

Perfect Query Timings needs to be captured.
 
Hello, we are using Teradata13.10 Version and using Viewpoint also. We are using OBIEE 11g tool to refreshing the reports.
Daily basics we runs 10000+ reports against to Teradata by using PROD_OBIEE_USER user (Only one User-DBQL log is enabled)

SELECT a.cas_pkeyb.amt
FROM vt_notdisp_ship_to a,
scref_bvws.b_curr_trans b
WHERE (a.ship_to_addr <>'''' AND a.ship_to_addr LIKE ('%b.ship_to_addr%'))
OR (a.ship_to_code <> '''' AND a.ship_to_code LIKE ('%b.ship_to_code%'))
QUALIFY ROW_NUMBER() OVER (ORDER BY a.amount DESC) <=10;
 

Hi,
I am trying to executed a procedure having dynamic cursor which returning result set from a unix script.
Whenever i run the script, it give a warming message  as below
*** Procedure has been executed.
*** Warning: 3212 The stored procedure returned one or more result sets.

Hello Friends.
I am trying to convert a column havign CHAR(20) to SMALLINT and getting the below error....
I have the below distinct values....as char(20).
this query Cast(cast(red_Cd as CHAR(3)) AS SMALLINT) and getting this error.
Bad character in date or format..you help is appreciated..thanks...

I need your help to find the result for the below table

I have a table of having 260 columns in that i need to retrieve the records having NULL values. I had seen my DDL also, few of the columns
having NULL Constraint, so i left those columns in my query. My Query is
 
SEL * FROM TableName WHERE CN1 is NULL or CN2 is NULL or CN3 is NULL... or CN260 is NULL
 

Hi everyone, i need to convert all the strings into Date format in a single query.
2012/11/24
2012-11-24
2012 11 24
20121124
24/11/2012
24-11-2012
24 11 2012
24112012
11/24/2012
11-24-2012
11 24 2012
11242012
12/11/24
12-11-24
24/11/12

Hi everyone, I need some help determining the logic for the below scenario,
maturity         timeperiod
6/13/2010      8/13/2007
6/13/2010      7/25/2009
6/13/2010      3/12/2010
6/13/2010      5/23/2010
11/23/2012    3/23/2011
11/23/2012    12/11/2011
11/23/2012    11/28/2012

The date field is in the format 'DD-MON-YY'.
But wherein the data which i receive is as below.
EX:
12-Aug-12
1-Aug-12
The first if i handle using the substring the second value will be handled wrongly.
I want these values loaded as 'YYYY-MM-DD'
Can you please suggest how i can handle this in TD?