# | Date | Forum | Type | Thread | Post |
4 | 11 Mar 2012 @ 08:06 PDT | Tools | Topic | BTEQ or Fast Load or Multi Load |
Hi everyone! I am currently studying Teradata and currently working on this problem of mine. You see, i have this set of data on a flat file that needs to be loaded in a table based on a conditi... |
3 | 15 Feb 2012 @ 04:50 PST | Tools | Reply | Update and Insert inside a CASE |
How about ubstituing the CASE by IF ELSE ENDIF??
|
2 | 15 Feb 2012 @ 03:41 PST | Tools | Reply | Update and Insert inside a CASE |
Here is the logic. (Not really working)
Select substr(number,1,13) as num1, substr(number,1,5) as date1 from tbl1
case
when
num1 in (select num3 from tbl3 where num3=n... |
1 | 15 Feb 2012 @ 01:15 PST | Tools | Topic | Update and Insert inside a CASE |
I want to Update and Insert when a condition in the case was true. However, it seems that Teradata doesn't accept it. My question is, is there a way for that to happen?
Like
... |
|
|