![]() |
Hi,
02 Sep 2016
| 1 comment
,
|
![]() |
|
![]() |
What are the reason(s) why a PK will be implemented as USI instead of UPI? This question was formulated based on the following statement:
28 Mar 2016
| 9 comments
,
|
![]() |
I need to reverse engineer several Teradata 14 databases into ERwin 9.5.
22 Jul 2015
| 2 comments
,
|
![]() |
Hello.
14 Jul 2015
| 1 comment
,
|
![]() |
This error was received after executing the following DDL statement for bitemporal table:
20 Jun 2015
| 6 comments
,
|
![]() |
Hello, I can not execute consecutive GRANT statement. I have to execute a single GRANT a time. GRANT EXECUTE, SELECT, STATISTICS, SHOW ON "DBC" TO "DBADMIN" WITH GRANT OPTION;
11 Nov 2014
,
|
![]() |
Is there tool/utilities to convert mainframe copybooks to Teradata DDL's?
05 Nov 2014
| 2 comments
,
|
![]() |
Hi Forum,
I have a table created as SET table using IDENTITY column as UPI and it has data in it. Now, the user wants us to change it to MULTISET, but, as the PI is on Identity column how can I do this?
26 Jun 2014
,
|
![]() |
Hi everyone,
08 Apr 2014
| 1 comment
,
|
![]() |
Hello,
22 Feb 2013
| 3 comments
,
|
![]() |
Hi,
20 Feb 2013
| 2 comments
,
|
![]() |
I'm using Teradata Studio v14.01.0.201206111225, and noticed that if I create a table as MULTISET, and later right-click the table, and in the Teradata sub-menu select Show DDL it correctly creates a CREATE MULTISET TABLE.... statement.
31 Jan 2013
| 1 comment
,
|
![]() |
I created a test AJI at the end of last week, but I've since lost the text of the index. In SQL Assistant, I can see the index as part of the table in the tree view navigation pane, but I can't get to a "Generate SQL > Create" option in the right-click menu. The table DDL doesn't include the join indexes either.
24 Sep 2012
| 4 comments
,
|
![]() |
Hi! I'm rather new to Teradata so please sorry if the question is a simple one.
21 Dec 2011
,
|
![]() |
when select inserting from one table to another -- where both have compression on the same column... what does teradata do? Does it need to decompress each & every column first -- to get the value and then attempt to insert it into the destination table by check each compressed value there & then storing it?
05 Oct 2011
| 5 comments
,
|
![]() |
Can you please help me understand if Teradata provides DDL event based triggers. I want to grant permission to tables created in my schema automatically using a trigger. Thanks
05 Apr 2011
,
|
![]() |
Can you please help me understand if Teradata provides DDL event based triggers. I want to grant permission to tables created in my schema automatically using a trigger. Thanks
05 Apr 2011
| 1 comment
,
|
![]() |
hi can anyone help me about how to learn and practice teradata...... thanks in advance....
22 Mar 2011
,
|
![]() |
Hi, For example, lets say my source query returns following records: Field1 Field2 Then table DDL should be like: Create table testdb.test_tab
22 Jun 2010
| 1 comment
,
|
![]() |
I'm a Teradata newbie. I want to create tables with NO PRIMARY INDEX. I am on version 12.0. My DDL looks similar to this. CREATE MULTISET TABLE UP_KWADA.TEST_INSERT, FALLBACK, I get the error message
08 Jun 2010
| 3 comments
,
|
![]() |
Hey, Anyone know how to create a table using a view (Structure & Data)? Also, is there anyway to retrieve the DDL for the tables or views we have access to? Thanks, -Ayyad
03 Feb 2010
| 2 comments
,
|