Index for August 2005

<< July 2005

September 2005 >>

1 Aug (Mon)

[15:34]	Writing UDF for Numeric Datatypes [8 Posts]
	Within Index: [First] [Next] [Last]

[17:52]	Re: Beta Test Invitation from Ward Analytics [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:40] [19:00] [20:29]

[20:00]	Collect Stats in a Procedure [11 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[21:05]

[21:31]	Cast to Decimal - Error 2679 [4 Posts]
	Within Index: [First] [Next] [Last]

2 Aug (Tue)

[07:18]	Re: Collect Stats in a Procedure [11 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[12:24] [13:08] [21:30] [23:09]

[10:07]	What's the Max value for the Float data type? [4 Posts]
	See Also:
	[11:15] [12:24] [13:24]

[10:14]	What is Terdata SQL? [5 Posts]
	See Also:
	[10:43] [10:48] [12:20] [12:22]

[13:24]	Re: Writing UDF for Numeric Datatypes [8 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[15:03]

[16:37]	Correlating Multiple Views and Join Views to Base Tables [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:04] [20:22]

[18:43]	Re: Bteq interaction with MS Domains causing .logon to hang [4 Posts]
	Within Index: [First] [Prev] [Last]

[18:47]	Need help in accessing SQL Server table from Teradata [4 Posts]
	See Also:
	[20:22] [20:22] [21:47]

[18:48]	Teradata connection from PERL [3 Posts]
	Within Index: [First] [Last]

3 Aug (Tue)

[02:28]	Re: Cast to Decimal - Error 2679 [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[10:27]

[02:39]	Re: Writing UDF for Numeric Datatypes [8 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[09:17]

[09:18]	Oracle to Teradata migration [6 Posts]
	See Also:
	[10:40] [11:34] [13:01] [13:52] [14:20]

[10:03]	Subquery in Explain [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[19:11]

[10:55]	Re: Correlating Multiple Views and Join Views to Base Tables [4 Posts]
	Within Index: [First] [Prev] [Last]

[14:53]	Re: Collect Stats in a Procedure [11 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[19:11]

[18:32]	Fw: ResUsage info..need help analysing [2 Posts]
	See Also:
	[19:21]

[19:09]	Re: Teradata connection from PERL [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[19:52]

[21:16]	ODBC 3.04.00.00 and MS Access [6 Posts]
	Within Index: [First] [Next] [Last]

4 Aug (Thu)

[07:44]	Re: Subquery in Explain [3 Posts]
	Within Index: [First] [Prev] [Last]

[08:47]	Re: ODBC 3.04.00.00 and MS Access [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[08:51] [10:12] [10:17]

[08:48]	Realtime DW: Msg Qs [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[10:00] [11:19]

[08:50]	Re: Collect Stats in a Procedure [11 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:19]

[13:22]	Re: Writing UDF for Numeric Datatypes [8 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[15:14]

[13:33]	How to Identify LOCKS using Data Dictionary and Queries. [9 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[14:52]

[14:17]	How to Concatenate Column Values using SQL/Macros [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[16:28] [18:10] [18:11]

[18:13]	Optimizer and Transitive Property of Equality [10 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:58] [19:12] [19:27] [19:35]

5 Aug (Thu)

[00:40]	Re: Optimizer and Transitive Property of Equality [10 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[08:13] [08:56] [10:09] [13:36]

[01:12]	BTEQ export [7 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[10:04] [10:08] [13:34]

[08:54]	Re: How to Identify LOCKS using Data Dictionary and Queries. [9 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[08:57] [13:31] [15:03] [19:06]

[08:55]	PMON Overhead [8 Posts]
	See Also:
	[09:52] [10:07] [13:33] [15:03] [15:24] [21:25] [23:15]

[11:50]	SQL Assistant Import [5 Posts]
	See Also:
	[13:50] [13:56] [14:41] [15:28]

[13:32]	Re: Realtime DW: Msg Qs [4 Posts]
	Within Index: [First] [Prev] [Last]

	Plan and execution traces [2 Posts]
	See Also:
	[16:58]

[13:34]	Re: How to Concatenate Column Values using SQL/Macros [5 Posts]
	Within Index: [First] [Prev] [Last]

[13:39]	Good practice programming in TD [3 Posts]
	See Also:
	[16:07] [21:06]

[13:57]	Standard Deviation [2 Posts]
	See Also:
	[14:36]

[14:00]	Question about CLI error: EM_GSSINITFAIL(235) [5 Posts]
	See Also:
	[14:51] [16:06] [16:13] [17:11]

6 Aug (Fri)

[03:52]	Re: BTEQ export [7 Posts]
	Within Index: [First] [Prev] [Last]

[08:36]	Re: Writing UDF for Numeric Datatypes [8 Posts]
	Within Index: [First] [Prev] [Last]

[21:32]	Regarding usage Of MAX function [4 Posts]
	Within Index: [First] [Last]

7 Aug (Sat)

[04:26]	Re: Regarding usage Of MAX function [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[10:15] [10:55]

[19:44]	Re: ODBC 3.04.00.00 and MS Access [6 Posts]
	Within Index: [First] [Prev] [Last]

8 Aug (Mon)

[09:42]	Experiences with ETL Tools [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[12:49] [19:20]

[20:24]	Error code -1 when executing replace procedure statement [6 Posts]
	Within Index: [First] [Last]

9 Aug (Tue)

[09:39]	Re: Experiences with ETL Tools [4 Posts]
	Within Index: [First] [Prev] [Last]

[10:23]	BTEQ export to CSV file and large numbers [9 Posts]
	Within Index: [First] [Last]
	See Also:
	[12:49] [12:50] [14:06] [14:18]

[13:18]

MLoad error - UTY0805 RDBMS failure, 3857: Cannot use value [One Post]

[14:24]	Re: Error code -1 when executing replace procedure statement [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:09] [18:53] [20:26] [20:54]

[15:04]	Unique Secondary Index Conundrum [2 Posts]
	See Also:
	[15:43]

[17:45]	Re: Cast to Decimal - Error 2679 [4 Posts]
	Within Index: [First] [Prev] [Last]

[21:26]	Teradata Stored Procedures and ETL [2 Posts]
	Within Index: [First] [Last]

10 Aug (Tue)

[01:45]	Re: BTEQ export to CSV file and large numbers [9 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[11:11] [11:29] [12:10]

[12:15]	Re: MERGE INTO [2 Posts]
	See Also:
	[13:32]

[13:28]	Re: Teradata Stored Procedures and ETL [2 Posts]
	Within Index: [First] [Last]

[16:07]	Mass update & dummy tpump job [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[16:28] [17:06]

[17:42]	BTEQ and comments anomaly [2 Posts]
	Within Index: [First] [Last]

11 Aug (Thu)

[09:39]	Fixed width files from FastExport [8 Posts]
	See Also:
	[12:44] [13:21] [13:50] [14:55] [15:31] [15:58] [18:31]

[09:42]	Help need on Tricky SQL [8 Posts]
	Within Index: [First] [Last]
	See Also:
	[10:24] [10:52] [11:18] [11:19] [15:44] [23:47]

[13:27]	Re: Mass update & dummy tpump job [4 Posts]
	Within Index: [First] [Prev] [Last]

[13:48]	Re: BTEQ and comments anomaly [2 Posts]
	Within Index: [First] [Last]

[14:02]	Teradata Manager Upgrade 6.1 to 7.0 [6 Posts]
	See Also:
	[14:48] [15:29] [15:31] [16:00] [21:09]

[14:54]	Topics for training [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[17:35] [21:46] [23:41]

[15:18]	Primary Index vs Single Condition [4 Posts]
	See Also:
	[15:59] [17:12] [17:55]

[17:36]	zos 1.6 anyone running it ? [3 Posts]
	Within Index: [First] [Last]

[18:16]	Finding the earliest combination of separate DATE and TIME fields [6 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[20:32] [20:32]

12 Aug (Fri)

[08:22]	Re: How to Identify LOCKS using Data Dictionary and Queries. [9 Posts]
	Within Index: [First] [Prev] [Last]

[08:23]	Re: Finding the earliest combination of separate DATE and TIME fields [6 Posts]
	Within Index: [First] [Prev] [Next] [Last]

[08:24]	Re: zos 1.6 anyone running it ? [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[13:59]

[08:25]	ROWID based join! [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[09:17] [09:28] [19:52] [20:53]

[09:20]	Re: Topics for training [5 Posts]
	Within Index: [First] [Prev] [Last]

[10:00]	Re: Help need on Tricky SQL [8 Posts]
	Within Index: [First] [Prev] [Last]

[18:37]	Explain Analysis [3 Posts]
	Within Index: [First] [Last]

14 Aug (Sun)

[16:35]	How to Substring data [3 Posts]
	Within Index: [First] [Last]

[16:36]	Re: How to Identify LOCKS using Data Dictionary and Queries. [9 Posts]
	Within Index: [First] [Prev] [Last]

[16:37]	DAYOFWEEK Function and BTEQ [6 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[18:42]

15 Aug (Mon)

[09:08]	Re: ROWID based join! [6 Posts]
	Within Index: [First] [Prev] [Last]

[10:15]	Impact of Huge Access Rights Table [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[21:53]

[12:03]	Re: DAYOFWEEK Function and BTEQ [6 Posts]
	Within Index: [First] [Prev] [Last]

[13:57]	Re: How to Substring data [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:10]

16 Aug (Tue)

[12:49]	Re: Explain Analysis [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[19:51]

[12:57]	Re: Impact of Huge Access Rights Table [3 Posts]
	Within Index: [First] [Prev] [Last]

[14:07]	set role ALL [3 Posts]
	See Also:
	[14:31] [16:34]

17 Aug (Wed)

[10:15]	Generating Oracle's chr(10) [5 Posts]
	See Also:
	[11:32] [11:37] [11:50] [13:35]

[13:52]	Deleting Duplicate rows [15 Posts]
	Within Index: [First] [Last]
	See Also:
	[14:47] [15:35]

[14:18]	Current Query that is being executed by any user. [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:13]

[15:33]	Load order of Fast Load Utility [2 Posts]
	See Also:
	[16:07]

[16:53]

ExtendedFetch with MicroStrategy [One Post]

[18:09]	Oracle Date [3 Posts]
	See Also:
	[19:15] [19:29]

[19:14]	Re: Finding the earliest combination of separate DATE and TIME fields [6 Posts]
	Within Index: [First] [Prev] [Last]

[19:37]	Permissions to DBC.Databases / DBC.Tables [6 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[22:05]

[21:12]	Exception handler [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[22:05] [22:17]

18 Aug (Thu)

[08:03]	Re: Deleting Duplicate rows [15 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[08:17] [08:59]

[08:04]	Re: Permissions to DBC.Databases / DBC.Tables [6 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[08:05] [13:41]

	Re: Exception handler [4 Posts]
	Within Index: [First] [Prev] [Last]

[08:06]	Re: Current Query that is being executed by any user. [4 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[18:07]

[08:07]	Using IDCs in tables [3 Posts]
	See Also:
	[09:26] [11:53]

[10:26]	Re: Finding the earliest combination of separate DATE and TIME fields [6 Posts]
	Within Index: [First] [Prev] [Last]

[13:35]	Multi-Value compression of a Sec-Idx and ipact on Multi-Load [5 Posts]
	Within Index: [First] [Last]

[16:03]	Data modeling consideration [3 Posts]
	Within Index: [First] [Last]

19 Aug (Fri)

[08:10]	Re: Data modeling consideration [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[13:17]

[13:49]	Re: Permissions to DBC.Databases / DBC.Tables [6 Posts]
	Within Index: [First] [Prev] [Last]

[18:10]	Loading an XLS file [9 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:51] [19:26] [19:32] [19:49] [20:21] [21:30]

22 Aug (Mon)

[08:18]	Re: Multi-Value compression of a Sec-Idx and ipact on Multi-Load [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[12:17] [17:07] [19:00]

[09:57]	Problem Executing a macro [2 Posts]
	See Also:
	[12:16]

[10:50]	How to stop Roll Back with out making table Invalid. [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[14:05]

[15:06]	Re: DAYOFWEEK Function and BTEQ [6 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[17:48] [19:01]

[17:42]	How do I use the NOT CS clause in the IN CLAUSE ? [2 Posts]
	Within Index: [First] [Last]

23 Aug (Tue)

[11:19]	Re: How do I use the NOT CS clause in the IN CLAUSE ? [2 Posts]
	Within Index: [First] [Last]

[11:34]	Re: How to stop Roll Back with out making table Invalid. [4 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[12:39]

[17:08]	Unexpected handling of duplicate results [3 Posts]
	See Also:
	[17:28] [20:35]

[19:06]	Stored Procedure Integer Input Parameter Handling [3 Posts]
	Within Index: [First] [Next] [Last]

[20:12]	Error 5764 Lobs are not allowed to be selected on record and indicator modes [2 Posts]
	See Also:
	[21:27]

24 Aug (Wed)

[14:53]	Is USI useful for avoiding NUPI row check [3 Posts]
	See Also:
	[15:20] [15:40]

25 Aug (Thu)

[11:47]	Time Stamp for Last Update [2 Posts]
	See Also:
	[17:10]

[22:03]	Row to Column Function [6 Posts]
	Within Index: [First] [Next] [Last]

26 Aug (Thu)

[01:31]	Re: Row to Column Function [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[02:09] [14:44] [15:49]

[07:35]	Re: Loading an XLS file [9 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:26]

[14:19]	Admin Comment: Changes to the TeradataForum [2 Posts]
	Within Index: [First] [Last]

[16:46]	Different Data Types and Performance [3 Posts]
	Within Index: [First] [Next] [Last]

29 Aug (Mon)

[09:50]	Problem with with Decimal field in Fast Export [6 Posts]
	See Also:
	[12:16] [13:35] [16:37] [16:41] [18:02]

[11:48]

Unix FastExport problem [One Post]

[12:53]	Need help on MULTITOOL [4 Posts]
	Within Index: [First] [Last]

[16:39]	Re: Different Data Types and Performance [3 Posts]
	Within Index: [First] [Last]

[17:43]	Re: BTEQ export [7 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[18:17]

30 Aug (Tue)

[08:49]	Re: Different Data Types and Performance [3 Posts]
	Within Index: [First] [Prev] [Last]

[08:50]	Re: Need help on MULTITOOL [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[08:51] [20:16]

[11:05]	Analytical function and datatype 'date' [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[11:44] [20:27]

[16:48]

Deadlocking between ARC and SQL? [One Post]

31 Aug (Wed)

[08:12]	Re: Row to Column Function [6 Posts]
	Within Index: [First] [Prev] [Last]

[08:53]	Access all rows in DBC.Users [7 Posts]
	Within Index: [First] [Next] [Last]

Last Modified: 28 Jun 2020

Attachments

Library

Quick Reference