![]() |
I have 2 tables.
16 Mar 2016
| 7 comments
,
|
![]() |
Hi,
02 Jan 2016
| 2 comments
,
|
![]() |
I have a table with the following layout cust_acct_id (PK)| effect_dt | expiry_dt | curr_rec_ind | field_a | field_b | field_c | field_d I have to populate any NULL values in field_a, field_b, field_c, or field_d with the most recent value received for that field for the same cust_acct_id. Sample Input:
30 Jun 2015
| 5 comments
,
|
![]() |
Hi,
28 Dec 2014
| 3 comments
,
|
![]() |
I have an update statement directly referencing one table and a second one through a SELECT statement.
15 Oct 2014
| 1 comment
,
|
![]() |
Dears,
30 Sep 2014
| 1 comment
,
|
![]() |
UPDATE db.source
SET
region= CASE WHEN b.title_rw LIKE '%East%' THEN 'East' WHEN b.title_rw LIKE '%Central%' THEN 'Central' WHEN b.title_rw LIKE '%West%' THEN 'West' else 'Region N/A' END
from db.source a
22 Jul 2014
| 2 comments
,
|
![]() |
Hi All,
11 Jul 2014
| 7 comments
,
|
![]() |
Hi,
09 Mar 2014
| 1 comment
,
|
![]() |
Being not an expert at upgrades, I have an old client GSS/ODBC install version 3.06 & would like to upgrade to the latest V14 drivers. The old drivers are located in an NCR folder, & from initial checks the V14 installs under Teradata folder.
20 Jan 2014
| 3 comments
,
|
![]() |
|
![]() |
I was reading an older post (http://forums.teradata.com/forum/database/reset-identity-column-counter) and concluded that somehow Update is possible for DBC tables (DBC.IdCol).
12 Dec 2013
| 3 comments
,
|
![]() |
Hi everyone,
31 Oct 2013
,
|
![]() |
hi , Currently by using BTEQ and Teradata SQL assitant I am able to insert records into a table.
24 Apr 2013
| 4 comments
,
|
![]() |
I have a requirement to update the duplicate records in teradata. For E.G. if col, col, col, col have same values in the table, those records are regarded as duplicates and duplicate flag needs to be updated as '1' for all those records. Any suggestions on how implement this logic?
04 Mar 2013
| 5 comments
,
|
![]() |
Hi,
14 Sep 2012
| 2 comments
,
|
![]() |
Hi, i have these 2 columns defined: WAIT_INTVL INTERVAL HOUR(3) TO SECOND(2) and both are null values a) select COALESCE(WAIT_INTVL, INTERVAL '0' SECOND) from TableT1 b) i can substract (a) with itself select COALESCE(WAIT_INTVL, INTERVAL '0' SECOND) - COALESCE(WAIT_INTVL, INTERVAL '0' SECOND)
13 Jun 2012
| 2 comments
,
|
![]() |
Hi, i have data: select JOB,NAME,CODE,START_TM from table TableT JOB,NAME,CODE,START_TM ------------------- JOBA,M,S,2010-06-04 JOBB,M,K,2010-06-05 JOBC,N,A,2010-06-02 JOBD,N,A,2010-06-03 JOBE,O,A,2010-06-04
06 Jun 2012
| 2 comments
,
|
![]() |
16 Mar 2012
| 4 comments
,
|
![]() |
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 condition. This is what my flat file looks like: ##Flatfile
11 Mar 2012
,
|
![]() |
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
CASE WHEN SEL Table1.Column return TRUE THEN UPDATE Table2 AND INSERT Table3 ELSE INSERT Table2 AND INSERT Table3 END
15 Feb 2012
| 6 comments
,
|
![]() |
Hi All, I have read in SQL Reference - Data Manipulation Statements that UPDATE Processing Time for an UPDATE operation is longer under the following conditions: In my process I am loading data into intermediate staging table and then performing various update on that... and at last I m renaming table to final table to use updated data in another process.
31 Jul 2011
| 1 comment
,
|
![]() |
Hello, As part of my job, I have to understand the patching model of all databases our clients are using, in order to assure maximum security level. I have a couple of questions regarding the database, and I couldn't find the answers I was looking for online. Hope you can help me here, 1. Is there somewhere online we can see a list of all patches released for the DB? We are mostly interested in Security updates. 2. Is there some fixed date for patches? Like, for example, a new patch is releases every 2 month?
28 Jun 2011
| 1 comment
,
|
![]() |
Hi All, I am following below topic http://www.teradatamagazine.com/v10n01/Tech2Tech/Another-option-on-the-table/ I have some questions , 1. How I can use MERGE for update query when match is on NON - PI value. My query is like
20 Jun 2011
| 1 comment
,
|
![]() |
Below is a SAS script that passes variables thru the same code many times. I would like to do the same type of thing in Teradata with my initial code looking like this for an UPDATE. 1. First, this is an UPDATE statement Thank you in advance,
23 Jun 2010
,
|
![]() |
Below is a SAS script that passes variables thru the same code many times. I would like to do the same type of thing in Teradata with my initial code looking like this for an UPDATE. 1. First, this is an UPDATE statement Thank you in advance,
23 Jun 2010
,
|
![]() |
This book provides information about Teradata MultiLoad, a product that provides an efficient way to deal with batch maintenance of large databases. Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in a Teradata Database.
01 Feb 2010
| 2 comments
,
|
![]() |
Hi, I've just arrived to the Teradata world from SQL Server and learning the new syntax. How do you update a table using a join? The first approach I used was what I have been doing: create aliases, then refer to them, but I get 3993: Illegal use of alias name.
17 Jul 2009
| 2 comments
,
|