Home Page for the TeradataForum
 
 

 

Index for June 2004


 
<< May 2004 July 2004 >>


1 Jun     (Tue)


[13:08] Why <> need a full table scan [2 Posts]
 

SEE Also:
  [14:18]



[13:10] Active DataWarehouse Vs Data Warehouse [One Post]



[14:16] Admin Comment: Trouble with Laptop [2 Posts]
 

Within Index: [First]   [Last]  



[17:10] Re: Teradata on a Linux Platform [16 Posts]
 

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



[22:00] Re: Exclusion Joins [10 Posts]
 

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




2 Jun     (Wed)


[00:14] Re: Teradata on a Linux Platform [16 Posts]
 

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



[07:04] Re: Exclusion Joins [10 Posts]
 

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

 

SEE Also:
  [15:05] [23:07]



[15:08] JDBC and JAVA Develper's Kit compatability [One Post]



[16:05] TTU 7.1 Pricing [3 Posts]
 

SEE Also:
  [16:46] [17:40]



[16:06] Newline char (or any other ASCII char) in a VARCHAR field [3 Posts]
 

SEE Also:
  [16:58] [23:04]



[18:21] JDBC / JAVA [2 Posts]
 

SEE Also:
  [22:16]




3 Jun     (Thu)


[07:51] Re: Exclusion Joins [10 Posts]
 

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



[13:08] Performance issue while creating View [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [14:01]



[13:10] Performance problem while creating a volatile table [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [13:38]



[15:44] Re: Teradata on a Linux Platform [16 Posts]
 

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




4 Jun     (Fri)


[06:36] Re: Teradata on a Linux Platform [16 Posts]
 

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



[12:25] VPN for CCL/NCR [One Post]



[15:22] Order of predicates [2 Posts]
 

SEE Also:
  [15:55]




6 Jun     (Sun)


[14:29] Formatting string to DATE [6 Posts]
 

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



[14:50] TTU 7.1 Arcmain on MP-RAS - 2 GB file limit [One Post]



[20:56] Re: Admin Comment: Trouble with Laptop [2 Posts]
 

Within Index: [First]   [Last]  




7 Jun     (Mon)


[08:34] Re: Formatting string to DATE [6 Posts]
 

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



[15:39] Re: Performance issue while creating View [3 Posts]
 

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



[19:39] VB ADO & Teradata ODBC 3.02.00.09 [5 Posts]
 

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



[20:04] PS Worksheet [3 Posts]
 

Within Index: [First]   [Last]  




8 Jun     (Tue)


[05:09] Equivalent Of PPI On MYSQL [One Post]



[10:06] Re: Formatting string to DATE [6 Posts]
 

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

 

SEE Also:
  [16:15]



[11:07] Feactures of FastExport [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [11:19] [12:44] [12:48]



[12:43] About Spool Numbering [9 Posts]
 

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



[12:46] Teradata Install: Could not create libtsl.dll link [2 Posts]
 

Within Index: [First]   [Last]  



[12:47] Getting 3802 Error in Fast Load [2 Posts]
 

SEE Also:
  [14:11]



[12:59] Re: Performance problem while creating a volatile table [4 Posts]
 

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

 

SEE Also:
  [14:33]



[13:56] Re: Teradata on a Linux Platform [16 Posts]
 

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



[15:40] Re: VB ADO & Teradata ODBC 3.02.00.09 [5 Posts]
 

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




9 Jun     (Tue)


[00:23] Re: Teradata Install: Could not create libtsl.dll link [2 Posts]
 

Within Index: [First]   [Last]  



[07:08] Re: Formatting string to DATE [6 Posts]
 

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

 

SEE Also:
  [13:05]



[09:58] What are ad-hoc queries ? [One Post]



[09:59] Re: Feactures of FastExport [5 Posts]
 

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



[10:00] Re: About Spool Numbering [9 Posts]
 

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

 

SEE Also:
  [11:26]



[10:53] Session Limits on Loads [6 Posts]
 

SEE Also:
  [12:30] [12:46] [13:05] [13:28] [14:47]



[13:55] Re: VB ADO & Teradata ODBC 3.02.00.09 [5 Posts]
 

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

 

SEE Also:
  [14:27]




10 Jun     (Thu)


[08:31] How do I CAST a numeric into a numeric? [4 Posts]
 

SEE Also:
  [08:57] [08:58] [10:31]



[11:37] Re: About Spool Numbering [9 Posts]
 

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



[12:53] Strange error in case of UNION inside a INSERT-SELECT query [One Post]



[13:00] Re: VB ADO & Teradata ODBC 3.02.00.09 [5 Posts]
 

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



[14:53] Null or compress zeros [6 Posts]
 

SEE Also:
  [15:31] [15:55] [16:08] [16:26] [16:37]



[15:03] BTEQ update with CASE [3 Posts]
 

SEE Also:
  [15:15] [15:31]



[15:08] Performance Improvement on this Query without Collecting Statistics [11 Posts]
 

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

 

SEE Also:
  [15:48] [16:16] [16:17]



[19:08] Re: PS Worksheet [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [21:09]




11 Jun     (Fri)


[06:50] Implementation checklist [2 Posts]
 

SEE Also:
  [14:57]



[07:52] Re: About Spool Numbering [9 Posts]
 

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



[13:21] Re: Performance Improvement on this Query without Collecting Statistics [11 Posts]
 

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

 

SEE Also:
  [14:53]



[21:11] AMP worker tasks [10 Posts]
 

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

 

SEE Also:
  [22:02] [22:56]



[21:14] Experiences with TDQM [One Post]




12 Jun     (Fri)


[01:17] Re: Performance Improvement on this Query without Collecting Statistics [11 Posts]
 

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

 

SEE Also:
  [10:45] [15:30] [20:23] [22:30]



[15:29] Data Truncation Problem [3 Posts]
 

SEE Also:
  [16:15] [19:32]



[16:28] Re: AMP worker tasks [10 Posts]
 

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

 

SEE Also:
  [16:46]




14 Jun     (Mon)


[11:17] How to find tables not backed up [3 Posts]
 

SEE Also:
  [18:26] [18:52]



[11:31] Re: AMP worker tasks [10 Posts]
 

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

 

SEE Also:
  [17:41] [17:57] [19:50] [21:13]



[15:40] Text getting truncated [2 Posts]
 

Within Index: [First]   [Last]  




15 Jun     (Tue)


[09:07] How to take Teradata backup [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [12:15] [13:48] [15:07]



[12:54] Mload delete and Bteq Delete [4 Posts]
 

SEE Also:
  [13:12] [13:15] [16:57]



[17:52] Re: Text getting truncated [2 Posts]
 

Within Index: [First]   [Last]  



[21:14] MVS JCL for MQ Access/TPUMP [2 Posts]
 

Within Index: [First]   [Last]  




16 Jun     (Wed)


[15:43] How to identify numerics in alphanumerics ? [6 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [15:55] [16:17]



[16:06] Fastexport manual inconsistency [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [17:49]



[17:35] Password Security in BTEQ [One Post]



[23:09] OLE Load problem when loading data [One Post]




17 Jun     (Thu)


[08:09] Re: Fastexport manual inconsistency [5 Posts]
 

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

 

SEE Also:
  [08:55] [09:04]



[09:15] How to identify number in alphanumerics field? [3 Posts]
 

SEE Also:
  [11:55] [21:15]



[09:16] Re: How to take Teradata backup [5 Posts]
 

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



[09:30] Re: How to identify numerics in alphanumerics ? [6 Posts]
 

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

 

SEE Also:
  [11:44] [12:04]



[11:29] Target table was restructured resubmit [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [12:03]



[11:32] How to do Export / Import of any database with data? [3 Posts]
 

SEE Also:
  [12:37] [12:38]



[11:59] OLE DB Timeout Issue [One Post]



[13:49] Can we use a wild card in arcmain [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [15:21] [17:03]



[15:21] Truncating SQL in ODBC Trace Log? [One Post]



[15:23] Decimal 18 Precision and Numeric Overflow [2 Posts]
 

SEE Also:
  [15:54]



[17:04] Performance of Multistatement Query with DELETE/INSERT-SELECT [One Post]



[19:33] ERROR on load DATE field with BTEQ [3 Posts]
 

SEE Also:
  [19:56] [19:58]



[19:34] ERROR on using SAS to load teradata database [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [20:54]



.Net App and Timeouts - persistent connection - PSF [One Post]



[19:43] Can we check stats automatically [7 Posts]
 

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



[19:57] Looking for most efficient technique [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [21:05]



[20:54] Calculating Minutes between Timestamps [3 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [22:43]




18 Jun     (Fri)


[05:28] Re: Target table was restructured resubmit [4 Posts]
 

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

 

SEE Also:
  [11:30]



[07:40] Re: Calculating Minutes between Timestamps [3 Posts]
 

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



[07:43] Re: Looking for most efficient technique [3 Posts]
 

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



[07:48] Re: Can we check stats automatically [7 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [14:04] [15:10] [15:11] [20:27]



[08:53] Re: Can we use a wild card in arcmain [4 Posts]
 

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



[09:34] Re: MVS JCL for MQ Access/TPUMP [2 Posts]
 

Within Index: [First]   [Last]  



[15:20] When is enough enough ? [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [15:22] [16:10] [20:50]



[15:23] Slow Responding State - looking for bottleneck [4 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [16:25] [17:07]



[21:55] During MLOAD, is there a way to re-route to a flat file rows that fails to load? [5 Posts]
 

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



[23:04] Re: About Spool Numbering [9 Posts]
 

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

 

SEE Also:
  [23:09] [23:14] [23:16]




19 Jun     (Sat)


[07:52] Re: When is enough enough ? [5 Posts]
 

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




20 Jun     (Sun)


[15:58] Re: During MLOAD, is there a way to re-route to a flat file rows that fails to load? [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [19:10]



[18:48] Question relating to triggers [4 Posts]
 

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




21 Jun     (Mon)


[07:41] Estimated I/Os shows up as NEGATIVE in SI [One Post]



[12:29] Re: Can we check stats automatically [7 Posts]
 

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



[13:12] Returning a Resultset from a Stored Procedure [4 Posts]
 

SEE Also:
  [13:45] [15:34] [15:37]



[14:35] Re: During MLOAD, is there a way to re-route to a flat file rows that fails to load? [5 Posts]
 

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

 

SEE Also:
  [15:59]



[14:46] Re: Slow Responding State - looking for bottleneck [4 Posts]
 

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



[15:34] The isClose() Function always returns a value of True [One Post]



[15:35] What is JOURNAL [One Post]



[15:37] AMP Worker Tasks and Skewed Queries [8 Posts]
 

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

 

SEE Also:
  [22:36]



[18:15] Availability of User Manuals [One Post]



[21:10] Releasing Internal Locks [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [22:47] [22:53]




22 Jun     (Tue)


[08:03] Re: ERROR Writing a Stored Procedure?? [7 Posts]
 

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



[09:38] Re: Question relating to triggers [4 Posts]
 

Within Index: [First]   [Last]  



[10:57] Re: Releasing Internal Locks [5 Posts]
 

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

 

SEE Also:
  [12:24]



[11:44] Is it possible to manipulate activity count? [6 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [11:56] [13:36] [13:39] [13:51]



[12:30] Will the Hash value change? [2 Posts]
 

SEE Also:
  [13:32]



[12:53] Performance of COUNT(Integer Constant) over COUNT(*) [2 Posts]
 

Within Index: [First]   [Last]  



[13:38] About RoundHalfwayMagUp in BTEQ Session Level [4 Posts]
 

SEE Also:
  [14:06] [14:43] [16:03]




23 Jun     (Wed)


[08:31] Collect stats and Group by difference [8 Posts]
 

SEE Also:
  [09:31] [11:24] [12:59] [12:59] [13:14] [14:30] [16:07]



[08:33] Re: Is it possible to manipulate activity count? [6 Posts]
 

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



[09:30] How to select row numbers with something like rownum [6 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [14:08] [16:33] [16:43] [16:59]



[16:55] Error in Ab Initio MultiLoad component [5 Posts]
 

Within Index: [First]   [Last]  

 

SEE Also:
  [17:39] [18:16]



[17:33] Not sure why the indices are needed. [One Post]



[17:38] Ampusage CPU Skew vs Diskspace Spool skew [One Post]



[18:06] Re: ERROR on using SAS to load teradata database [3 Posts]
 

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




24 Jun     (Thu)


[07:38] Re: Error in Ab Initio MultiLoad component [5 Posts]
 

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

 

SEE Also:
  [14:24]



[07:53] Re: Performance of COUNT(Integer Constant) over COUNT(*) [2 Posts]
 

Within Index: [First]   [Last]  



[09:45] Duplicate Table across all AMPs [7 Posts]
 

Within Index: [First]   [La