Index for October 2003

<< September 2003

November 2003 >>

1 Oct (Wed)

[04:18]

Questions about the Locking Logger [One Post]

[09:49]	Database Query Log (DBQL) [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[12:26] [15:23]

[13:20]	Re: COGNOS Impromptu Scheduler [13 Posts]
	Within Index: [First] [Prev] [Last]

[13:23]	Teradata Archive/Recovery Util [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[14:55] [16:10] [17:38] [20:03]

[13:43]	BTEQ Export Syntax [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[21:24]

[14:30]	Plastic Steps [4 Posts]
	Within Index: [First] [Next] [Last]

[15:14]	Importing file into bteq query [7 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:38] [18:32] [21:25] [22:07]

[15:26]	Oracle Functions to Teradata Conversion [2 Posts]
	Within Index: [First] [Last]

[15:43]

MSR Problem [One Post]

[15:48]	Re: User/Database DDL [9 Posts]
	Within Index: [First] [Prev] [Last]

[16:27]	Derived Tables in V2R5 [11 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[20:40]

[17:22]	Re: NetVault and Cluster Archives [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[19:05]

[18:33]

OLE DB [One Post]

[21:18]	PSF Milestone Question [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[21:42]

[22:06]	Re: Could not open log file [6 Posts]
	Within Index: [First] [Prev] [Next] [Last]

2 Oct (Thu)

[07:16]	Re: Derived Tables in V2R5 [11 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[09:09] [10:53]

[07:59]	Re: BTEQ Export Syntax [4 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[12:50]

[08:00]	Re: Export results in a fixed format [4 Posts]
	Within Index: [First] [Prev] [Last]

	Re: Locking issue with views [7 Posts]
	Within Index: [First] [Prev] [Last]

[09:47]	Re: PSF Milestone Question [4 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[17:28]

[10:36]	Re: Importing file into bteq query [7 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[11:29]

[12:08]	Re: NetVault and Cluster Archives [5 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[12:54]

[13:00]	Re: Teradata Archive/Recovery Util [6 Posts]
	Within Index: [First] [Prev] [Last]

[13:02]	Re: Plastic Steps [4 Posts]
	Within Index: [First] [Last]

[13:19]	Re: Could not open log file [6 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[19:45]

[14:59]	Creating AMJ Files [3 Posts]
	Within Index: [First] [Last]

[18:04]	Re: Database Query Log (DBQL) [5 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[19:51]

[19:25]	Stored procedure rights [6 Posts]
	Within Index: [First] [Next] [Last]

[19:29]

Load Testing [One Post]

3 Oct (Fri)

[05:35]	Re: Creating AMJ Files [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:11]

[12:21]	Re: Export results in a fixed format [4 Posts]
	Within Index: [First] [Prev] [Last]

[13:44]	Re: Plastic Steps [4 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[18:11]

[16:52]	Securing Password in Dynamic Mload Script [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[17:58]

[16:57]	Re: Stored procedure rights [6 Posts]
	Within Index: [First] [Next] [Last]

[18:12]	Re: Could not open log file [6 Posts]
	Within Index: [First] [Prev] [Last]

[19:41]	What determines the size of table that will be duplicated [2 Posts]
	See Also:
	[21:31]

5 Oct (Sun)

[15:10]	Outer Join [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:46] [16:02] [16:27]

6 Oct (Mon)

[09:16]	Re: Outer Join [5 Posts]
	Within Index: [First] [Prev] [Last]

[15:11]	Re: Oracle Functions to Teradata Conversion [2 Posts]
	Within Index: [First] [Last]

[18:49]	Database Access -- Restricted mode [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:57]

7 Oct (Tue)

[05:44]	Dynamic Sql [2 Posts]
	See Also:
	[05:53]

[12:58]	Re: Database Access -- Restricted mode [3 Posts]
	Within Index: [First] [Prev] [Last]

[13:14]

Teradata and WebFocus ETL [One Post]

[17:17]	Disable logons [7 Posts]
	Within Index: [First] [Next] [Last]

[19:11]	Re: Securing Password in Dynamic Mload Script [3 Posts]
	Within Index: [First] [Prev] [Last]

[19:12]	Running OS Commands from within an mload script [6 Posts]
	Within Index: [First] [Next] [Last]

8 Oct (Wed)

[12:24]	Re: Running OS Commands from within an mload script [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[12:34] [18:26]

[14:27]

Teradata versus Oracle and DB2 [One Post]

[17:41]	INSERT/SELECT Problem [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[17:58] [18:05] [19:01]

[23:09]	Re: Disable logons [7 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[23:18]

9 Oct (Thu)

[03:21]	Re: Running OS Commands from within an mload script [6 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:55]

[09:42]	Teradata Error 2971 [2 Posts]
	See Also:
	[23:09]

Teradata ODBC creation issue on Unix environment! [One Post]

[13:39]	Re: INSERT/SELECT Problem [5 Posts]
	Within Index: [First] [Prev] [Last]

[17:19]	Re: Disable logons [7 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[19:00] [19:10]

[18:17]	Bitwise operations [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[19:48]

[19:30]	Guru needed: OLAP function quandary [2 Posts]
	See Also:
	[20:29]

[21:47]

DISSTART.EXE [One Post]

10 Oct (Fri)

[06:57]

Upgrade to V2R4.1.3.79 [One Post]

[09:53]	Teradata and Informatica [4 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[13:42]

[10:29]	Re: Bitwise operations [3 Posts]
	Within Index: [First] [Prev] [Last]

[11:41]	CSUM function [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[13:49] [15:11]

[19:29]	Teradata V2R5.0 Demo on WIN2K [5 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[20:00] [21:08]

11 Oct (Fri)

[02:16]	Re: Stored procedure rights [6 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[14:56]

[04:21]	Re: Teradata V2R5.0 Demo on WIN2K [5 Posts]
	Within Index: [First] [Prev] [Last]

13 Oct (Sun)

[04:17]	ADD_DAY in Teradata? [7 Posts]
	Within Index: [First] [Last]
	See Also:
	[12:00] [12:38] [18:02] [19:16]

[12:04]	Migrating Oracle to Teradata (I need help) [2 Posts]
	Within Index: [First] [Last]

[20:53]	Re: Stored procedure rights [6 Posts]
	Within Index: [First] [Prev] [Last]

[22:41]	Re: Teradata and Informatica [4 Posts]
	Within Index: [First] [Prev] [Last]

[22:43]	Re: Teradata V2R5.0 Demo on WIN2K [5 Posts]
	Within Index: [First] [Prev] [Last]

14 Oct (Mon)

[01:00]	Arcmain across different operating system [2 Posts]
	See Also:
	[14:11]

[11:50]	Fastload and nullif [6 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[14:09]

[11:58]	Re: ADD_DAY in Teradata? [7 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[12:46]

[12:41]	UDF Documentation [2 Posts]
	Within Index: [First] [Last]

Teradata into Informix? [One Post]

	Re: Teradata and Informatica [4 Posts]
	Within Index: [First] [Prev] [Last]

[13:22]	Re: Migrating Oracle to Teradata (I need help) [2 Posts]
	Within Index: [First] [Last]

[13:25]	Re: Stored procedure rights [6 Posts]
	Within Index: [First] [Prev] [Last]

[15:58]	MLOAD ERROR 3813 [7 Posts]
	Within Index: [First] [Last]

15 Oct (Wed)

[16:06]

Teradata JDBC Connection pool problem [One Post]

[16:43]	User Sessions [2 Posts]
	See Also:
	[16:48]

16 Oct (Wed)

[01:57]	Re: MLOAD ERROR 3813 [7 Posts]
	Within Index: [First] [Last]
	See Also:
	[03:29] [12:39] [14:41] [14:53] [16:22]

17 Oct (Thu)

[01:29]

Trigger questions [One Post]

[12:31]	Multiple Sessions [4 Posts]
	Within Index: [First] [Next] [Last]

[14:43]	References [12 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[23:13]

[17:40]

Error [3710]: Insufficient memory to parse this request, during Resolver phase. [One Post]

[23:04]	Mload of signed decimal input data [3 Posts]
	Within Index: [First] [Next] [Last]

[23:05]	Replace function in teradata??? [2 Posts]
	Within Index: [First] [Last]

[23:06]	Re: Fastload and nullif [6 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[23:11]

18 Oct (Fri)

[00:56]	Re: References [12 Posts]
	Within Index: [First] [Prev] [Next] [Last]

[01:44]	Re: Mload of signed decimal input data [3 Posts]
	Within Index: [First] [Last]

[03:43]	Re: Fastload and nullif [6 Posts]
	Within Index: [First] [Prev] [Last]

19 Oct (Sat)

[02:54]	Re: Mload of signed decimal input data [3 Posts]
	Within Index: [First] [Prev] [Last]

[04:55]	Re: Disable logons [7 Posts]
	Within Index: [First] [Prev] [Last]

[10:41]	Re: Multiple Sessions [4 Posts]
	Within Index: [First] [Next] [Last]

[18:23]

Restore Error [One Post]

20 Oct (Mon)

[12:43]	Re: References [12 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[14:09]

[13:07]	Partitoned Primary Indexes [2 Posts]
	See Also:
	[13:50]

[13:10]	Store Procedure [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[13:21]

[14:32]	Re: Replace function in teradata??? [2 Posts]
	Within Index: [First] [Last]

[14:33]	Re: Multiple Sessions [4 Posts]
	Within Index: [First] [Prev] [Last]

[15:16]	Space usage [5 Posts]
	See Also:
	[16:19] [16:49] [17:00] [18:53]

[15:29]	Data From Oracle [2 Posts]
	See Also:
	[16:21]

[16:51]

Fast Export script template [One Post]

[18:07]	SQL Against Teradata via COBOL Program [5 Posts]
	See Also:
	[18:10] [18:17] [18:28] [21:43]

21 Oct (Tue)

[09:28]	Re: Fastload and nullif [6 Posts]
	Within Index: [First] [Prev] [Last]

[09:29]	How to clear the aborting sessions? [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:10]

[12:04]	Re: References [12 Posts]
	Within Index: [First] [Prev] [Next] [Last]

[12:39]	Re: Store Procedure [3 Posts]
	Within Index: [First] [Prev] [Last]

[14:06]	Problem while giving select * against a table [3 Posts]
	See Also:
	[14:44] [15:31]

[14:52]	Re: UDF Documentation [2 Posts]
	Within Index: [First] [Last]

[16:19]	SQL Problem.. Help Needed [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[17:45] [18:39] [20:22]

22 Oct (Wed)

[08:00]	Re: SQL Problem.. Help Needed [6 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[15:37]

[10:13]	Re: How to clear the aborting sessions? [4 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[11:56]

[10:14]	Please solve this query [2 Posts]
	See Also:
	[13:10]

[11:25]	Date Casting inside IN Clause [2 Posts]
	See Also:
	[13:10]

[12:48]	Re: References [12 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:52] [14:33] [19:53] [20:13]

[13:25]	WITH clause not working [3 Posts]
	See Also:
	[13:55] [14:08]

[14:26]

Duplication or redistribution of spooled data [One Post]

[16:07]	2644 No more room in database DBNAME [3 Posts]
	See Also:
	[16:42] [16:45]

[19:01]	Question on 'sample' [2 Posts]
	See Also:
	[20:14]

23 Oct (Wed)

[00:40]	Re: References [12 Posts]
	Within Index: [First] [Prev] [Last]

[09:03]	Arithmetic operation on teradata timestamp [2 Posts]
	See Also:
	[09:21]

[10:22]

Fastload logon time [One Post]

[15:42]	How to purge content from DBC.DBQL tables [3 Posts]
	See Also:
	[16:52] [20:12]

[16:16]	Single Fastload with Multiple Files of Different Layouts? [2 Posts]
	See Also:
	[18:56]

[18:45]	Generate ddl [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:16]

24 Oct (Thu)

[00:24]	Re: Generate ddl [4 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[13:08]

[17:03]	A port snag when installing Ambeo (nee Pinecone) [9 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[17:25] [17:45]

[17:49]	Concatenate DATE and TIME(6) columns into Timestamp column [2 Posts]
	See Also:
	[20:39]

25 Oct (Fri)

[01:33]	Re: A port snag when installing Ambeo (nee Pinecone) [9 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[01:51]

[10:37]	How to use TD Manager Trends [2 Posts]
	Within Index: [First] [Last]

26 Oct (Sat)

[01:11]	Re: A port snag when installing Ambeo (nee Pinecone) [9 Posts]
	Within Index: [First] [Prev] [Next] [Last]

27 Oct (Mon)

[14:38]	Has anyone experienced a similar RDBMS failure, 8017? [5 Posts]
	See Also:
	[16:27] [18:12] [18:43] [21:30]

[15:49]	Re: How to use TD Manager Trends [2 Posts]
	Within Index: [First] [Last]

[16:30]	Start load utilities from WinDDI [3 Posts]
	See Also:
	[16:39] [19:47]

[16:57]	Re: A port snag when installing Ambeo (nee Pinecone) [9 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[17:40]

[18:48]	Is there any system column like the Oracle RowNum in Teradata? [14 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[20:39]

[19:49]	Problem while doing large to small table JOIN [8 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:13] [21:16] [21:46] [22:21] [22:37]

[20:42]	Experience with Locking Logger [5 Posts]
	Within Index: [First] [Next] [Last]

[22:00]	Using a NULLIF in FASTLOAD [2 Posts]
	See Also:
	[23:03]

[22:15]	Carriage Return and Line Feed in stored procedure Variable [2 Posts]
	Within Index: [First] [Last]

28 Oct (Mon)

[02:15]	Re: Experience with Locking Logger [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[03:42] [16:00]

	Re: Problem while doing large to small table JOIN [8 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[15:43]

[06:19]	Maximum sessions exceeded on MVS/TDP [2 Posts]
	See Also:
	[16:53]

[07:25]	Is the following correct ? [7 Posts]
	See Also:
	[08:56] [10:10] [10:11] [10:24] [13:21] [19:20]

[10:09]	Insert Select Timings for Implementing VLC ?? [2 Posts]
	See Also:
	[11:49]

[10:15]	Problem related to number [6 Posts]
	Within Index: [First] [Last]
	See Also:
	[17:24] [17:56] [19:17] [20:29]

[10:16]	Question on Teradata "internal error 3610" [7 Posts]
	Within Index: [First] [Last]
	See Also:
	[12:43] [14:33] [17:40] [17:58]

[10:21]	Re: Is there any system column like the Oracle RowNum in Teradata? [14 Posts]
	Within Index: [First] [Prev] [Next] [Last]
	See Also:
	[10:22] [10:39] [11:00]

[10:24]	Teradata data type equivalent to image datatype in sql server [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[11:51]

[10:59]	What do the following mean ? [10 Posts]
	Within Index: [First] [Last]
	See Also:
	[11:07] [12:10] [12:15] [12:21] [12:27] [15:42] [18:56]

[14:13]	Re: Carriage Return and Line Feed in stored procedure Variable [2 Posts]
	Within Index: [First] [Last]

[15:46]	Check table [2 Posts]
	See Also:
	[22:47]

[17:01]	Inserting Rows into tables with Secondary Indexes [6 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[17:10] [17:15]

[18:18]	Fastload size constraints [2 Posts]
	Within Index: [First] [Last]

[19:43]	AVERAGE Results? [5 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:05] [21:28] [23:11]

29 Oct (Wed)

[05:13]	Re: What do the following mean ? [10 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[15:39]

[08:03]	Re: Inserting Rows into tables with Secondary Indexes [6 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[08:32]

[08:31]	Keywords in Teradata [3 Posts]
	See Also:
	[10:42] [11:01]

[08:33]	Re: Teradata data type equivalent to image datatype in sql server [3 Posts]
	Within Index: [First] [Prev] [Last]

[10:59]	Re: Problem related to number [6 Posts]
	Within Index: [First] [Prev] [Last]

[11:04]	Re: Question on Teradata "internal error 3610" [7 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[12:40]

[14:24]	Re: Fastload size constraints [2 Posts]
	Within Index: [First] [Last]

[15:33]	Re: AVERAGE Results? [5 Posts]
	Within Index: [First] [Prev] [Last]

[17:39]	Multiple Step OLE DB error [3 Posts]
	Within Index: [First] [Next] [Last]

[19:22]	Anyone using Tivoli to display AWS alerts [3 Posts]
	Within Index: [First] [Last]

[21:24]	Re: CSUM function [4 Posts]
	Within Index: [First] [Prev] [Last]

30 Oct (Thu)

[00:58]	Unable to run Visual Explain with SQL Assistant [2 Posts]
	See Also:
	[16:12]

[10:24]	Problem related to Square [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[18:56] [18:59]

[10:27]	CPU for string operations [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[15:11]

[14:21]	Re: Multiple Sessions [4 Posts]
	Within Index: [First] [Prev] [Last]

[15:48]	Restore of procs and views [2 Posts]
	See Also:
	[18:49]

[19:47]	Concurrent Users [4 Posts]
	Within Index: [First] [Last]
	See Also:
	[20:07] [20:59]

[22:05]	Re: Multiple Step OLE DB error [3 Posts]
	Within Index: [First] [Last]

[23:25]	Re: Experience with Locking Logger [5 Posts]
	Within Index: [First] [Prev] [Last]

31 Oct (Fri)

[00:23]	Re: Problem related to Square [4 Posts]
	Within Index: [First] [Prev] [Last]

[08:33]	Determining spool allocations on development based on allocations in production [3 Posts]
	See Also:
	[11:17] [12:32]

[11:19]	Square of number [2 Posts]
	Within Index: [First] [Last]

[11:20]	Number of sessions for mload / fastload [6 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[18:06] [19:16]

	Moving Oracle Dump File to Teradata [13 Posts]
	Within Index: [First] [Next] [Last]
	See Also:
	[13:08] [15:55] [16:12] [16:27] [17:03] [22:06] [22:12] [23:15]

[13:48]	Re: Concurrent Users [4 Posts]
	Within Index: [First] [Prev] [Last]

[13:54]	Re: Multiple Step OLE DB error [3 Posts]
	Within Index: [First] [Prev] [Last]

[14:23]	Re: CPU for string operations [3 Posts]
	Within Index: [First] [Prev] [Last]

[15:18]

Index Use [One Post]

[16:24]	Re: Anyone using Tivoli to display AWS alerts [3 Posts]
	Within Index: [First] [Last]
	See Also:
	[17:09]

[17:28]	Re: Is there any system column like the Oracle RowNum in Teradata? [14 Posts]
	Within Index: [First] [Prev] [Last]
	See Also:
	[17:40] [17:41] [17:50] [17:57] [19:02] [19:06]

[18:47]	Input data to fastexport [4 Posts]
	See Also:
	[19:11] [19:28] [21:35]

Last Modified: 20 May 2013