Index for February 2004

<< January 2004

March 2004 >>

1 Feb (Sun)

[13:02]	Row and/or Column level security [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[14:48] [18:46]

2 Feb (Mon)

[11:00]	Abort NETVAULT [4 Posts]
	See Also:
	[12:13] [12:31] [13:49]

[11:01]	Stored Procedures - Pros & Cons [5 Posts]
	Within Index: [First] [Next] [Last]

[12:28]

NOTPA/RECONCILE [One Post]

[15:09]	No of Nodes on system [13 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[15:23] [15:28] [15:32] [15:58] [16:05] [16:11] [16:14] [16:18]

[15:44]	Fastload and TAB delimiter [7 Posts]
	Within Index: [First] [Last]
	See Also:
	[16:15] [16:16] [16:43] [16:57] [17:08]

[17:11]	Row Level Locking [2 Posts]
	See Also:
	[17:54]

3 Feb (Tue)

[02:01]	Re: Stored Procedures - Pros & Cons [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[10:49] [12:26]

[08:42]	Re: No of Nodes on system [13 Posts]
	Within Index: [First] [Prev] [Next] [Last]

[11:06]	Re: Row and/or Column level security [4 Posts]
	Within Index: [First] [Prev] [Last]

[12:20]	Query Performance [11 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[12:38] [13:38] [14:05] [18:07]

[16:12]	Re: Fastload and TAB delimiter [7 Posts]
	Within Index: [First] [Prev] [Last]

[16:15]	FastExport problem with lead [3 Posts]
	See Also:
	[16:55] [17:29]

[16:38]	FastLoad EBCDIC Files From a PC [2 Posts]
	Within Index: [First] [Last]

[17:07]	Reading FastLoad Error files [3 Posts]
	See Also:
	[17:18] [17:20]

[17:49]	Dynamic SQL inside SPL [4 Posts]
	See Also:
	[17:51] [17:55] [17:59]

[18:37]	UPDATE and OUTER JOIN [9 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[19:51] [22:20] [22:44]

[20:32]	Representing Nulls In a FASTEXPORT Output File [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:53]

[20:37]	Difference between Hard and Soft RI [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[21:13]

[21:29]	Is there an SQL error table? [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[23:01]

[21:34]	How to print heading one time only in a BTEQ query? [13 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[23:20]

4 Feb (Tue)

[00:21]	Re: Query Performance [11 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[13:53]

[09:11]	Re: UPDATE and OUTER JOIN [9 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[18:41] [22:29] [22:54]

[09:21]	RDBMS Crashed or Sessions Reset. Recovery in Progress [2 Posts]
	See Also:
	[14:51]

[09:32]	Re: Is there an SQL error table? [3 Posts]
	Within Index: [First] [Prev] [Last]

[09:36]	How to find the week-ending-date for a given date? [8 Posts]
	See Also:
	[10:14] [10:30] [11:13] [12:47] [13:37] [13:53] [18:07]

[10:03]	Error on multload [6 Posts]
	See Also:
	[10:45] [10:51] [11:55] [13:17] [14:00]

[12:02]	Re: FastLoad EBCDIC Files From a PC [2 Posts]
	Within Index: [First] [Last]

[13:47]	Re: How to print heading one time only in a BTEQ query? [13 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[17:32] [18:31] [18:42] [19:06] [19:31] [20:01] [20:03] [22:18]

	Control characters in fastexport output file [13 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[16:49] [17:54]

[14:43]	Re: Stored Procedures - Pros & Cons [5 Posts]
	Within Index: [First] [Prev] [Last]

[17:41]	Re: Representing Nulls In a FASTEXPORT Output File [3 Posts]
	Within Index: [First] [Prev] [Last]

[20:16]	Re: No of Nodes on system [13 Posts]
	Within Index: [First] [Prev] [Last]

5 Feb (Thu)

[08:39]	Re: UPDATE and OUTER JOIN [9 Posts]
	Within Index: [First] [Prev] [Last]

[08:41]	Re: Control characters in fastexport output file [13 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[08:42] [10:57] [13:55] [14:10] [14:30]

[13:34]	Re: No of Nodes on system [13 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[22:19]

[13:59]	Re: How to print heading one time only in a BTEQ query? [13 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[15:25]

[16:35]	Re: Difference between Hard and Soft RI [3 Posts]
	Within Index: [First] [Prev] [Last]

[17:57]	A weird and unusual circumstance... [8 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:21] [18:36] [19:54] [21:12]

[18:48]	Fastload Error 2652 [2 Posts]
	See Also:
	[19:33]

[20:11]	BTEQ Import, Variable Substitution Error [10 Posts]
	Within Index: [First] [Next] [Last]

[21:05]	Re: Query Performance [11 Posts]
	Within Index: [First] [Prev] [Next] [Last]

6 Feb (Fri)

[03:48]	Re: BTEQ Import, Variable Substitution Error [10 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[13:53] [20:49] [21:05] [21:13] [21:56]

[08:29]	Re: Control characters in fastexport output file [13 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[08:30] [10:23] [11:40]

[10:05]

How I can convert Decimal(13,0) value to timestamp, [One Post]

[11:52]	Procedure Error [2 Posts]
	See Also:
	[16:00]

[14:26]	Best advice on PPIs [3 Posts]
	Within Index: [First] [Next] [Last]

[15:46]	Multiload Error [3 Posts]
	Within Index: [First] [Next] [Last]

[16:49]	Re: A weird and unusual circumstance... [8 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[17:49] [19:05]

[17:27]	UNIX Processes [5 Posts]
	See Also:
	[21:19] [22:04] [22:11] [22:43]

[21:35]	QueryMan Performance??? [5 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[22:20]

[22:29]	Admin Comment: NCR Members who signed-up with @TERADATA-NCR.COM addresses [2 Posts]
	Within Index: [First] [Last]

7 Feb (Sat)

[00:09]	Re: QueryMan Performance??? [5 Posts]
	Within Index: [First] [Prev] [Last]

[08:20]	Re: Multiload Error [3 Posts]
	Within Index: [First] [Last]

9 Feb (Mon)

[03:43]	DBC.AccessLog [19 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[13:11] [15:57]

[08:34]	Re: Multiload Error [3 Posts]
	Within Index: [First] [Prev] [Last]

[11:30]	Stored Procedure Performance and Transposing Data [6 Posts]
	See Also:
	[12:18] [12:53] [13:08] [13:47] [16:48]

[12:17]

FastExport Error and Rejected Records [One Post]

[13:57]	Re: QueryMan Performance??? [5 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:58]

[14:34]	Re: BTEQ Import, Variable Substitution Error [10 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[20:01]

[17:09]	Re: Indexes vs statistics [7 Posts]
	Within Index: [First] [Prev] [Last]

[18:41]

Cognos report net [One Post]

[20:20]	Restoring cluster dump to a different configuration [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[22:28]

[23:09]	EXISTS predicate bug? [10 Posts]
	Within Index: [First] [Next] [Last]

10 Feb (Mon)

[00:36]	Re: EXISTS predicate bug? [10 Posts]
	Within Index: [First] [Last]
	See Also:
	[14:38]

[10:43]	AMP - Down Unable to Fetch the Rows [8 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[16:40] [20:54]

[13:34]	Re: Restoring cluster dump to a different configuration [6 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:55] [14:30] [17:40]

[19:21]	Distributed Data Warehousing Question [4 Posts]
	See Also:
	[19:37] [20:57] [21:12]

[19:28]	Re: DBC.AccessLog [19 Posts]
	Within Index: [First] [Prev] [Next] [Last]

[22:07]	Access to Macros [2 Posts]
	Within Index: [First] [Last]

[23:46]	Re: Query Performance [11 Posts]
	Within Index: [First] [Prev] [Last]

11 Feb (Tue)

[00:51]	Re: Query Performance [11 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[01:13]

[08:23]	Re: Best advice on PPIs [3 Posts]
	Within Index: [First] [Last]

[09:46]	Re: EXISTS predicate bug? [10 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[09:47] [16:02] [16:38] [17:09] [17:15] [17:22]

	Re: AMP - Down Unable to Fetch the Rows [8 Posts]
	Within Index: [First] [Prev] [Next] [Last]

[10:09]	Re: Admin Comment: NCR Members who signed-up with @TERADATA-NCR.COM addresses [2 Posts]
	Within Index: [First] [Last]

[10:11]	Oracle CLOB equivalent in Teradata [3 Posts]
	See Also:
	[10:23] [18:55]

[10:28]	Spool lookup [2 Posts]
	See Also:
	[10:59]

[17:24]	Question concerning Accessrights (or Roles) [2 Posts]
	See Also:
	[17:53]

[20:59]	Re: DBC.AccessLog [19 Posts]
	Within Index: [First] [Prev] [Last]

[23:16]	FastLoad or MultiLoad Sample script [5 Posts]
	Within Index: [First] [Next] [Last]

12 Feb (Wed)

[02:42]

TDQM Implementation [One Post]

[10:27]	Re: AMP - Down Unable to Fetch the Rows [8 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[19:49]

[10:28]	Re: FastLoad or MultiLoad Sample script [5 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[15:10]

[13:06]	Re: DBC.AccessLog [19 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[14:24] [15:33] [15:37] [16:22]

[13:48]	Re: Access to Macros [2 Posts]
	Within Index: [First] [Last]

[14:19]	V2R5.1 - Early Adopters [2 Posts]
	See Also:
	[17:40]

[15:12]	Query results in 3610 Error... [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:20] [15:48]

[16:34]

Calculate Average and Peak Disk Use [One Post]

[18:33]	Volatile table existence check [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:47] [18:56] [20:32]

[19:12]

DBC.DBQLogTbl [One Post]

[19:52]	Determining PPIs on a table [2 Posts]
	See Also:
	[20:35]

[20:19]

How to start? [One Post]

[21:17]	Different explains from queryman versus Session Information in Teradata Manager [4 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[21:38]

[21:39]

Too many Load/Unload sessions [One Post]

13 Feb (Thu)

[04:08]	Re: Volatile table existence check [5 Posts]
	Within Index: [First] [Prev] [Last]

[10:47]	Re: Query results in 3610 Error... [4 Posts]
	Within Index: [First] [Prev] [Last]

[10:53]	Opinions sought on Teradata web based training [2 Posts]
	Within Index: [First] [Last]

	Re: AMP - Down Unable to Fetch the Rows [8 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[20:45]

[12:05]	Conversion of milli seconds value to timestamp [2 Posts]
	See Also:
	[15:25]

[18:08]

Killing both mainframe and network sessions in a script. [One Post]

[18:24]	Table Block Size [2 Posts]
	Within Index: [First] [Last]

[20:12]	Teradata Error Code = 3850 - Creating A View [7 Posts]
	See Also:
	[20:50] [21:03] [21:08] [21:10] [21:31] [22:42]

[21:17]	BTEQ without any space between columns [10 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[21:44] [21:45]

[23:52]	A SQL Question [3 Posts]
	Within Index: [First] [Last]

14 Feb (Fri)

[01:01]	Re: A SQL Question [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[01:04]

[15:21]	Re: Different explains from queryman versus Session Information in Teradata Manager [4 Posts]
	Within Index: [First] [Prev] [Last]

[15:25]	Re: BTEQ without any space between columns [10 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[20:40]

[20:10]	Re: Table Block Size [2 Posts]
	Within Index: [First] [Last]

16 Feb (Mon)

[16:19]	Re: FastLoad or MultiLoad Sample script [5 Posts]
	Within Index: [First] [Prev] [Last]

[16:24]	Queryman 5.2 and the History window [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:48]

[19:30]	Warning 6813? [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[19:34] [19:35]

[20:26]	Re: Opinions sought on Teradata web based training [2 Posts]
	Within Index: [First] [Last]

17 Feb (Mon)

[01:33]	Re: Different explains from queryman versus Session Information in Teradata Manager [4 Posts]
	Within Index: [First] [Prev] [Last]

[10:10]	Unable to Login on Tpump [2 Posts]
	See Also:
	[11:19]

[11:54]	How to use variables in Triggers. [2 Posts]
	See Also:
	[13:15]

[13:16]	Re: Warning 6813? [4 Posts]
	Within Index: [First] [Prev] [Last]

[13:26]	Re: Queryman 5.2 and the History window [3 Posts]
	Within Index: [First] [Prev] [Last]

[13:36]	Re: BTEQ without any space between columns [10 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:42] [14:43] [15:58] [20:28]

[13:42]	How can I get the same column from several rows into one row output? [2 Posts]
	See Also:
	[14:02]

[15:10]

A problem with integer-varchar and slow loading [One Post]

[16:16]	Fast Export, Multi Load or INSERT/SELECT [5 Posts]
	See Also:
	[17:49] [18:59] [19:13] [20:24]

[23:55]

Insert Sel * on Partitioned Tables with V5.0 [One Post]

18 Feb (Wed)

[10:14]	No of AMPs across Nodes [2 Posts]
	See Also:
	[16:02]

[19:33]	EnableStepText cost? [2 Posts]
	Within Index: [First] [Last]

[19:41]	Inner Join on 1=1 [8 Posts]
	Within Index: [First] [Last]
	See Also:
	[21:14] [21:25] [22:01] [22:26] [22:37]

19 Feb (Thu)

[11:06]	Partition table architecture [2 Posts]
	See Also:
	[11:45]

[16:52]

XML in OUTMOD [One Post]

[18:07]

Re: System performance problem / standard methodology [One Post]

[23:03]	Re: BTEQ Import, Variable Substitution Error [10 Posts]
	Within Index: [First] [Prev] [Last]

20 Feb (Fri)

[08:56]	Re: EnableStepText cost? [2 Posts]
	Within Index: [First] [Last]

[08:59]	Error: Teradata can't be reached over this network [2 Posts]
	See Also:
	[20:59]

[09:00]	Simple question about a left outer join... [11 Posts]
	See Also:
	[09:51] [09:56]

[09:33]	Converting Oracle PL/SQL to run with Teradata DW [3 Posts]
	See Also:
	[10:58] [12:21]

[14:10]	CASE Expression Problem [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[14:42] [15:24] [17:06] [17:58]

[14:36]	Break even point for Multi value compression [3 Posts]
	See Also:
	[15:27] [15:52]

[15:16]	Insert Values problem [5 Posts]
	See Also:
	[15:24] [15:29] [16:28] [20:04]

[16:12]	Algorithm to separate string text using spaces [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:09]

[16:13]	Nested case statements [3 Posts]
	See Also:
	[16:47] [16:56]

[18:10]

Sel on IDCOL,TVM and Dbase tables performance issue [One Post]

21 Feb (Sat)

[09:40]	Re: Algorithm to separate string text using spaces [3 Posts]
	Within Index: [First] [Prev] [Last]

23 Feb (Mon)

[10:15]	How to import null values using Import Utility of SQL Assistant [3 Posts]
	See Also:
	[12:20] [14:42]

[11:10]	Re: FastLoad or MultiLoad Sample script [5 Posts]
	Within Index: [First] [Prev] [Last]

[11:11]	ET in Delete mload [2 Posts]
	See Also:
	[11:38]

[14:36]	Multi-column stats for secondary index elimination [2 Posts]
	Within Index: [First] [Last]

[15:06]	Mapping Kanji1 to Unicode while exporting [4 Posts]
	See Also:
	[15:18] [15:35] [20:27]

[15:46]	Row ID in Teradata [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[16:04]

[19:57]	Message "3705 Request executed in interpretive EVL mode" [3 Posts]
	See Also:
	[20:17] [23:38]

[21:06]	Queryman 6.1 and 6.2 [2 Posts]
	See Also:
	[21:40]

[21:16]	Number of Concurrent Fastloads/Fastexports/Multiloads [5 Posts]
	Within Index: [First] [Last]

[21:51]	Intense Query question [3 Posts]
	Within Index: [First] [Last]

[23:55]	Re: Inner Join on 1=1 [8 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[23:56]

24 Feb (Mon)

[00:12]	Re: CASE Expression Problem [6 Posts]
	Within Index: [First] [Prev] [Last]

[04:28]	Re: Intense Query question [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[13:13]

[04:35]	Re: Multi-column stats for secondary index elimination [2 Posts]
	Within Index: [First] [Last]

[08:57]	Insert/Select taking too much time [4 Posts]
	See Also:
	[10:45] [12:40] [13:56]

[12:24]	How to use DDL statements in Teradata procs [3 Posts]
	See Also:
	[13:12] [14:40]

[13:35]

Admin Comment: Reminder about the Jobs List [One Post]

[14:46]	constraints [2 Posts]
	See Also:
	[14:50]

[14:55]	Re: Number of Concurrent Fastloads/Fastexports/Multiloads [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:07] [15:24] [16:15]

[15:25]	See Two Cognos Measures at a time [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[19:10]

[16:18]	Script UNIX to disable users logons and kill active sessions [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[17:04]

[18:55]	Query Timeout question [9 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:19] [20:34] [20:56] [21:49] [22:06] [23:09]

[19:22]	AMP Cpu Skew [4 Posts]
	See Also:
	[20:20] [20:40] [20:52]

[19:39]	SQL Assist/Querman F5 and Import Data [2 Posts]
	See Also:
	[20:33]

[19:41]	Archive / Restore: copying a user and all its children [7 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:00] [20:17] [20:30] [20:55] [21:52]

25 Feb (Tue)

[02:59]	Re: Query Timeout question [9 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[09:33]

[09:34]	Export Import Utility in Terdata. [3 Posts]
	See Also:
	[10:00] [22:01]

[11:41]	Re: See Two Cognos Measures at a time [5 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:30] [13:33]

[11:42]	Table is not accessible [7 Posts]
	Within Index: [First] [Last]
	See Also:
	[16:01] [19:58]

[13:46]	Re: Archive / Restore: copying a user and all its children [7 Posts]
	Within Index: [First] [Prev] [Last]

[17:41]

Unable to write Accountstring into private profile [One Post]

[18:41]	CREATE TABLE...AS and when SIs are created. [5 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[18:59] [21:43]

26 Feb (Thu)

[14:01]	Import Data from .csv file to a table using MultiLoad [9 Posts]
	Within Index: [First] [Last]
	See Also:
	[14:35] [14:45] [14:51] [14:56]

[14:37]	Re: Table is not accessible [7 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[14:57] [15:33] [19:41]

[15:43]	Low Memory [2 Posts]
	See Also:
	[17:54]

[17:07]	Re: CREATE TABLE...AS and when SIs are created. [5 Posts]
	Within Index: [First] [Prev] [Last]

27 Feb (Thu)

[03:58]	Re: CREATE TABLE...AS and when SIs are created. [5 Posts]
	Within Index: [First] [Prev] [Last]

[08:42]	Re: Import Data from .csv file to a table using MultiLoad [9 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[12:17] [12:18] [13:31]

[11:09]	Standard Deviation formula [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[11:59] [12:30] [19:48]

[11:44]	Finding TDPID [5 Posts]
	See Also:
	[12:38] [13:32] [13:53] [15:17]

[12:16]	Multiload Import of CSV file with embedded commas [2 Posts]
	See Also:
	[16:01]

[13:50]	Derived tables on V2R5 [13 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[16:07] [16:30] [18:36] [18:37] [19:00] [21:25] [22:46]

[20:52]	Re: Script UNIX to disable users logons and kill active sessions [3 Posts]
	Within Index: [First] [Prev] [Last]

28 Feb (Sat)

[10:25]	Re: Derived tables on V2R5 [13 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[19:03]

[11:16]	MLoad Error 2644 [6 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[15:20] [19:49]

[20:46]	Delete Query on a huge table taking too much time [10 Posts]
	Within Index: [First] [Next] [Last]

29 Feb (Sun)

[11:38]	Re: MLoad Error 2644 [6 Posts]
	Within Index: [First] [Prev] [Last]

[13:35]	Re: Delete Query on a huge table taking too much time [10 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[14:19]

Last Modified: 17 Jun 2013