Attachment Library for the TeradataForum

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

08/02/2015 (Sun)

AccessRights reporting macros: 2015 Version

David Wellman

Attachment:	.txt (4kb) save as:	readme.txt
	.txt (11kb) save as:	show_all_database_rights_latin_tables.txt
	.txt (10kb) save as:	show_all_database_rights_latin_views.txt
	.txt (10kb) save as:	show_all_database_rights_unicode_tables.txt
	.txt (10kb) save as:	show_all_database_rights_unicode_views.txt
	.txt (11kb) save as:	show_all_user_rights_latin_tables.txt
	.txt (9kb) save as:	show_all_user_rights_latin_views.txt
	.txt (10kb) save as:	show_all_user_rights_unicode_tables.txt
	.txt (9kb) save as:	show_all_user_rights_unicode_views.txt
	.zip (22kb) save as:	access_rights.zip

06/17/2014 (Tue)

Database access rights macros: AllDatabaseRights & AllUserRights

David Wellman

Attachment:	.txt (6kb) save as:	show_all_database_rights_latin.txt
	.txt (6kb) save as:	show_all_database_rights_unicode.txt
	.txt (6kb) save as:	show_all_user_rights_latin.txt
	.txt (6kb) save as:	show_all_user_rights_unicode.txt

05/22/2014 (Thur)

Accessrights reporting macro - updated version

David Wellman

Attachment:	.txt (6kb) save as:	show_all_user_rights_latin.txt
	.txt (6kb) save as:	show_all_user_rights_unicode.txt

09/04/2013 (Wed)

Re: Converting Byte filed to Hexadecimal

Geoffrey Rommel

Attachment:	.txt (919 bytes) save as:	rawtohex.c
	.txt (278 bytes) save as:	rawtohex_cf.txt

04/15/2013 (Mon)

Accessrights reporting macro - updated version

David Wellman

Attachment:	.txt (6kb) save as:	show_all_user_rights_latin.txt
	.txt (6kb) save as:	show_all_user_rights_unicode.txt

01/16/2013 (Wed)

Re: Collect Stats Report

Taimur Khan

Attachment:	.txt (7kb) save as:	stale_stats.tpt

04/04/2012 (Wed)

Re: Error in TPT Stream script

Murali R

Attachment:	.txt (7kb) save as:	abhi.tpt

03/05/2012 (Mon)

Re: Debugging a procedure

Simson D'Silva

Attachment:	.pdf (82kb) save as:	Global Temporary Trace Table.pdf

01/13/2012 (Fri)

Generate collect statistics statement

Joe Gleason

Attachment:	.txt (28kb) save as:	JK_proc.txt

11/10/2011 (Mon)

Re: Stored Procedures - Cursor Processing

Geoffrey Rommel

Attachment:	.zip (5kb) save as:	stat_values.zip

05/20/2011 (Sun)

Re: Find the number of rows of all tables in a database?

John Wight

Attachment:	.txt (5kb) save as:	TableRowCount.spl

05/09/2011 (Mon)

Re: ODBC from Access to Teradata failed

Faible Mou

Attachment:	.txt (529kb) save as:	SQL1-LOG.txt

01/02/2011 (Sun)

Re: Teradata connection through REXX.

John Aldrin

Attachment:	.zip (48kb) save as:	REXX-scripts-MVS.zip

11/26/2010 (Fri)

Re: Pros and Cons of Stored Procedures

John Wight

Attachment:	.txt (2kb) save as:	TDATA_ADWStats_Source.ddl

05/31/2010 (Mon)

New version of stats query for TD12.0.3.1/TD13.0.0.21

Dieter Noeth

Attachment:	.txt (18kb) save as:	statistics_views_32+64-bit.sql
	.txt (31kb) save as:	statistics_64-bit.sql
	.txt (31kb) save as:	statistics_32-bit.sql
	.pdf (83kb) save as:	Teradata Statistics.pdf

09/15/2009 (Tue)

Re: UDFs and unicode symbols

Geoffrey Rommel

Attachment:	.c (2kb) save as:	c2b_u.c

10/19/2009 (Fri)

New stats query

Dieter Noeth

Attachment:	.txt (16kb) save as:	statistics_views_32+64.sql
	.txt (31kb) save as:	statistics_64-bit.sql
	.txt (31kb) save as:	statistics_32-bit.sql
	.pdf (81kb) save as:	Teradata Statistics.pdf

07/08/2009 (Wed)

Re: Block Update and Block Insert

Visakh C R

Attachment:	.pdf (389kb) save as:	6.3 Mload.pdf

10/24/2008 (Fri)

Re: Replacing unprintable text

Geoffrey Rommel

Attachment:	.txt (1kb) save as:	translate3.c
	.txt (1kb) save as:	translate3_cf.txt

09/02/2008 (Tue)

New version of statistics query

Dieter Noeth

Attachment:	.txt (29kb) save as:	statistics_32-bit.sql
	.txt (30kb) save as:	statistics_64-bit.sql
	.pdf (81kb) save as:	Teradata Statistics.pdf

08/22/2008 (Fri)

Re: Skewed Table - Space usage v/s AMP Colocation

Yasir Maken

Attachment:	.ppt (151kb) save as:	Disk Skew - What can it cause.ppt

07/25/2008 (Fri)

Re: Paging and Memory Allocation Fails

Yasir Maken

Attachment:	.doc (32kb) save as:	How-to-measure-and-assess-memory-utilization.doc

07/24/2008 (Thur)

Re: Can't save TDWM rule-sets

Lynn Nichols

Attachment:	.pdf (2.6mb) save as:	Teradata-Manager-User-Guide.pdf

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

11/01/2004 (Mon)

Re: Stored Procedure: Error Raising

Roopali Doshi

Attachment:	.xls (18kb) save as:	DBCErrorMsgs.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

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