Hi, I am Altering the table for addition of new columns. And tables is having more than 1 billion records. Please let us know is it standard to alter the table with more than one billion records or not. Also guide us in best practise to alter the table with data.  

Hello Everyone, 

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:"Primary keys are implemented as unique secondary indexes for non-temporal tables..."

I need to reverse engineer several Teradata 14 databases into ERwin 9.5.

Hello. We are using Merge into in a TPT DDL to load data to the destintation tables. Our problem is how to report the number of rows inserted/updated by the merge into sentence, because we cant use (or if its possible, we dont know how) notify in DDL Operator. Please if you have done this before, can you share an example?  

This error was received after executing the following DDL statement for bitemporal table:  

Hello, I can not execute consecutive GRANT statement. I have to execute a single GRANT a time. For example: GRANT EXECUTE, SELECT, STATISTICS, SHOW ON "DBC" TO "DBADMIN" WITH GRANT OPTION;

Is there tool/utilities to convert mainframe copybooks to Teradata DDL's?  Even just getting the field names and their equivalent Java data typw will do. Thanks.

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?

Hi everyone, I'm tryng to build a set of queries with the objective of getting the DDL of tables only from the info inside the dbc tables (columns, tvm, dbase, tableconstraints...). I started from the table dbc.columns to get all the info about every field of a table. Below you can find the work in progress query.