Attachment Library for the Teradata Forum

The following attachments were included with posts to the TeradataForum and they have been placed here for access.

If you have an attachment that you would like to share with others, please forward it to the List Administrator and it will be placed here.

04/25/2008 (Fri)

Re: Extract values from field

Etienne Stieger

Attachments:	.txt (4kb) save as:	otranslate.c
	.txt (2kb)	oreplace1.c
	.txt (3kb)	oreplace2.c

02/22/2008 (Fri)

Re: Stale Stats query?

Dieter Noeth

Attachment:	.txt (30kb) save as:	Statistics.sql

12/14/2007 (Fri)

Re: Data BlockSize

Buck Swafford

Attachment:	.doc (34kb) save as:	DataBlockSize4-1.doc

12/03/2007 (Mon)

Re: Auto DB space add

Vinay Bagare

Attachment:	.txt (6kb) save as:	PR_Move_Space.sql

11/28/2007 (Wed)

Re: Chart CPU Utilization

Cornelius Meade

Attachment:	.xls (1.22mb) save as:	example_CPU_graph.xls

11/27/2007 (Tue)

Re: Chart CPU Utilization

Tejinder Luthra

Attachment:	.txt (13kb) save as:	acctgDetail_RefreshProcess.sql

09/11/2007 (Tue)

Re: View statistic values

Dieter Noeth

Attachment:	.txt (22kb) save as:	statistics.sql

08/14/2007 (Tue)

Re: Bteq SHOW TABLE export

Vinay Bagare

Attachment:	.zip (6kb) save as:	GenDDL_dir.zip

Contains:	.txt (2kb) save as:	Chk_Stat.bat
	.txt (5kb)	GenDDL.bat
	.txt (1kb)	logon.txt
	.txt (1kb)	Out.bat
	.txt (1kb)	Restart.BAT
	.txt (1kb)	CheckParm.bteq
	.txt (2kb)	GenBteq.bat
	.txt (1kb)	GenScript.Bat
	.txt (4kb)	GenShowDDL.bat
	.txt (2kb)	RunShowDLL.bat
	.txt (1kb)	T.bteq

05/02/2007 (Wed)

Re: Using a Macro to create the mload Script

Vinay Bagare

Attachments:	.txt (3kb) save as:	LoadSB.ml
	.txt (4kb)	GenMload.txt
	.txt (5kb)	Layout.txt
	.txt (1kb)	logon.txt
	.txt (1kb)	Out.txt
	.txt (11kb)	UpdIns.txt

02/20/2007 (Tue)

Re: Dependant objects

Vinay Bagare

Attachments:	.txt (68kb) save as:	SPDependency.bteq
	.txt (4kb)	Object_Dependency.txt

11/06/2006 (Mon)

Keyword list

Dieter Noeth

Attachments:	.txt (68kb) save as:	sql_keywords.txt
	.txt (4kb)	sql_keywords.btq

11/04/2006 (Sat)

Text editor

Geoffrey Rommel

Attachment:	.txt (11kb) save as:	sql_keywords.btq

10/16/2006 (Mon)

Re: Way to Copy Statistics.

Vinay Bagare

Attachment:	.zip (31kb) save as:	GenStats.zip

10/16/2006 (Mon)

Re: Need script for killing sessions automatically for particular user at particular time

Srikanth Kappagantula

Attachment:	.dat (3kb) save as:	perl script.dat

03/13/2006 (Mon)

Re: SQL to display tables and their total record count

Fred Keiser

Attachment:	.sql (4kb) save as:	tbl-rowcount.sql

09/26/2005 (Mon)

Re: Query to get the last space in a string.

Ulrich Arndt

Attachment:	.txt (3kb) save as:	SQLExample.txt

09/20/2005 (Tue)

Re: Essbase and Teradata.

James Judge

Attachments:	.pdf (260kb) save as:	AJI-and-OLAP-(document).pdf
	.pdf (221kb)	Hyperion-TeradataBestPractices-rel1.0.pdf

03/18/2005 (Fri)

Re: Docs/pointers to TD architecture

James Judge

Attachment:	.zip (2.80mb) save as:	McCormick_1_Wed_930am.zip

Contains:	.pdf (4.70mb)	McCormick_1_Wed_930am.pdf

03/15/2005 (Tue)

Re: TerMgr DataCollection for Priority Scheduler

Eric Paddock

Attachment:	.xls (82kb) save as:	MakeSchmon_v1.xls

03/03/2005 (Thr)

Re: Guidelines for Teradata Upgrade

James Judge

Attachment:	.pdf (728kb) save as:	Migr51.pdf

11/01/2004 (Mon)

Re: Stored Procedure: Error Raising

Roopali Doshi

Attachment:	.xls (18kb) save as:	DBCErrorMsgs.xls

06/14/2004 (Mon)

Re: Text getting truncated

Rishi Agarwal

Attachment:	.xls (18kb) save as:	Answer_truncate.xls

06/10/2004 (Thur)

Re: PS Worksheet

Carrie Ballinger

Attachment:	.xls (27kb) save as:	RelWt.xls

04/10/2004 (Sat)

Re: Multi value compression

Glen Blood

Attachments:	.doc (103kb) save as:	Compression Analysis Procedurerev1.doc
	.sql (4kb)	tablemacroddl.sql
	.sql (3kb)	proc.sql

04/09/2004 (Fri)

Date and Time Manipulation on Teradata

Jeff Ohlman

Attachment:	.doc (27kb) save as:	Date computations on Teradata.doc

02/27/2004 (Fri)

Standard Deviation formula

Sian Tong

Attachments:	.jpg (4kb) save as:	sd.jpg
	.jpg (14kb)	stddev_pop.jpg
	.jpg (14kb)	stddev_samp.jpg

02/20/2004 (Fri)

Converting Oracle PL/SQL to run with Teradata DW

Ron Crisafulli

Attachment:	.txt (10kb) save as:	SS_lerner_metric_old_tool.txt

01/30/2004 (Fri)

Re: Teradata <--> Excel transfers via OleLoad

Shawn Shealy

Attachment:	.rtf (37kb) save as:	OLDBXCEL.rtf

11/25/2003 (Tue)

Re: TD Manager v6.0 server

Donald Stubbs

Attachment:	.doc (128kb) save as:	TeradataManager6_WP.doc

07/27/2003 (Sun)

Re: Quick Reference

Mike Dempsey

Attachment:	.doc (180kb) save as:	QuickRef.doc

06/16/2003 (Mon)

Re: ra2td Td2Td

James Judge

Attachment:	.txt (3kb) save as:	Paradise_Skel.txt

Re: Query Explain Summary Tool (MS Access 2K)

Terry Stover

Attachments:	.zip (224kb) save as:	Teradata_Query_Explain.zip
	.zip (103kb)	Teradata_Query_Explain_97.zip

05/01/2003 (Thur)

Re: TPump vs Mload

Matthew Winter

Attachment:	.pdf (569kb) save as:	Richards ACCDLS.pdf

04/16/2003 (Wed)

Re: Named Pipe examples

Jeff Ohlman

Attachment:	.txt (4kb) save as:	monitor.pl

03/23/2003 (Sun)

Re: Anyone migrating to v2r5

Christian Schiefer

Attachment:	.xls (25kb) save as:	upgrade_v4.1.2_v5.xls

03/21/2003 (Fri)

Re: Max Load Tasks

Bob Hahn

Attachment:	.gif (13kb)	Fastload TPA vs Non-TPA Client

03/20/2003 (Thu)

Re: OUTMOD example for FASTEXPORT

Wayne Moran

Attachment:	.zip (4kb)	OUTMOD example for FASTEXPORT

Contains:	.txt (1kb) save as:	dwoutext.readme
	.txt (1kb) save as:	make.dwoutext1.sh
	.txt (1kb) save as:	dwoutex1.mk
	.txt (6kb) save as:	dwoutex1.c
	.txt (1kb) save as:	dw_kill_parnt_child.c

03/18/2003 (Tue)

Re: Teradata Manager Guide Lines

Pepper Lawrence

Attachment:	.pdf (855kb) save as:	Teradata Manager Getting Started
	.doc (278kb)	Teradata Manager Alert Actions
	.doc (155kb)	Monitoring Active Queries with TDM 5.0