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.

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.

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