Home Page for the TeradataForum
 
 

 

Index for December 2004


 
<< November 2004 January 2005 >>


1 Dec     (Wed)


[08:45] Re: Dates not hashing evenly [7 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [09:01] [12:07] [13:41]



[09:10] Re: PPI with ERwin [2 Posts]
 

Within Index: [First]   [Last]  



[16:42] Statistics Problems [7 Posts]
 

Within Index: [First]   [Next]   [Last]  

 

SEE Also:
  [20:30] [21:38] [22:37]



[16:50] Re: Do Triggers really need Perm Space???? [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[17:04] Re: Question on Bynet Traffic [2 Posts]
 

Within Index: [First]   [Last]  



[17:53] Accesslog type queries from dbql [7 Posts]
 

SEE Also:
  [18:21] [19:00] [20:24] [20:42] [20:59] [21:19]



[17:54] ("1=1") condition in the explain plan [14 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [18:17] [18:24] [19:20] [19:39] [21:05] [22:56] [22:57] [22:57]



[18:41] PPI Interval : MONTH vs DAY [5 Posts]
 

Within Index: [First]   [Last]  




2 Dec     (Wed)


[00:18] Re: ("1=1") condition in the explain plan [14 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [14:06] [15:21] [15:29] [18:11]



[01:23] Re: Database Space [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[09:19] Re: PPI Interval : MONTH vs DAY [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [11:42] [12:21] [22:09]



[14:00] Why would collecting stats make things worst? [6 Posts]
 

SEE Also:
  [15:18] [16:30] [16:44] [18:01] [18:18]



[15:05] Running multiple teradata scripts [6 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [15:49] [17:56] [20:35]



[15:28] SpoolSpace Question [3 Posts]
 

SEE Also:
  [16:36] [16:46]



[16:38] Re: Dates not hashing evenly [7 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[20:13] UPDATE Question [4 Posts]
 

SEE Also:
  [20:45] [20:55] [21:15]



[21:32] Best way of writing SQL to retrieve a sample [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [22:48]



[22:15] Bad Characters [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [22:31]




3 Dec     (Thu)


[00:01] Re: Running multiple teradata scripts [6 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [13:22]



[09:44] Re: Bad Characters [4 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [10:11]



[09:58] Volatile /Temporary Tables in SQL [3 Posts]
 

SEE Also:
  [14:59] [18:17]



[11:56] V2R5 BEGIN LOGGING [One Post]



[12:17] Teradata Manager Data Collection [2 Posts]
 

SEE Also:
  [15:12]



[13:20] AMPs and cluster [2 Posts]
 

SEE Also:
  [15:07]



[14:46] How Many Utility Jobs? [2 Posts]
 

SEE Also:
  [16:01]



[15:51] Re: Best way of writing SQL to retrieve a sample [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[17:22] OLE-DB TOOL [2 Posts]
 

SEE Also:
  [18:14]



[19:33] Data Generation tools/Data encryption [3 Posts]
 

Within Index: [First]   [Next]   [Last]  




4 Dec     (Sat)


[10:06] COALESCE() Troubles [2 Posts]
 

SEE Also:
  [11:36]




5 Dec     (Sun)


[16:13] Why is Group-by Faster than Distinct [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [19:19]



[21:37] Variable Declarations in Queryman [6 Posts]
 

Within Index: [First]   [Last]  




6 Dec     (Sun)


[00:44] Re: Variable Declarations in Queryman [6 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [09:21] [15:04] [15:37] [20:36]



[00:58] Re: Why is Group-by Faster than Distinct [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[13:33] Re: Data Generation tools/Data encryption [3 Posts]
 

Within Index: [First]   [Last]  



[16:25] Error 2641 - table was restructured [9 Posts]
 

Within Index: [First]   [Next]   [Last]  

 

SEE Also:
  [17:17] [18:37] [23:52]



[18:07] Re: Statistics Problems [7 Posts]
 

Within Index: [First]   [Prev]   [Last]  




7 Dec     (Tue)


[08:24] Re: Error 2641 - table was restructured [9 Posts]
 

Within Index: [First]   [Prev]   [Next]   [Last]  

 

SEE Also:
  [13:25]



[09:34] Numeric to string Conversion and a single column [8 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [10:52] [12:37] [12:37] [13:09] [13:40] [14:56]



[12:25] Ferret PackDisk Basic Questions [5 Posts]
 

Within Index: [First]   [Next]   [Last]  



[21:31] Mload external loader error WRT_8004, WRT_8068 [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [23:59]



[21:32] View the date field in dbc.oldpasswords table [11 Posts]
 

Within Index: [First]   [Next]   [Last]  

 

SEE Also:
  [21:51]



Delete/drop partition in a PPI table [3 Posts]
 

Within Index: [First]   [Last]  




8 Dec     (Wed)


[09:45] Re: Numeric to string Conversion and a single column [8 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[09:46] Re: Mload external loader error WRT_8004, WRT_8068 [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[09:48] BTEQ Export with newline function? [6 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [10:12] [13:41] [14:41] [14:48]



[10:00] Re: View the date field in dbc.oldpasswords table [11 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [10:31] [12:10] [15:00] [15:52] [16:23] [16:32] [17:05]



[10:21] Re: Delete/drop partition in a PPI table [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [13:41]



[11:33] Re: Statistics Problems [7 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [15:45]



[12:20] Re: Error 2641 - table was restructured [9 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [17:00]



[14:46] Question on PICKBEST in CRM [One Post]



[16:05] SQL assistant 6.2 and Primary Key [4 Posts]
 

SEE Also:
  [17:10] [17:13] [17:24]



[16:58] Capture Spool of a query [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [18:41]



[18:40] Unusable DECIMAL(17) [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [19:07] [19:22]




9 Dec     (Thu)


[09:02] Re: Ferret PackDisk Basic Questions [5 Posts]
 

Within Index: [First]   [Next]   [Last]  



[11:18] Re: Error 2641 - table was restructured [9 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[14:42] Re: Capture Spool of a query [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[14:46] How to run cnsterm on windows demo software [2 Posts]
 

SEE Also:
  [17:51]



[16:22] SQL Assistant Version 6.2.0 [7 Posts]
 

SEE Also:
  [16:47] [17:28] [19:48] [21:03] [21:19] [21:29]



[16:41] Re: View the date field in dbc.oldpasswords table [11 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[16:47] Re: Unusable DECIMAL(17) [5 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [19:21]



[17:51] BTEQ Cast Decimal to Char on MVS [2 Posts]
 

Within Index: [First]   [Last]  




10 Dec     (Thu)


[02:33] Re: BTEQ Cast Decimal to Char on MVS [2 Posts]
 

Within Index: [First]   [Last]  



[16:28] BTEQ Inport and Export in same process(s) on MVS [One Post]



[17:39] Fast export / BTEQ output to Excel file [3 Posts]
 

SEE Also:
  [18:00] [18:05]



[20:39] Teradata Equivalent of an Oracle Query "Product" [3 Posts]
 

SEE Also:
  [20:51] [22:21]



[20:42] Alert Policy and controlling access to dbcmngr.alertcontrol [2 Posts]
 

Within Index: [First]   [Last]  



[21:24] Performace impact of adding rows to ACESSLOG [2 Posts]
 

Within Index: [First]   [Last]  



[22:58] BTEQ Format Question: Justify, zerofill and truncate [3 Posts]
 

Within Index: [First]   [Last]  




11 Dec     (Sat)


[11:04] Re: Ferret PackDisk Basic Questions [5 Posts]
 

Within Index: [First]   [Prev]   [Last]  




12 Dec     (Sun)


[09:17] Re: Ferret PackDisk Basic Questions [5 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [09:19]



[14:31] Re: Performace impact of adding rows to ACESSLOG [2 Posts]
 

Within Index: [First]   [Last]  




13 Dec     (Mon)


[11:33] Finding View information [10 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [12:12] [12:26] [14:09] [15:09]



[11:53] Native Mcicosoft\Teradata Connection (ADO Driver) [2 Posts]
 

Within Index: [First]   [Last]  



[15:09] Re: Finding View Info [One Post]



[18:47] TDQM documentation [2 Posts]
 

SEE Also:
  [19:31]



[20:32] DUMP/RESTORE access right granting [7 Posts]
 

Within Index: [First]   [Next]   [Last]  




14 Dec     (Tue)


[06:32] Re: Finding View information [10 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [09:53] [11:12] [12:30] [12:44]



[12:14] Explorer Tree in SQL Assistant [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [22:42]



[12:30] Re: BTEQ Format Question: Justify, zerofill and truncate [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [15:50]



[12:44] Re: BTEQ Export with newline function? [6 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[16:19] System migration - Info on and migration to V2R5.x [One Post]



[18:38] LOBs in Teradata. [4 Posts]
 

Within Index: [First]   [Last]  



[19:15] Multiload using VARTEXT from Mainframe [2 Posts]
 

Within Index: [First]   [Last]  



[20:45] Dmteq testing on Teradata Manager 61 [4 Posts]
 

Within Index: [First]   [Last]  



[22:43] Re: DUMP/RESTORE access right granting [7 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [23:34]




15 Dec     (Wed)


[07:54] Re: Dmteq testing on Teradata Manager 61 [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [09:12] [14:52]



[09:13] UNIX Password reuse enhansement [3 Posts]
 

SEE Also:
  [13:24] [15:43]



[09:14] Re: LOBs in Teradata. [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [11:22] [14:10]



[12:00] Re: Explorer Tree in SQL Assistant [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  



[17:21] Re: DUMP/RESTORE access right granting [7 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [17:41] [17:53] [18:48]




16 Dec     (Thu)


[10:56] Reserved Words and Teradata Warehosue Builder [One Post]



[10:57] Left-over spool table found : transaction aborted [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [11:14] [13:03]



[11:10] Re: Native Mcicosoft\Teradata Connection (ADO Driver) [2 Posts]
 

Within Index: [First]   [Last]  



[18:32] Help with subselect within a case statement [3 Posts]
 

SEE Also:
  [19:07] [20:33]




17 Dec     (Fri)


[08:33] Specification of 'Cycle' and 'Start with' option of identity column [2 Posts]
 

SEE Also:
  [12:05]



[13:40] Re: Left-over spool table found : transaction aborted [4 Posts]
 

Within Index: [First]   [Prev]   [Last]  




18 Dec     (Fri)


[07:10] Useful Data Dictionary Index Queries - Index Column Crosstab [One Post]



[07:12] Useful Data Dictionary Index Queries - PI Column Crosstab with Table Skew & Variance [One Post]



[07:13] Useful Data Dictionary Queries - Mismatched Data Types [One Post]



Useful Data Dictionary Index Queries - NUSI without matching PI [One Post]



[07:18] Useful Data Dictionary Queries - Generate DDL to Add & Drop Soft RI Constraints [One Post]



[07:19] PI Assessment Stored Procedure - Calc Skew & Dupe PI Count Summary Statistics for Candidate PI's [One Post]




19 Dec     (Sun)


[21:00] Re: Multiload using VARTEXT from Mainframe [2 Posts]
 

Within Index: [First]   [Last]  




20 Dec     (Mon)


[14:32] Interval in a where clause [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [15:01]



[14:48] Reason for this logon behavior [One Post]



[17:26] Identifying tables with partitioned primary index [2 Posts]
 

Within Index: [First]   [Last]  




21 Dec     (Tue)


[05:06] Re: Interval in a where clause [4 Posts]
 

Within Index: [First]   [Prev]   [Last]  

 

SEE Also:
  [09:47]



[09:49] Best Approach to Recursive Queries without CONNECT BY [5 Posts]
 

Within Index: [First]   [Next]   [Last]  



[14:19] Implementation of self Join in teradata [One Post]



[14:41] Personalization authority? [2 Posts]
 

SEE Also:
  [15:04]



[21:27] Re: Identifying tables with partitioned primary index [2 Posts]
 

Within Index: [First]   [Last]  




22 Dec     (Wed)


[16:48] Connection Error: 10065 WSA E HostUnreach [4 Posts]
 

Within Index: [First]   [Last]  



[17:34] Useful DD Index Queries - PI Column Crosstab with Table Skew & Variance CORRECTION [2 Posts]
 

SEE Also:
  [22:45]




23 Dec     (Thu)


[00:25] Re: Connection Error: 10065 WSA E HostUnreach [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [10:31] [18:00]




24 Dec     (Fri)


[11:26] Selecting days & hours difference [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [16:13]



[11:27] Database re-sizing ... need help/advice with main focus on system performance [One Post]




27 Dec     (Mon)


[09:10] Re: Selecting days & hours difference [3 Posts]
 

Within Index: [First]   [Prev]   [Last]  




28 Dec     (Tue)


[10:23] Any doc on NPARC [3 Posts]
 

Within Index: [First]   [Last]  




29 Dec     (Wed)


[09:51] Re: Any doc on NPARC [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [10:24]



[13:42] Fallback, Journaling or Both [One Post]



[15:11] TPUMP Log Files [2 Posts]
 

SEE Also:
  [16:23]



[15:25] Fastload from within DTS [4 Posts]
 

Within Index: [First]   [Next]   [Last