![]() |
Is there any easy way to find out any DELETES happened on a table or not with out parsing the qrylog table.
10 Mar 2016
| 1 comment
,
|
![]() |
Hi...
29 Sep 2015
| 2 comments
,
|
![]() |
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)
28 Aug 2015
| 1 comment
,
|
![]() |
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?
05 Jun 2015
| 1 comment
,
|
![]() |
Hi All and a Happy New Year.
12 Jan 2015
,
|
![]() |
Hi all -
05 Jan 2015
| 2 comments
,
|
![]() |
The problem:
24 Nov 2014
| 1 comment
,
|
![]() |
Hi, DELETE FROM Employee WHERE EmpNo <> :EmpNo and EmpName <> :Empname; UTY0805 RDBMS failure, 3537: A MultiLoad DELETE Statement is Invalid.
04 Mar 2014
| 1 comment
,
|
![]() |
Does anyone know why the mload delete task does not allow delete based on a primary index?
02 Apr 2013
| 3 comments
,
|
![]() |
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
11 Mar 2012
,
|
![]() |
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,
15 Jan 2012
| 4 comments
,
|
![]() |
Recently I encountered an interesting discussion with one of my fellow developer. I have a following scenario:
11 Oct 2011
| 4 comments
,
|
![]() |
.LOGTABLE sample_log;
02 Jun 2011
| 11 comments
,
|
![]() |
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
27 Apr 2011
| 4 comments
,
|
![]() |
This book provides information about Teradata MultiLoad, a product that provides an efficient way to deal with batch maintenance of large databases. Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in a Teradata Database.
01 Feb 2010
| 2 comments
,
|