0 - 22 of 22 tags for ddl

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.
 

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.

Hello,
 
Thank you in advance for your time.
I want to create a table with the same structure as an existing one.
The problem with the create table command , is that it does take under consideration foreign keys (for my case).
(

Hi,
I'm trying to add a comment whithin the CREATE TABLE ddl. I've check that Teradata supports comments  via statements of the type:

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.

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.

Hi! 

I'm rather new to Teradata so please sorry if the question is a simple one.

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? 

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
Deepak
http://prdeepakbabu.wordpress.com

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
Deepak
http://prdeepakbabu.wordpress.com

hi

can anyone help me about how to learn and practice teradata......
i am a beginner....and also provide the h/w and s/w requiremnts for using teradata.....
hyperlinks for practicsing teradata are also welcomed.....
plzzzzz.....help me on this regard.....

thanks in advance....
kundan

Hi,
I need to create a new table based on the data from a query result. The name of the columns in new table will be the data values from result of a query.

For example, lets say my source query returns following records:

Field1 Field2
V1 A1
V2 A2
V3 A3

Then table DDL should be like:

Create table testdb.test_tab
(
Start_dt date,
v1 varchar(30),
v2 varchar(30),
v3 varchar(30),
a1 varchar(30),
a2 varchar(30),
a3 varchar(30)
)
primary index(start_dt);

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,
NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT
(
LINE_NUMBER DECIMAL(18,0),
TRANSACTION_SET_ID DECIMAL(18,0),
FILE_ID VARCHAR(20)
) NO PRIMARY INDEX ;

I get the error message
3706: Syntax error: Expected something between ')' and the 'NO' keyword.

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