![]() |
Team,
23 Mar 2016
| 12 comments
,
|
![]() |
I have 2 tables.
16 Mar 2016
| 7 comments
,
|
![]() |
I am trying to understand how Datastage interacts with Teradata in Immedaite mode. During my testing, I created a Datastage job with TD connector as source and destination to just select from one table and load into another table.
09 Nov 2015
,
|
![]() |
Teradata 13.10 is rejecting my insert with the error:
03 Mar 2015
| 6 comments
,
|
![]() |
Hi All,
23 Feb 2015
| 5 comments
,
|
![]() |
The following shows how to batch 2 rows of data, then invoke JDBC PreparedStatement.executeBatch to INSERT them into a database table.
18 Nov 2013
| 2 comments
,
|
![]() |
All
16 Jul 2013
| 1 comment
,
|
![]() |
Hi All,
27 Jun 2013
| 4 comments
,
|
![]() |
Hi All,
06 Jun 2013
| 2 comments
,
|
![]() |
I need to store the value in the DataParcel column(which is of VARBYTE datatype) in the first error table of FASTLOAD into a permanent teradata table but with a proper format(The ddl of this table will be exactly the same as the target table, except that all datatypes are varchar)
04 May 2013
| 1 comment
,
|
![]() |
I need to perfom the simple task of adding new data to a large existing table. My source data is on Teradata and is in a table that looks exactly like my target table (field names, datatype, PI, ...) . For example, I need to add 10 million rows on to a table that already has 800 million rows.
04 Feb 2013
| 2 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 Guys, Our portlet has to store a considerably large amount of data. Is there a way to "create" a custom table in the Postgres SQL DB for storing this Data. And afterwards be able to query this table and also do inserts and updates?
18 May 2011
| 4 comments
,
|
![]() |
I have created a table with a column that is varchar(5). When I insert a string of 6 characters the string is truncated to 5 characters rather than throwing an exception. Is there a way to force a strict mode so this will result in an error? Jesse
29 Mar 2011
| 2 comments
,
|
![]() |
Hi I created a table with a single column of TIMESTAMP(0) WITH TIME ZONE. When I try to insert value with the following statement INSERT INTO XOBTTEST (timestmp_with_zone) VALUES ('2010-10-20 14:23:00-05:00' (TIMESTAMP(0) WITH TIME ZONE,FORMAT 'YYYY-MM-DDbHH:MI:SSZ'); I got this error: When I try the following statement: INSERT INTO XOBTTEST (timestmp_with_zone) VALUES ('2010-10-20 14:23:00-05:00' (TIMESTAMP(0) ,FORMAT 'YYYY-MM-DDbHH:MI:SSZ');
23 Oct 2010
| 1 comment
,
|
![]() |
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
,
|
![]() |
Hello, I have created a new table with a CLOB field intended to store a deliminated character string, however a standard INSERT statement is only loading the first character of said string. Any thoughts or guidance as to why this is happening and how to fix please? All input gratefully received. Thanks,
15 Jan 2010
| 2 comments
,
|