Tags for table
Performance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insert
Team,   We have an insert statement that is inserting around 92 million records into a table based on a select statement from another table.  The select piece runs fine, but the following step takes a long time. We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767.
insert select merge table multiset identity
Java external stored procedure returns ResultSet - how to insert this contents to a (temporary) table
Hallo all, I have created a Java external procedure that returns a dynamic result set. I can successfully call it and it returns the correct data. Now how can I store this returned data to a new (temporary) table?
java stored procedure resultset table
Creating and populating a parameterized table inside a stored procedure
I am trying to create a table and populate it inside a stored procedure but I get E(3807): table does not exist. I used the following query:  create procedure stp_agg (in par1 varchar (20),in par2 int) begin     create table tbl_spt     as     (select subscriber_id from existing_tbl) with no data;
create table procedure
Dynamic Table Name
Hi, I have set up a BTEQ of an SQL code through PUTTY. The code runs weekly. However, I run a drop statement and then a create table statement, thus losing the table of the previous week. Is there anyway for me to create a table of the following format so that I retain all the tables that I have created ?
teradata bteq dynamic table name
TERADATA 13.10 - DATASTAGE 8.5 Issues with FastLoad functionality
Issue description: When a job that is loading an empty table through FastLoad Functionality (Teradata Connector) aborts, it causes the mentioned table to be left in an irrecoverable Lock state, which cannot be cleared using an empty FastLoad, and which only workaround is to drop and recreate the table.
fastload issues error lock table lecked table
An owner referenced by user does not have REFERENCES access
Hi,   I'm logged in with dbc user. I'm ALTERing a table to add Foreign Key Constraint with Following statement ALTER TABLE testdb.Master2 ADD CONSTRAINT fk_Master1 FOREIGN KEY (Master1ID) REFERENCES testdb.Master1(Master1ID); its works fine. But when i write this in a procedure
Foreign key Constraint database index primary alter table
How to find the number of columns in each table in Teradata ??
teradata find number of columns table
Need metrics for database, table, and column usage in queries. TD 13.10/14.10
We're using Teradata 14.10 and 13.10.  
table column usage metrics
Types of Tablekind
In teradata there are 3 basic types of Database objects. they are  1. View 2. Table 3. Macro are there any other different type of Db objects available?
Finding the table size alone?
Hi All, How to find the table size alone? Not including the SI's and other stuffs related to a table. Thanks in advance.
size table size of table alone