Is there any easy way to find out any DELETES happened on a table or not with out parsing the qrylog table.
Do we have any dbc tables that captures this information.
 
 
 

Hi...
Quite new to BTEQ - but 5 years experience in SQL assistant.
Question is if there are default restrictions to "write" from BTEQ into a DB-table.
Now, in BTEQ I'm succesfull to logon and run the SQL...

Below delete is consuming 11K CPU.Need assistance to re-write the below delete sql to consume less CPU.

DELETE  FROM IMPORT_REFER_F AA WHERE ( AA.JOB_ID,  AA.JOB_HEADER_ID,AA.JOB_LINE_NUM,AA.JOB_IDN) 

IN (SELECT JOB_ID,JOB_HEADER_ID,JOB_LINE_NUM,JOB_IDN FROM IMPORT_REFER_S BB GROUP BY 1,2,3,4)

I am attempting to write a macro to delete and drop specific tables from a database.  Any suggestions on fixing this or a better method?
SQL Statement:
CREATE MACRO tbl_nme AS
(SELECT TABLENAME
FROM    DBC.TablesV

Hi All and a Happy New Year.
 
We have a new requirement to place a Join Index (that also happens to be ML-PPI) over two tables to aid performance for a Tactical Workload. The JI works well with excellent response times for a very large dataset. (One Table is 1.5Tb and the other 330Mb) The JI is 1.3Tb.

Hi all - 
I have a scenerio i need assistance with. My scenerio is as follows:
I am building a snapsot table that assigns a batchid everytime it is run. These Id's are NOT necessarily in sequential order, but are always of a numeric type (BIGINT). -- Example: 900,001 then 900,020 then 900,101 etc....

The problem:
I have a log table that will have a large number of individual inserts or rows each day(about 500).
I want to find a way to be able to delete all the lines that are for example more than 10 days old.
 

Hi,
I need to delete the rows from table in mload script which are not matching in the file.
Tried couples of ways but couldn't succeed.

DELETE FROM Employee WHERE EmpNo <> :EmpNo and EmpName <> :Empname;

UTY0805 RDBMS failure, 3537: A MultiLoad DELETE Statement is Invalid.

Does anyone know why the mload delete task does not allow delete based on a primary index?
I need the answer just out of curiosity.
 
Regards,
-Suhail

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
SOR|03/17/2012|2 -- This is a header

Hi all,

       i am new to teradata, and working as a teradata dba.

       if i delete one table from a database, what are the different possible ways to get back those table.

thanks in advance,

Recently I encountered an interesting discussion with one of my fellow developer.

I have a following scenario:

.LOGTABLE sample_log;
.LOGON hostname/user,password;
DROP TABLE WT_sampletable;
DROP TABLE ET_sampletable;
DROP TABLE UV_sampletable;
.BEGIN IMPORT MLOAD TABLES sampletable
CHECKPOINT 1000000 SESSIONS 4;
.LAYOUT TRANSACTION;
.FIELD filed1 * CHAR(11) NULLIF field1 = '';
.DML LABEL DELETE;

Hello,

We have a PDK V13.03.00.05-b106 test system at our customer site.

When we try to delete a certain VP-system within the 'Teradata Systems' admin portlet
the VP-system can be deleted at first and it does disappear.