Home Page for the TeradataForum
 
 

 

Sample Subjects from the Archives


 

The Archives of the Teradata Forum contains over 25,000 posts and the threads below are a representative sample.

To help navigate the Archives, there are additional indexes:

- For a list of the most recent threads, see: Recent Threads

- Yearly Indexes containing the threads posted during a given year, for example: 2007 Index

- By-Date Indexes containing the threads posted during a given month and year, for example: January 2008 Index


The best way to find threads on a specific subject is to use the search box.

 
 
Sample Threads

"NOT LIKE ANY" [Jan 2005 - 14 Posts]

"Wrapping" a column in Bteq export [Feb 2009 - 2 Posts]



%TYPE and %ROWTYPE equivalent in Teradata [Dec 2008 - 3 Posts]



("1=1") condition in the explain plan [Dec 2004 - 14 Posts]

(WM) Utility Throttle [May 2008 - 6 Posts]



.compile bteq file location [Aug 2008 - 2 Posts]

.NET Provider error: Teradata session is busy another request [May 2008 - One Post]

.net XML [Apr 2008 - 2 Posts]



10040: 10040 WSA E MsgSize: Message too long [Oct 2004 - 3 Posts]

104 TERADATA TABLES IN A SINGLE MLOAD [Jul 2006 - 23 Posts]



2 infiles in Multiload [Oct 2007 - 8 Posts]

21 digits number [Jun 2006 - 8 Posts]

2550? [Jan 2009 - One Post]

2616 numeric overflow while calculating huge numbers [Mar 2005 - 3 Posts]

2616: Numeric overflow occurred during computation. [Apr 2009 - 12 Posts]

2620 in Stored Procedure using Dynamic SQL [Mar 2009 - One Post]

2644, No more room in database DBC [Apr 2006 - 5 Posts]

2644:NO MORE ROOM IN DATA BASE [Nov 2005 - 3 Posts]



32bit ODBC on a Windows 2003 Server 64bit [Mar 2009 - 2 Posts]

3504: selected non-aggregate values must be part of the associated group [Mar 2005 - 8 Posts]

3527 error - Format string 'YYYYMMDDHHMISS' has combination of numeric, character and GRAPHIC values [Jul 2006 - 2 Posts]

3535: A character string failed conversion to a numeric value. [Nov 2005 - 12 Posts]

3540: Number of tables in join exceeds Parser [Apr 2006 - 3 Posts]

3610 Error while deleting records [Jun 2006 - 3 Posts]

3610: Internal error: Please do no resubmit the last request. [May 2004 - 7 Posts]

3637 error message seems inconsistent [Feb 2008 - 4 Posts]

3702: Insufficient memory to parse this request [Apr 2004 - 14 Posts]

3706 Error in WITH clause [Jun 2008 - 3 Posts]

3706 Syntax error: Data Type does not match a Defined Type name [Jul 2007 - 10 Posts]

3706: Syntax error: expected something between ')' and '+' [Dec 2006 - 9 Posts]

3706: Syntax Error [May 2004 - 3 Posts]

3710: Insufficient memory to parse this request, during Optimizer phase [Jul 2007 - 3 Posts]

3714: Insufficient memory [Jun 2007 - 9 Posts]

3806: Table/view/trigger name 'table1' is ambiguous. [Dec 2006 - 3 Posts]

3816: The positional parameter list has too few values [Feb 2008 - 6 Posts]

3841 Diagnostic CONVERT not allowed if logons are enabled [Dec 2006 - 4 Posts]



5142 cycl pack Error [Nov 2005 - 3 Posts]

5728: Partitioning violation for table TARGET [Jun 2007 - 11 Posts]

5862: C/C++ compiler is not installed [Jan 2008 - 9 Posts]



64 bit ODBC install error [May 2009 - One Post]



7547: Target row updated by multiple source rows [Jun 2007 - 4 Posts]



A Fast Export Issue [Mar 2004 - 4 Posts]

A new forum for Teradata [Jun 2004 - 3 Posts]

A problem using the RANDOM() function [Oct 2001 - 3 Posts]

A query on the PI properties of Teradata [Feb 2006 - 11 Posts]

A question about intervals [Oct 2002 - 3 Posts]

A question on Left Join [Dec 2007 - 20 Posts]

A SQL Question [Feb 2004 - 3 Posts]

A weird and unusual circumstance... [Feb 2004 - 8 Posts]

Ab Initio & Mload/TPump system variables [Mar 2005 - 2 Posts]

Ab Initio Documentation [Jul 2004 - 3 Posts]

Ab-Initio and "AMP lock table overflow" [Mar 2004 - 8 Posts]

Abends on Multiload and Recovery [Nov 2002 - 3 Posts]

Abort a query if it exceeds time limit [Mar 2006 - 4 Posts]

Abort idle sessions for specific users [May 2009 - One Post]

Abort NETVAULT [Feb 2004 - 4 Posts]

Abort RESPONDING sessions [May 2005 - 5 Posts]

Abort Session from BTEQ [Mar 2001 - 26 Posts]

ABORTED SESSION TAKES TOO LONG TO ABORT [Sep 2005 - 3 Posts]

Aborting idle sessions in Teradata [Dec 2003 - 9 Posts]

Aborting the transaction [Jun 2003 - 6 Posts]

Aborting user queries [Aug 2008 - 3 Posts]

Aborting user sessions [Jun 2000 - 14 Posts]

About Oracle and Teradata [Aug 1999 - 9 Posts]

About Release Lock [Jul 2005 - 3 Posts]

About RoundHalfwayMagUp in BTEQ Session Level [Jun 2004 - 4 Posts]

About Spool Numbering [Jun 2004 - 9 Posts]

Accent Insensitive Matches [Feb 2007 - 11 Posts]

ACCEPTable in Fastload / BTEQ [Jun 2000 - 5 Posts]

Access all rows in DBC.Users [Aug 2005 - 7 Posts]

Access Lock with PI Selection [May 2004 - 3 Posts]

Access Log Overhead at V2R5 [Jul 2004 - 4 Posts]

Access Logging and changing the log table [Jul 2002 - 8 Posts]

Access Logging and Denials [Mar 2003 - 11 Posts]

Access logging and utilities [Sep 2000 - 8 Posts]

Access Logging Question [Jun 2001 - 13 Posts]

Access Module Error (In UNIX)? [Oct 2002 - 3 Posts]

Access Module Not Found? [May 2003 - 5 Posts]

Access Modules performance - NamedPipes(on NT) Vs MQ Series (on MVS) [Jul 2002 - 4 Posts]

Access Rights : Privilege Codes [Jan 2005 - 5 Posts]

Access rights codes details [Aug 2008 - 3 Posts]

Access to Views but not to tables. [Jul 2006 - 4 Posts]

Accessing Data across two servers [Sep 2005 - 6 Posts]

Accesslog type queries from dbql [Dec 2004 - 7 Posts]

AccessRights in the Dictionary [Mar 2009 - 2 Posts]

Accessrights to execute a macro... [Dec 2003 - 4 Posts]

Account Name to set for the user for implementing priority scheduler. [Oct 2006 - 6 Posts]

Account string [May 2003 - 5 Posts]

Accountnames for Teradata installed UserIDs [Sep 2005 - 7 Posts]

Acct strings [Aug 2000 - 3 Posts]

Activity Count in Stored Procedures? [May 2005 - 4 Posts]

Add vprocs and PE's [Nov 2006 - 3 Posts]

ADD_DAY in Teradata? [Oct 2003 - 7 Posts]

ADD_MONTHS [Dec 2003 - 13 Posts]

Adding a Column with a default value [Nov 2002 - 5 Posts]

Adding empty table partitions [Feb 2008 - 4 Posts]

Adding leading zeros in SQL output [Nov 2000 - 4 Posts]

Adding new columns to an 11 billion row table [Aug 2007 - 4 Posts]

Adding New Compression Values to Compressed Field [Aug 2006 - 4 Posts]

Adding Nodes and Performance [May 2005 - 3 Posts]

Adding Nodes to a System: Re-Collection of Stats necessary? [Feb 2006 - 12 Posts]

Adding Profiles to Teradata Manager [Jun 2009 - 3 Posts]

Adding the value of a table column(integer) to current_timestamp [Aug 2007 - 5 Posts]

Adding timestamp column via Alter statement with SQL Assistant [Nov 2008 - 3 Posts]

Adding two time columns [Oct 2004 - 4 Posts]

Additional zeroes in teradata [Dec 2006 - 3 Posts]

Address Parsing [Jun 2009 - 4 Posts]

Admin Comment: Backlog of notes [Apr 2006 - One Post]

Admin Comment: Moving TeradataForum website to new hosting service [Nov 2004 - 3 Posts]

Admin Comment: NCR Members who signed-up with @TERADATA-NCR.COM addresses [Feb 2004 - 2 Posts]

Admin Comment: Power Outage [Jun 2008 - One Post]

Admin Comment: Problems with the TeradataForum [Sep 2006 - One Post]

Admin Comment: Relocation of server [Mar 2009 - 2 Posts]

Advantage to adding new COP entries? [Jun 2005 - 5 Posts]

Advise on creating views [Sep 2006 - 7 Posts]

Aggregate functions in SQL [Jul 2002 - 10 Posts]

Aggregate Intermediate Results computed locally/globally [May 2004 - 5 Posts]

Aggregate Join Index & Fallback [Mar 2004 - 8 Posts]

Aggregate-Aware Features in Teradata RDBMS [Oct 2002 - 3 Posts]

Aiii, INTERVALs! [Jun 2004 - 9 Posts]

AIX 5.3 and TTU ? [May 2005 - 3 Posts]

AIX Teradata Connectivity [May 2004 - 5 Posts]

Alert Policies not working after TD12 Conversion [Jan 2009 - 3 Posts]

Alert Policy [Oct 2004 - 5 Posts]

Alert SNMP [Sep 2008 - 3 Posts]

ALERT VIEWER error [Jun 2008 - 14 Posts]

Alerts in Teradata Manger [Aug 2008 - 6 Posts]

Alerts on Teradata manager [Jan 2004 - 3 Posts]

Algorithm to separate string text using spaces [Feb 2004 - 3 Posts]

Alias field into table [Mar 2008 - 7 Posts]

Aliases for column names [Jul 2008 - 3 Posts]

Aliasses [Jun 2002 - 3 Posts]

All select-lists do not contain the same number of expressions [May 2009 - 2 Posts]

Alter Table add partition's [May 2004 - 3 Posts]

Alter table and RI [Apr 2002 - 6 Posts]

Alter table compression [Dec 2003 - 8 Posts]

Alter Table Error 2559: Column COLUMN1 is not NULL [Aug 2008 - 5 Posts]

Alter Table from Datype date to timestamp [Feb 2007 - 7 Posts]

Alter table modify question [Jul 2003 - 5 Posts]

ALTER TABLE Question [Mar 2002 - 10 Posts]

ALTER table to add compression [Jan 2006 - 3 Posts]

ALTER table to change column width [Dec 2005 - 8 Posts]

Alter table vs. create copy for add column [May 2003 - 4 Posts]

Alternate to ISDATE() [Sep 2004 - 3 Posts]

Alternate way to Cursor [Mar 2003 - 8 Posts]

Alternating Account Strings via Microstrategy Logon [Jul 2003 - 6 Posts]

Alternative for Rank function [Aug 2004 - 7 Posts]

Alternative to Insert/Select [Aug 2006 - 6 Posts]

Alternatives to Teradata load utils [Jul 2003 - 34 Posts]

AMP worker tasks [Jun 2004 - 10 Posts]

AMP - Down Unable to Fetch the Rows [Feb 2004 - 8 Posts]

AMP Cpu Skew [Feb 2004 - 4 Posts]

AMP Disk Usage Level [Sep 2001 - 7 Posts]

AMP down and Multiload [Jun 2005 - 3 Posts]

AMP Error: 7487 AMP step failure [Nov 2006 - 5 Posts]

AMP IS DOWN [Nov 2007 - 5 Posts]

AMP Scan? [Jun 2003 - 7 Posts]

AMP Worker Task Count - Utility/Macro etc? [Jul 2004 - 6 Posts]

AMP Worker Tasks and Skewed Queries [Jun 2004 - 8 Posts]

AMP Worker Tasks [Sep 2002 - 6 Posts]

AMP/Disk Configuration [May 2001 - 6 Posts]

AMPCHECK in MultiLoad Script [Nov 2002 - 3 Posts]

Ampusage and node model [Mar 2007 - 6 Posts]

Ampusage [Apr 2003 - 4 Posts]

An owner referenced by user does not have index with grant option [Apr 2009 - 5 Posts]

Analytical function and datatype 'date' [Aug 2005 - 6 Posts]

Another ALTER TABLE question [Mar 2002 - 8 Posts]

Another comment/question on SQL Assistant [Feb 2005 - 4 Posts]

Ansi Compliance in Teradata [Apr 1999 - 8 Posts]

ANSI Mode [Jul 1999 - 4 Posts]

Any doc on NPARC [Dec 2004 - 3 Posts]

Any function to check whether the object is present or not [Mar 2008 - 2 Posts]

Any idea how to backup the accesslog table [Jan 2008 - 4 Posts]

Any info on Insufficient Memory for Plastic Steps? [Mar 2002 - 4 Posts]

Any limits on IN LIST ? [Feb 2005 - 3 Posts]

Any V2R6 Success or Horror Stories [Mar 2005 - 4 Posts]

Any way to How many Number of Node available in Database server [Jul 2006 - 3 Posts]

Any way to speed up collect statistics [Jul 2001 - 5 Posts]

Anybody seen this one before? [Jun 2008 - 4 Posts]

Anybody using Teradata Warehouse Builder? [Mar 2004 - 5 Posts]

Anyone heard of Teradata Distribution Engine [Mar 2008 - One Post]

Anyone noticing increased spool usage under V2R412? [Jun 2002 - 4 Posts]

Anyone used Multi-Value Compression? Experiences? [Aug 2003 - 6 Posts]

Anyone using BIG IP with Teradata [Sep 2002 - 3 Posts]

Anyone using Raid 5 [Oct 2005 - 3 Posts]

Appended Mystery Garbage Code [Mar 2006 - 6 Posts]

Applying LEFT OUTER JOIN in the WHERE condition [Jan 2005 - 4 Posts]

ARC on Network System [Dec 2005 - 6 Posts]

ARC1244: NO BUILD [Mar 2004 - 3 Posts]

Architechtural question--How to account for application usage? [Jan 2003 - 4 Posts]

Archival of fallback tables and USI when an AMP is down [Jun 2006 - 6 Posts]

Archive & Restore from one Teradata environment 2other. [Oct 2002 - 6 Posts]

Archive / Restore: copying a user and all its children [Feb 2004 - 7 Posts]

Archive accessrights [Jun 2002 - 7 Posts]

Archive and Restore to a Different Database [Jun 2009 - 3 Posts]

Archive dictionary table [Jul 2001 - 6 Posts]

Archive Permissions [Nov 2003 - 3 Posts]

Archive Strategy questions [Feb 2002 - 4 Posts]

Archive/restore question [Dec 2002 - 4 Posts]

Archiving experiences [Sep 1999 - 6 Posts]

Archiving Resusage Tables [Jul 2002 - 10 Posts]

Archiving via Partition [Apr 2008 - 3 Posts]

Archmain lose reference integrity [Feb 2009 - One Post]

Arciving a system [Dec 2002 - 3 Posts]

ARCMAIN - In the Process of getting Fast/Multi loaded [Apr 2009 - One Post]

Arcmain Failing with 'bad parcel received' error [Mar 2003 - 3 Posts]

Arcmain heredoc [Feb 2007 - 3 Posts]

ARCMAIN problem [Dec 2000 - 4 Posts]

Arcmain restart option [Apr 2005 - 3 Posts]

ARCMAIN Scripting - Can table be predicated [Apr 2008 - 2 Posts]

ARCMAIN throughput - limiting factors [Nov 2005 - 14 Posts]

arcmain throughput [Jan 2004 - 4 Posts]

Are my Primary Indexes being used? [Jan 2005 - 7 Posts]

Are Numeric Keys and Indices more efficient? [May 2004 - 3 Posts]

Are Statistics Important? [Jun 2002 - 3 Posts]

Are updates generally slow in Teradata [Apr 2002 - 5 Posts]

Arrays in macros [Aug 2004 - 7 Posts]

Arrays in Stored Procedures [Jan 2002 - 4 Posts]

AS/400 [Jul 2004 - 4 Posts]

Ascential Datastage and dbc.userrights [Jan 2006 - 10 Posts]

ASCII function: Return ASCII value of the number [Oct 2004 - 4 Posts]

ASF2 CheckSum Survey [Feb 2002 - 3 Posts]

ASF2 through-put and system slowdowns [Nov 2004 - 4 Posts]

ASP & Teradata Macros [May 2003 - 6 Posts]

ASP to Teradata [Nov 2002 - 4 Posts]

ASP.NET, Teradata, web development, NET Data [Sep 2006 - 3 Posts]

Assigning a default value to derived values in [Dec 2006 - 6 Posts]

Assigning destination tags to CDRs [Aug 2003 - 6 Posts]

Audit Mechanism in Active Data Warehouse [Sep 2002 - 6 Posts]

Auto DB space add [Dec 2007 - 5 Posts]

Auto increment in Teradata [Oct 2002 - 12 Posts]

Auto Setting the Current Date [Feb 2002 - 6 Posts]

AUTO_NUMBER in Teradata [Mar 2006 - 10 Posts]

Automate Cancelling Sessions [Oct 2008 - 3 Posts]

Automated PPI Maintenance [Sep 2005 - 7 Posts]

Automatic generation of showfsp reports [Aug 2008 - 2 Posts]

Automatic statistics management [Mar 2006 - 7 Posts]

Automatic Teradata killing sessions [Jun 2007 - 7 Posts]

Automating priority for bad queries [Feb 2009 - 4 Posts]

Automating Space and Statistics management [Mar 2006 - 5 Posts]

Automating Space management [Mar 2006 - 7 Posts]

AVERAGE Results? [Oct 2003 - 5 Posts]

Avoid the Product Join [Feb 2007 - 9 Posts]

Avoiding distinct in grouping [Dec 2006 - 6 Posts]

AWS to node communication [Jul 2003 - 4 Posts]

AWT & Flow control [Aug 2004 - 3 Posts]



Backing up Structures (DDL) [Feb 2005 - 8 Posts]

Backup and Recovery of Large Multi-Terabyte tables? [Jul 2005 - 5 Posts]

Backup in UNIX [Dec 2000 - 5 Posts]

Backup structures only [Oct 2006 - 9 Posts]

Backups & Recoveries [Aug 2001 - 5 Posts]

Bad Characters [Dec 2004 - 4 Posts]

Bankers rounding [Nov 2002 - 4 Posts]

BAR Cabinets [Jun 2009 - One Post]

Base Tables in the View [Dec 2003 - 6 Posts]

Basic Locking table question : It's getting fast when access table with locking table command? [Nov 2003 - One Post]

Batch driven use of Queryman [Feb 2003 - 7 Posts]

Batch userid to connect from unix only [Jun 2005 - 5 Posts]

Best Approach to Recursive Queries without CONNECT BY [Dec 2004 - 5 Posts]

Best Practice for PPI with single value for month [Jan 2008 - 2 Posts]

Between Statement [Aug 2007 - 9 Posts]

Between: not working as expected [Nov 2007 - 18 Posts]

Bigint truncation in SQL Assistant v12 [Jun 2009 - 4 Posts]

Binary Representation of an Integer [Sep 2003 - 4 Posts]

Binding variable in sqltext [May 2006 - 6 Posts]

Blanks and Coalesce behavior [Jun 2007 - 4 Posts]

Block everybody with ALTER TABLE [Jan 2002 - 5 Posts]

Block size for Tactical Queries [Aug 2006 - 4 Posts]

Blocking problem [Nov 2003 - 4 Posts]

Blocking processes in Teradata [Jun 2009 - 3 Posts]

Blocking Tool [May 2008 - 4 Posts]

BMSMS [Jun 2003 - 4 Posts]

BO on Teradata and connect time [Oct 1999 - 5 Posts]

Bogus error message: 3623 [Mar 2004 - 6 Posts]

Break Point for using a Sparse Join Index [Jul 2007 - 5 Posts]

Broken Pipe Error in Mload [Apr 2007 - 7 Posts]

BTEQ - export string with CRLF [Feb 2007 - 4 Posts]

BTEQ - Macros inside transactions [Oct 2005 - 6 Posts]

BTEQ - suppressing column headers [Feb 2005 - 4 Posts]

Bteq .logon problems [Sep 2002 - 10 Posts]

BTEQ and RTRIM [May 2003 - 6 Posts]

Bteq cannot connect. System still online [Apr 2001 - 5 Posts]

BTEQ cast a POSITION [Mar 2005 - 6 Posts]

Bteq connect to remote machine [Apr 1999 - 17 Posts]

BTEQ connection error [Mar 2007 - 4 Posts]

Bteq connectivity problem in TD 12 [May 2008 - 4 Posts]

BTEQ Export - concatenating null values [Oct 2008 - 8 Posts]

Bteq export command [Sep 1999 - 5 Posts]

BTEQ Export Limit [Dec 2007 - 11 Posts]

BTEQ Export Syntax [Oct 2003 - 4 Posts]

BTEQ export to CSV file and large numbers [Aug 2005 - 9 Posts]

BTEQ Export to Fastload in record mode is failing [May 2005 - 4 Posts]

Bteq Export to Windows Named Pipe [May 2009 - 3 Posts]

BTEQ Export with newline function? [Dec 2004 - 6 Posts]

BTEQ Format for Column Heading [Sep 2004 - 4 Posts]

BTEQ from Sun Server [Jan 2004 - 11 Posts]

Bteq Import of comma separated data [Aug 2008 - 4 Posts]

BTEQ Import, Variable Substitution Error [Feb 2004 - 10 Posts]

BTEQ Infile parm question [Jan 2005 - 4 Posts]

Bteq interaction with MS Domains causing .logon to hang [Jul 2005 - 4 Posts]

BTEQ Log on Error [Oct 2005 - 4 Posts]

BTEQ logon [Jan 2003 - 6 Posts]

BTEQ not called by crontab in unix [Jan 2007 - 9 Posts]

BTEQ output and delimited text file [Dec 2005 - 9 Posts]

BTEQ output limitation [Nov 2002 - 4 Posts]

BTEQ question: How to handle login/password [Mar 2009 - 7 Posts]

BTEQ Sentences [Feb 2000 - 5 Posts]

Bteq SHOW TABLE export [Aug 2007 - 8 Posts]

BTEQ SQL error: Failure 3706 Syntax error [Jun 2006 - 4 Posts]

BTEQ via Web-Interface Hanging [Jun 2007 - 4 Posts]

Bteq with .Repeat * Using [May 2006 - 8 Posts]

BTEQ without any space between columns [Feb 2004 - 10 Posts]

BTEQ: Saving the ActivityCount [Aug 1999 - 5 Posts]

BTEQWin - Default path [Oct 2004 - 6 Posts]

Buddy AMP/Buddy Node [May 2003 - 5 Posts]

Building row numbers [Apr 2006 - 11 Posts]

Business Objects and JDBC [Jan 2005 - 7 Posts]

Business Objects Designer and TDATA.DLL [Mar 2005 - 5 Posts]

Business Objects SQL Parsing [Jan 2003 - 6 Posts]

Bytes data is not displaying [Aug 2003 - 9 Posts]



C Preprocessor2 Alternatives [Jun 2000 - 13 Posts]

Cache in teradata? [Nov 2007 - 8 Posts]

Calculate Percentages for a column [Nov 2007 - 7 Posts]

Calculate TIMESTAMP difference [May 2005 - 4 Posts]

Calculating average age per transaction [Oct 2004 - 5 Posts]

Calculating Months between two dates [Oct 2006 - 10 Posts]

Calculating total space for indexes [Sep 2008 - 7 Posts]

Calling a procedure in a select statement [Jan 2007 - 5 Posts]

Calling a Stored procedure from a Query [Jul 2003 - 6 Posts]

Calling a stored procedure from TPUMP [May 2005 - 4 Posts]

Calling a stored Procedure from within an SP [Sep 2005 - 4 Posts]

Re: Can anyone throw some light on the difference [Nov 2004 - 3 Posts]

Can DBQL be used with Access Logging? [Apr 2005 - 4 Posts]

Can fastload data between different version database [Jul 2003 - 10 Posts]

Can fields be passed as param for ORDER BY? [Mar 2007 - 5 Posts]

Can I add composite primary key on table? [Mar 2008 - 5 Posts]

Can I avoid a product join? [Mar 2008 - 8 Posts]

Can i call macro in procedure? [Feb 2008 - 3 Posts]

Can I give Input values to BTEQ file? [Feb 2008 - 6 Posts]

Can TDWM limit grant/revoke access rights [Apr 2008 - 5 Posts]

Can UDF's be used against PI fields (on V2R5.1)? [Oct 2004 - 4 Posts]

Can View refer a recursive view? [Mar 2009 - One Post]

Can we check stats automatically [Jun 2004 - 7 Posts]

Can we use '%' with in the procedure for searching string [Apr 2008 - 6 Posts]

Can we use a wild card in arcmain [Jun 2004 - 4 Posts]

Can't extract data (FASTEXPORT) from a remote teradataserver [Apr 2006 - 8 Posts]

Can't get ROW_NUMBER to Work [Jun 2006 - 4 Posts]

Can't save TDWM rule-sets [Jul 2008 - 4 Posts]

Canary queries and SQL for performance monitoring [Mar 2003 - 5 Posts]

Canary Queries and TDWM [Aug 2008 - 3 Posts]

Canary query is stopping automatically [Aug 2008 - One Post]

Canary Sql [Aug 2002 - 5 Posts]

Cancel Rollback [Jul 2003 - 8 Posts]

Cannot find Inmod entry point in dll [Feb 2008 - One Post]

Cannot install Shared ICU from TW 8.1 (V2R6.1) Demo [Aug 2008 - 5 Posts]

Cannot Load Profile: Error 3003 (invalid password) [Apr 2006 - 4 Posts]

Cannot Start TD12.0 Express Databsae (Windows XP) [Jun 2009 - 5 Posts]

Cannot Uninstall TD 6.1 [Apr 2009 - 11 Posts]

Capacity Planning for Ordinairy People! [Jun 2003 - 12 Posts]

Capture commands run in exec macro [Feb 2009 - 2 Posts]

Capture of BTEQ return code [Jul 2006 - 4 Posts]

Capturing Activity Count insite bteqs [Mar 2006 - 9 Posts]

Capturing Data Leaving Teradata Machine [Apr 2003 - 13 Posts]

Capturing Updates in a Readable File [Mar 2004 - 15 Posts]

CASE Expression Problem [Feb 2004 - 6 Posts]

CASE in Ins/Sel [Aug 2002 - 6 Posts]

Case sensitivity in duplicate value checking against character datatypes question [Mar 2003 - 3 Posts]

Case sensitivity modifier in IN clause [May 2004 - 4 Posts]

Case Statement and Crystal Reports [Apr 2008 - 7 Posts]

Case Statement in Macro [Sep 2002 - 7 Posts]

Case statements [Oct 2001 - 4 Posts]

Case syntax problem [Nov 2002 - 5 Posts]

Cast Behavior Between 6.1 and 6.2 [Jan 2008 - 5 Posts]

CAST error: 5355 [Feb 2008 - 2 Posts]

CAST instead of CASE [Nov 2004 - 7 Posts]

CAST into varchar 2 versions [Jun 2006 - 8 Posts]

Cast Operator [Mar 2006 - 6 Posts]

Cast problem : invalid date format [Dec 2005 - 4 Posts]

Cast to Decimal - Error 2679 [Aug 2005 - 4 Posts]

Casting Character To Timestamp [Aug 2006 - 4 Posts]

Casting integer as Time [Jan 2007 - 20 Posts]

Casting Time stamp in Mload [Mar 2006 - 7 Posts]

Casting to char [Jun 2002 - 5 Posts]

Casting to Integer Question [Mar 2009 - 2 Posts]

CCL and security [Apr 2001 - 6 Posts]

CEIL & Least function in TD [Dec 2005 - 3 Posts]

Change another database in FASTLOAD? [Aug 2008 - 3 Posts]

Change in casting to Interval [May 2008 - 6 Posts]

Change Index Name [Dec 2006 - 6 Posts]

Change Password menu options in the SQL Assistant does not work [Oct 2004 - 6 Posts]

Change Request Processing Option [Nov 2008 - 6 Posts]

Change the date format on the Teradata server [Nov 2005 - 5 Posts]

Change the OWNER of a database [Mar 2005 - 4 Posts]

Re: Changing a column name while concatenating [Jul 2004 - One Post]

Changing a column name while concatinating [Jul 2004 - 8 Posts]

Changing a default database within a macro [Mar 2005 - 5 Posts]

Changing oracle code to teradata [Feb 2005 - 4 Posts]

Changing Partition definition [Jan 2009 - 8 Posts]

Changing PK values [Sep 2003 - 16 Posts]

Changing Priority on Sessions via PMON [Nov 2001 - 7 Posts]

Changing the default client character set [Oct 2004 - 4 Posts]

Char to date in teradata [Feb 2008 - 8 Posts]

CHAR vs VARCHAR [Feb 2003 - 5 Posts]

CHAR(1) Vs BYTEINT [Aug 2007 - 5 Posts]

Character set information [Aug 2004 - 4 Posts]

Character SET Latin vs. Unicode [May 2004 - 5 Posts]

Character Set Problem Help .... [May 2005 - 5 Posts]

Chart CPU Utilization [Nov 2007 - 6 Posts]

Check constraint. [Aug 2007 - 13 Posts]

Check for Active LOCKS [Mar 2009 - 21 Posts]

Check for Broken Views [May 2006 - 4 Posts]

Check Lock/Unlock User id [Jul 2006 - 8 Posts]

Check rowcount in bteq utility [Jul 2003 - 8 Posts]

Check Values is Numeric? [Dec 2005 - 7 Posts]

Checking column statistics [May 2003 - 5 Posts]

Checking Fast Load job status [Sep 2008 - 4 Posts]

Checking the last update made !! [Apr 2005 - 4 Posts]

CHECKTABLE and error 2772 [Mar 2002 - 4 Posts]

Chopping character strings into component parts [Mar 2006 - 4 Posts]

Cleaning Database Columns [Jul 2004 - 4 Posts]

Cleaning up DBC tables [May 2003 - 8 Posts]

ClearPeakDisk and PeakSpoolSpace [Mar 2001 - 6 Posts]

CLI - Fetch Parcel [Nov 2003 - 4 Posts]

CLI 0360 Invalid Caller for Function [Dec 2003 - 7 Posts]

CLI and perl on MP-RAS [Dec 2001 - 6 Posts]

CLI charset problem.. [Nov 2003 - 5 Posts]

CLI error 126: Specified driver could not be loaded due to system error [May 2005 - 7 Posts]

CLI Error 215: Error found in local machine during connect [May 2004 - 4 Posts]

CLI error 220 [Apr 2005 - 5 Posts]

CLI with Microsoft .NET [Mar 2005 - 5 Posts]

Client Request Load Balancing [Sep 2005 - 6 Posts]

Closing ghost session [Jul 2004 - 4 Posts]

Cluster archives vs. database level archives [Jul 2002 - 4 Posts]

Coalesce in FASTLOAD [Oct 2004 - 5 Posts]

Coalesce on date fields [Mar 2003 - 4 Posts]

Coalesce on timestamps [Nov 2007 - 7 Posts]

COALESCE or CASE ? [Jul 2005 - 9 Posts]

COBOL Embedded SQL and TTU 7.0 [Apr 2003 - 4 Posts]

Coexistence and disk families [Dec 2005 - 4 Posts]

Cognos Error UDA-EE-0007: "integer" to "textblob" [Sep 2008 - 4 Posts]

Col names in queryman [Mar 2002 - 5 Posts]

Cold Fusion and Teradata [Nov 2005 - 4 Posts]

Collect Stat [Feb 2001 - 13 Posts]

COLLECT STATISTICS from macro [Nov 2004 - 4 Posts]

Collect statistics necessary on tables with a unique primary index [Mar 2003 - 4 Posts]

COLLECT STATISTICS on DBC [Mar 2002 - 8 Posts]

COLLECT STATISTICS on Indexed Columns & [Mar 2008 - 5 Posts]

Collect Statistics Takes 11 Hours [Sep 2006 - 7 Posts]

Collect statistics.. [Apr 2003 - 11 Posts]

Collect statistics [Aug 2002 - 11 Posts]

Collect stats and Group by difference [Jun 2004 - 8 Posts]

Collect Stats in a Procedure [Aug 2005 - 11 Posts]

Collect stats on DBC. [Jul 2003 - 9 Posts]

Collect Stats on large table [Mar 2002 - 6 Posts]

Collect Stats on multiple columns in a table [Mar 2007 - 4 Posts]

Collect Stats on PI: Index vs Column [Dec 2007 - 8 Posts]

Collect stats on PI [Mar 2003 - 4 Posts]

Collect Stats on Single Column SI [Dec 2003 - 19 Posts]

Collecting statistics and 'no confidence' [Jul 2007 - 8 Posts]

Collecting statistics on Join Indexes [Oct 2006 - 8 Posts]

Collecting Stats - Column or Index [Apr 2009 - 6 Posts]

Column Compress Question [Apr 2004 - 10 Posts]

Column Compression [Sep 2002 - 4 Posts]

Column Data Encryption? [Feb 2005 - 6 Posts]

Column domains in DBC... [May 2004 - 6 Posts]

Column Explanations [May 2003 - 4 Posts]

Column Headers with Fast Export [Apr 2001 - 12 Posts]

Column level security [Mar 2007 - 4 Posts]

Column Order in Derived Table [May 2009 - 2 Posts]

Column Order in Primary Index [Aug 2008 - 2 Posts]

Column restrictions in tables [May 2006 - 4 Posts]

Column titles and titledashes should not appear in the export file. [Jan 2003 - 12 Posts]

Columns Part of Partitioning Expression [May 2009 - 7 Posts]

COLUMNTYPE LOOKUP [Jan 2007 - 5 Posts]

Comma in string [Jun 2005 - 10 Posts]

Comments in ARC Utility [Jan 2005 - 6 Posts]

Comments inside a view not showing... [Jan 2006 - 6 Posts]

Communication between Unix NCR and server SUN [Mar 2004 - 5 Posts]

COMP-3 [Apr 2006 - 6 Posts]

Compare null with integer [Oct 2002 - 4 Posts]

Compare rows of tableA to rows of tableB - HOW? [Sep 2005 - 10 Posts]

Compare teradata with other databases [Sep 2005 - 5 Posts]

Comparing blanks and Nulls [Mar 2008 - 9 Posts]

Comparing output from two SQLs [Jul 2004 - 5 Posts]

Comparing tables structure [Oct 2006 - 5 Posts]

Comparing two tables in teradata present on different servers [Oct 2008 - 2 Posts]

Comparing varchar and date columns [Sep 2004 - 4 Posts]

Comparison of data in two servers [May 2009 - 5 Posts]

Comparison of UNICODE and LATIN column in SELECT [Apr 2009 - 3 Posts]

Compilation problems when try to compile the proceudre [Feb 2006 - 8 Posts]

Compiling stored procedures [Jul 2003 - 4 Posts]

Complete Refresh of data : Mload or Fastload [Dec 2007 - 4 Posts]

Composition of SIs & Stats on PIs [Oct 2004 - 2 Posts]

Compress [May 2001 - 13 Posts]

Compressing a date column [May 2004 - 4 Posts]

Compressing Byte Columns [May 2001 - 4 Posts]

COMPRESSing spaces [May 2005 - 4 Posts]

Compression Algorithm [Oct 2007 - 7 Posts]

Compression and join indexes [Jun 2005 - 10 Posts]

Compression and timestamps [Jul 2003 - 6 Posts]

Compression of Date Field [May 2003 - 4 Posts]

Compression [Dec 2002 - 4 Posts]

Concatenating Dates with Times [Dec 2003 - 4 Posts]

Concatenation single-quotes around an attribute [Apr 2009 - 7 Posts]

Concurrency of TDWM Query [Mar 2008 - One Post]

Concurrent change conflict on database -- try [Jan 2009 - 4 Posts]

Concurrent Loads/Deletes for Staging Table [Dec 2003 - 10 Posts]

Concurrent Users [Oct 2003 - 4 Posts]

Conditional macro execution [Jan 2005 - 5 Posts]

Conditional max [Apr 2004 - 7 Posts]

Conditional Table Drop [Feb 2008 - 8 Posts]

Conditionally Aborting a job [Sep 2004 - 6 Posts]

Conditionally Converting a Many to One relationship [Oct 2007 - 5 Posts]

Confidence Levels in TDQM [Jul 2004 - 4 Posts]

Configuration Question about non-TPA nodes/servers [Apr 2003 - 4 Posts]

Configuring alert policies using Teradata manager 7.1 [Mar 2006 - 4 Posts]

Configuring the Performance Periods of Priority scheduler [Dec 2003 - 4 Posts]

Conflicts with Teradata Backups [Mar 2008 - 9 Posts]

Confused By Block [Aug 2004 - 4 Posts]

Confusing freespace percent (FSP) results [Jul 2008 - One Post]

Confusing of the 'NOT LIKE' logic [Jan 2008 - 6 Posts]

CONNECT BY ..START WITH ( Equivalent in Teradata ) [Sep 2004 - 5 Posts]

Connecting in ANSI mode using CLI [Dec 2003 - 4 Posts]

Connecting Oracle to Teradata real-time [Aug 2004 - 11 Posts]

Connecting teradata in java [Sep 2008 - 2 Posts]

Connecting Teradata with Accessdatabase [Jun 2006 - 4 Posts]

Connecting to a Fastload Named Pipe from non-TD program [Apr 2005 - 6 Posts]

Connecting to the Teradata and Port 1025 [Jun 2004 - 5 Posts]

Connection Error: 10065 WSA E HostUnreach [Dec 2004 - 4 Posts]

Connection Error: 11004 WSA E No_Data [Feb 2005 - 4 Posts]

Connection reset by peer [Jan 2008 - 12 Posts]

Connectivity problems in Teradata - N/W connection failed [Jun 2003 - 5 Posts]

Connectivity Tests [Jan 2003 - 13 Posts]

Consecutive sequence sql logic [Jun 2003 - 28 Posts]

Considering Join Indexes - any success stories? [Jul 2006 - 6 Posts]

Constraint Question [Jan 2004 - 5 Posts]

Constraints and indexes [Mar 2005 - 4 Posts]

Continuations in FastLoad [Nov 2002 - 10 Posts]

Control access to view [May 2008 - 11 Posts]

Control Char Issue [Oct 2008 - 3 Posts]

Control characters in fastexport output file [Feb 2004 - 13 Posts]

Control line feeds [Sep 2007 - 5 Posts]

Controller for DBC [Apr 2008 - 6 Posts]

Controlling abort session for PMON [Jun 2007 - 5 Posts]

Convert Decimal into Varchar without a trailing dot [Nov 2005 - 5 Posts]

Convert hex number to int? [Mar 2005 - 9 Posts]

Convert HostData to Readable format [Mar 2007 - 4 Posts]

Convert Oracle Stored Procedure to Teradata Stored Procedure [Sep 2007 - 4 Posts]

Convert time from twenty four hour to twelve hour format [Jan 2008 - 12 Posts]

CONVERT_TABLE_HEADER [Mar 2009 - 2 Posts]

Converting 4-digit dates to standard date [Apr 2002 - 5 Posts]

Converting bteq query to Sql server integration [Nov 2008 - One Post]

Converting Float In Cobol [Aug 2004 - 5 Posts]

Converting HEX to ASCII [Sep 2004 - 8 Posts]

Converting MULTISET Table to Set Table [Apr 2007 - 9 Posts]

CONVERTING NULLS [Jul 2003 - 6 Posts]

Converting Rows to coulmns by some Fucnction of teradata [Jul 2006 - 7 Posts]

Converting time in miliseconds to TIEMSTAMP in teradata [Apr 2004 - 13 Posts]

Converting Time to seconds [Dec 2006 - 5 Posts]

Converting TIMESTAMP From GMT to EST [Dec 2006 - 6 Posts]

Copy data table statement V2R6.1 to 12 [May 2008 - 3 Posts]

Copy dictionary operation [May 2001 - 4 Posts]

Copy workaround [Jan 2003 - 4 Posts]

Copying and Pasting between MS Outlook and Queryman 6.0 [Dec 2002 - 8 Posts]

Correlating Multiple Views and Join Views to Base Tables [Aug 2005 - 4 Posts]

Could not open log file [Sep 2003 - 6 Posts]

Count distinct set of rows [Jun 2005 - 4 Posts]

Count Function [Oct 2001 - 8 Posts]

Count of all rows, all tables [Apr 2005 - 4 Posts]

Count of Distinct Rows [Nov 2003 - 18 Posts]

Count(case... to get a count(distinct acct_id) Is this possible? [Sep 2002 - 8 Posts]

Counting a column multiple times based on CASE [Jan 2007 - 6 Posts]

Couting duplicate rows thru multi load [Feb 2003 - 7 Posts]

CPU 100% performance [Jul 2003 - 8 Posts]

CPU in Real-Time [May 2003 - 7 Posts]

CPU sec variations [Mar 2007 - 8 Posts]

CPU vs Disk IO [Sep 2003 - 9 Posts]

CPU vs IO [Nov 2003 - 6 Posts]

CPUTime in AmpUsage [Jan 2003 - 6 Posts]

Create a Table sourced from a complex view [Jan 2008 - 4 Posts]

Create Database Rights [Aug 2006 - 4 Posts]

Create index and LastAlterTimestamp [Sep 2004 - 4 Posts]

Create multiset with UPI and SET with NUPI have different results [Apr 2006 - 7 Posts]

Create Set Table ... As [Jan 2002 - 5 Posts]

Create statement for each table [Jun 2009 - 2 Posts]

Create Statement in Macro [May 2009 - 13 Posts]

Create Table -> date default [Jul 2003 - 6 Posts]

Create table as "select statement" [Oct 2008 - 3 Posts]

CREATE TABLE AS : Primary Index and Compressed Columns [Sep 2003 - 9 Posts]

CREATE TABLE AS from views [Sep 2002 - 6 Posts]

CREATE TABLE AS??? [Aug 2001 - 9 Posts]

Create Table Efficiencies [Jun 2003 - 7 Posts]

Create table in a Macro [Aug 2007 - 4 Posts]

Create table with comments [Dec 2007 - 4 Posts]

CREATE TABLE...AS and when SIs are created. [Feb 2004 - 5 Posts]

Create testing plan for big tables join [Apr 2003 - 6 Posts]

Creating a table with a 0 skew factor [Mar 2008 - 7 Posts]

Creating a UNIX fastload [Mar 2002 - 5 Posts]

Creating alert for DB restart [Feb 2009 - 6 Posts]

Creating Index from BETQ [Mar 2003 - 7 Posts]

Creating months table [Jun 2002 - 5 Posts]

Creating Multiset tables using ERwin - Revisited [Nov 2005 - 6 Posts]

Creating one table from another [May 2009 - 7 Posts]

Creating Parameters in Crystal formula editor [Feb 2008 - 2 Posts]

Creating stored procedure.. [Sep 2003 - 8 Posts]

Creating stored procedure [Jul 2002 - 10 Posts]

Creating tables 50% to 90% of columns as unique primary index [Jan 2007 - 11 Posts]

Creation of worktables during multiload in Teradata [Jul 2004 - 4 Posts]

Creation table by end user-developer [Mar 2001 - 6 Posts]

CRLFs in DBC.TABLES.REQUESTTEXT [May 2005 - 4 Posts]

CRM Issues [Mar 2002 - 4 Posts]

Cron Job for Changing PSF [Nov 2003 - 5 Posts]

Cross join in update statement [Apr 2008 - 5 Posts]

Cross join [Jan 2003 - 4 Posts]

Crosstab SQL [Mar 2004 - 8 Posts]

Crystal Reports and ODBC [Jul 2005 - 4 Posts]

CSUM function [Oct 2003 - 4 Posts]

Current identity value of table [Feb 2008 - One Post]

Current Query that is being executed by any user. [Aug 2005 - 4 Posts]

CURRENT_TIMESTAMP not UTC [Apr 2009 - 4 Posts]

Current_timestamp Question [Jul 2001 - 4 Posts]

Cylinder Read vs MAXBLOCKSIZE [Aug 2004 - 4 Posts]

CylinderssavedforPerm [Jan 2003 - 9 Posts]



Daily updates to a history table [Jan 2003 - 6 Posts]

Dash character in user/database name? [Jun 2003 - 8 Posts]

Data acces from JDBC, ODBC and CLI [Feb 2009 - 4 Posts]

Data access using views [Mar 2009 - 7 Posts]

Data BlockSize [Dec 2007 - 5 Posts]

Data Collection tables not populating & Dashboard [Jul 2007 - One Post]

Data Encryption [May 2008 - One Post]

Data extract from Teradata [Nov 2006 - 8 Posts]

Data extract methods [Feb 2008 - 3 Posts]

Data extraction question [Feb 2003 - 8 Posts]

Data in DWH --- Issues [Sep 2001 - 11 Posts]

Data Load Error WRT_8114 [Sep 2005 - 8 Posts]

Data Mig [Apr 2003 - 10 Posts]

Data migration from one TD machine to another [Feb 2008 - 7 Posts]

Data Model with Microstrategy as frontend tool [Nov 2001 - 16 Posts]

Data Refresh in Teradata [Jul 2001 - 4 Posts]

Data Retention of System Log Tables [Jan 2003 - 4 Posts]

Data Row Format [Mar 2002 - 4 Posts]

Data row too long!!! [Feb 2007 - 7 Posts]

Data selection [Jan 2003 - 6 Posts]

Data transfer from one server to other [Dec 2007 - 4 Posts]

Data Transmission [Jul 2004 - 4 Posts]

Data transposition [Sep 2002 - 6 Posts]

Data Warehouse's Data [Feb 2001 - 6 Posts]

Database and tablename - BTEQ [Jun 2009 - 3 Posts]

Database Connect Time [Aug 2006 - 4 Posts]

Database connectivity, take 2 [Apr 1999 - 5 Posts]

Database full when deleting rows [Jun 2007 - 11 Posts]

Database Name in Teradata [Mar 2005 - 7 Posts]

Database obfuscation [Mar 2008 - One Post]

Database Query Log (DBQL) [Oct 2003 - 5 Posts]

Database re-sizing ... need help/advice with main focus on system performance [Dec 2004 - One Post]

Database running slow [Oct 2006 - 3 Posts]

Databases - 1 large or 4 small? [Aug 2001 - 7 Posts]

Datablocksize and Freepercent [Feb 2002 - 4 Posts]

Datablocksize and Freespace [Sep 2005 - 4 Posts]

DataStage Enterprise Edition [Jan 2007 - 4 Posts]

Datastage: Sequential or Parallel [Sep 2007 - One Post]

DataType from Dictionary Tables [May 2003 - 5 Posts]

Date Fomat Problem in Macro between V2R5 and [Oct 2005 - 10 Posts]

Date & time of statistics [Dec 2001 - One Post]

Date Arithmetic [May 2003 - 9 Posts]

Date as IN parameter [Sep 2008 - 2 Posts]

Date Comparisons [Mar 2009 - 8 Posts]

Date Diff and Error 7453 - Overflow [Mar 2006 - 5 Posts]

DATE Format of INPUT Parameter for STORED PROCEDURE [Jan 2005 - 6 Posts]

Date manipulation - Timestamp in WHERE clause [Jan 2006 - 4 Posts]

Date of Statistics [Apr 2003 - 4 Posts]

Date out of date time fields [Mar 2004 - 12 Posts]

Date sequence with RANK() OVER [May 2008 - 4 Posts]

Datediff function [Feb 2001 - 8 Posts]

DATEFORM Command [Mar 2003 - 4 Posts]

Dates & times [Jan 2002 - One Post]

Dates not hashing evenly [Nov 2004 - 7 Posts]

DAYOFWEEK Function and BTEQ [Aug 2005 - 6 Posts]

Days between [Mar 2002 - 6 Posts]

DB2 to teradata Data migration considerations [Jun 2006 - 7 Posts]

DBA Guru! [Jan 2005 - 4 Posts]

DBC account locked [Jan 2003 - 4 Posts]

DBC Blocking query on a particular Database [Jun 2009 - 2 Posts]

DBC full [Mar 2009 - 10 Posts]

DBC gets full, ResUsage goes off... [Feb 2009 - One Post]

DBC login authorization [Mar 2004 - 9 Posts]

DBC Space Clean up [May 2009 - 4 Posts]

DBC Space Requirement [Oct 2004 - 5 Posts]

DBC view for Multi stats? [Jul 2003 - 5 Posts]

DBC.ACCESSLOG and STATEMENTTEXT [Feb 2002 - 6 Posts]

DBC.AccessLog [Feb 2004 - 19 Posts]

DBC.ACCESSRIGHTS error [Aug 2000 - 11 Posts]

DBC.ACCTG & Account Strings [Dec 2002 - 2 Posts]

DBC.INDEXES and Index Types [Mar 2005 - 5 Posts]

DBC.INDEXSTATS [Apr 2002 - 5 Posts]

DBC.SysExecSQL privileges and error SPL1078 [Aug 2004 - 5 Posts]

DBCMANAGER Logon/Logoff [Dec 2008 - 4 Posts]

Dblink in Teradata [Feb 2006 - 9 Posts]

DBQL - Query Id in Objects table but not in QueryLog [Mar 2008 - 6 Posts]

DBQL queries [Mar 2006 - 8 Posts]

DBQL Skips Logging SQL When Busy? [Nov 2005 - 5 Posts]

DBQM and Microstrategy [Feb 2002 - 4 Posts]

DBS Control fields [May 2003 - 7 Posts]

DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS -- Advice sought [Aug 2007 - 6 Posts]

Dbscontrol - Cylinder Saved for Perm [Jun 2005 - 3 Posts]

DBSControl is running in System FE mode [Apr 2006 - 4 Posts]

DDL ( Show Table ) from DBC tables [Jan 2008 - 11 Posts]

DDL for macro [Feb 2009 - 2 Posts]

DDL in stored procedures [Nov 2002 - 4 Posts]

Deadlock Question [Apr 2003 - 5 Posts]

Deadlock while loading table from two different sources [Jun 2009 - 3 Posts]

Deadlock [Mar 2003 - 4 Posts]

Deadlocking [Mar 2005 - 4 Posts]

Deadlocks on DBC tables [Jul 2003 - 5 Posts]

Dealing with concentrated values in the data [Feb 2008 - 5 Posts]

Debug a SQL and null [Oct 2004 - 4 Posts]

Debugging a Stored Procedure [Jan 2007 - 5 Posts]

Dec(18,0) [Jul 2002 - 11 Posts]

Deciles Query [Mar 2005 - 4 Posts]

Decimal (18,0) magic [Apr 2007 - 6 Posts]

Decimal column exported length [Mar 2008 - 3 Posts]

Decimal or time in PI [Sep 2002 - 7 Posts]

Decimal rounding [Jun 2006 - 4 Posts]

Decimal(18,0) [Nov 2001 - 6 Posts]

DECIMAL(19,2) to DECIMAL(18,2) type casting [Apr 2008 - 3 Posts]

Default character set of an user [Jul 2007 - 7 Posts]

Default charset in volatile tables [Feb 2005 - 5 Posts]

Default database name in bteq [Mar 2003 - 8 Posts]

Default database space [May 1999 - 10 Posts]

Default display of date [Feb 2009 - 6 Posts]

Default LOCK FOR ACCESS [Sep 2001 - 4 Posts]

Defaults for Date and Time columns [May 2001 - 6 Posts]

Define the more than one file in Multiload [Nov 2008 - 2 Posts]

Delete active subtable of the AfterJournal [Jun 2003 - 4 Posts]

Delete and update with join [Feb 2007 - 7 Posts]

Delete duplicate rows from a multi terabyte table [Oct 2008 - 3 Posts]

Delete Duplicate rows in Teradata [Aug 2004 - 4 Posts]

Delete in teradata [Nov 1999 - 5 Posts]

Delete Query on a huge table taking too much time [Feb 2004 - 10 Posts]

DELETE recommendations? [Aug 2004 - 8 Posts]

Delete Statement taking a long time to run. [Nov 2007 - 9 Posts]

Delete TRIGGER help [Feb 2002 - 4 Posts]

Delete vs delete all [Jun 2002 - 6 Posts]

Deleting duplicate rows in Table without INS/SEL [Sep 2004 - 7 Posts]

Deleting Duplicate rows [Aug 2005 - 15 Posts]

Deleting Duplicates with a single DELETE statement [May 2004 - 11 Posts]

Deleting from a huge table [Mar 2003 - 6 Posts]

Deleting on an identity column [Mar 2009 - 5 Posts]

Deleting Resource Partitions [Nov 2003 - 5 Posts]

Deleting rows from tables [Sep 2001 - 6 Posts]

Deleting the partial rows [Feb 2005 - 6 Posts]

Deleting Triggers [Oct 2004 - 5 Posts]

Delimited FastExport Question [Dec 2002 - 4 Posts]

Delimited FEXPORT/BTEQ EXPORT [Aug 2006 - 5 Posts]

Delimited text files [Jan 2002 - 9 Posts]

Demo Teradata Version and the Host File [Apr 2006 - 4 Posts]

Denormalized Data Structures [Mar 2005 - 5 Posts]

Dependant objects [Feb 2007 - 8 Posts]

Dependencies Query [Nov 2004 - 7 Posts]

Derived Table in Macro [Apr 2001 - 4 Posts]

Derived table [Jun 2002 - 9 Posts]

Derived Tables and 3710 Error [Nov 2001 - 5 Posts]

Derived Tables in V2R5 [Oct 2003 - 11 Posts]

Derived tables on V2R5 [Feb 2004 - 13 Posts]

Design Considerations for FS-LDM/3NF model [Sep 2005 - 7 Posts]

Designing wide (fat) tables [Jun 2007 - 7 Posts]

Details on Teradata [Feb 2003 - 7 Posts]

Determine Lock in a Table [Jun 2009 - 10 Posts]

Determining spool allocations on development based on allocations in production [Oct 2003 - 3 Posts]

Development enviroment [Aug 2007 - 5 Posts]

Diagnostic HELPSTATS Vs. Statistics Wizard [Jan 2008 - 2 Posts]

Diagnostic Statement to Turn Hash Joins Off For a Session [Oct 2004 - 6 Posts]

Dictionary column for FK constraint check option? [Feb 2009 - One Post]

Dieter's collect stats query on v12 [May 2008 - 7 Posts]

Difference between Backup tools [Sep 2005 - 7 Posts]

Difference between count(*) and count(1) [May 2008 - 2 Posts]

Difference between CPUUExec & CPU [Jul 2004 - 2 Posts]

Difference between Delete and delete All [Sep 2005 - 11 Posts]

Difference between DELETE TABLE & DELETE TABLE ALL [Aug 2004 - 4 Posts]

Difference between Horizontal and Vertical data redistribution [Oct 2004 - 4 Posts]

Difference between Logonoff and sessionifo data [Jul 2008 - 2 Posts]

Difference between NODE CPU, AMP CPU and PE CPU [Jan 2005 - 7 Posts]

Difference between Perm and Spool [Jul 2003 - 9 Posts]

Difference between the ANSI Transaction Mode and the Teredata Transaction mode ? [Jul 2004 - One Post]

Differences between queries [Jan 2006 - 8 Posts]

Different Explain for identical query with different users [Aug 2004 - 10 Posts]

Different Explain plan for different users - SAME SQL [Jan 2006 - 9 Posts]

Different Explains for the same query [Feb 2005 - 8 Posts]

Different explains from queryman versus Session Information in Teradata Manager [Feb 2004 - 4 Posts]

Different plans for the same SQL request [Aug 2004 - 5 Posts]

Difficulty in connecting to a V12 database using Performance Monitor [Aug 2008 - 2 Posts]

Dirty read during UPDATE question [May 2008 - 2 Posts]

DIrty Reads and Multiload locks [Sep 2006 - 4 Posts]

Dirty Reads... Done Dirt Cheap [Jun 2005 - 5 Posts]

Disable AutoCommit for a Session [Jan 2004 - 5 Posts]

Disable logons [Oct 2003 - 7 Posts]

Disadvantages of "Collect Statistics" [Jul 2004 - 6 Posts]

Discrepancies in DBC.TABLESIZE ?? [Sep 2003 - 4 Posts]

Disk & Memory Events trap [Oct 2005 - One Post]

Disk Space overhead? [Mar 2006 - 6 Posts]

DiskArray + [May 2003 - 4 Posts]

Display of comments in help database [Jan 2003 - 5 Posts]

Displaying $ Format [Sep 2004 - 13 Posts]

Displaying More Than 100 Columns using BTEQ [Jan 2004 - 4 Posts]

Displaying view/macro text from the database [Mar 2001 - 9 Posts]

Distance based on latitude and longitude [May 2005 - 22 Posts]

Distance calcuations [May 2006 - 12 Posts]

Distinct count problem [Jan 2003 - 6 Posts]

Distinguish chracters from intergers [Mar 2005 - 9 Posts]

Distributed Data Warehousing Question [Feb 2004 - 4 Posts]

Dmteq testing on Teradata Manager 61 [Dec 2004 - 4 Posts]

DNS and CLI [Feb 2008 - 6 Posts]

DNS creation [Mar 2006 - 7 Posts]

Do we lose available DiskSpace if we change the number of AMPs? [Mar 2004 - 4 Posts]

Docs/pointers to TD architecture [Mar 2005 - 4 Posts]

Does Informatica +really+ force MultiLoad worktables into the target database? [Jan 2004 - 11 Posts]

Does Teradata database 5.1 support internationalization [Jun 2005 - 4 Posts]

Does Teradata have anything similar to Procedural caching (supported with SQL Server) [Nov 2002 - 11 Posts]

Does Teradata Support CLOB? Urgent ! [Oct 2002 - 5 Posts]

Does Teradata Support... [Sep 2002 - 4 Posts]

Does Teradata's JDBC driver support logging or tracing that can be enabled? [Aug 2007 - 4 Posts]

Does Warehouse Builder load data in blocks or rows? [Feb 2003 - 4 Posts]

Doing Concatenation/Substring in Fastload [Sep 2004 - 6 Posts]

DOS FastLoad and CLI315's [Jan 2005 - 15 Posts]

dotNET & Teradata [Jun 2002 - 5 Posts]

Doubt regarding non-partitioned UPI [Aug 2006 - 5 Posts]

Doubts Regarding TD Utilities [Jun 2009 - 4 Posts]

Driver for macro [Feb 2009 - 3 Posts]

Drop constraint not null [Aug 2007 - 4 Posts]

Drop partition with CASE_N [Jan 2005 - 4 Posts]

Drop Stats before loading data ? [Dec 2005 - 4 Posts]

Drop tera table [Dec 2002 - 6 Posts]

Drop the table [Sep 2002 - 8 Posts]

Dropping a secondary index during an INS/SEL [Sep 2004 - 6 Posts]

Dropping a table from sql assistant [Nov 2006 - 13 Posts]

Dropping double quotes from VARCHAR cols [Nov 2005 - 4 Posts]

Dropping non-existent tables! [Jun 2000 - 11 Posts]

Dummy objectname in FROM clause [May 2004 - 4 Posts]

DUMP/RESTORE access right granting [Dec 2004 - 7 Posts]

Duplicate Row Error during an Update [Apr 2008 - 5 Posts]

Duplicate row error [Oct 2006 - 8 Posts]

Duplicate Rows in Fastload [Jun 2003 - 4 Posts]

Duplicate Table across all AMPs [Jun 2004 - 7 Posts]

Duplicate unique prime key error [May 2006 - 4 Posts]

Duplicates in DBC.AccessRights after upgrading to V2R6.2 [May 2008 - 3 Posts]

Duplication followed by Merge Join [Jul 2004 - 4 Posts]

During MLOAD, is there a way to re-route to a flat file rows that fails to load? [Jun 2004 - 5 Posts]

DW/ Query Man SQL Help with Max Version Please [Sep 2005 - 5 Posts]

Dynamic SQL Error: User is not authorized [Apr 2008 - 3 Posts]

Dynamic SQL in Stored Procedures [Mar 2003 - 4 Posts]

Dynamic SQL in Tera data [Dec 2003 - 5 Posts]

Dynamic SQL inside SPL [Feb 2004 - 4 Posts]

Dynamic SQL on Mainframe [Oct 2006 - 6 Posts]

Dynamic View creation [Aug 2007 - 4 Posts]

Dynanic sql statements for SELECT REQUEST [Dec 2003 - 4 Posts]



E/R diagram (sic) of DBC [May 2008 - One Post]

EDW - Logically Integrated across multiple DBs v/s Single DB [May 2004 - 7 Posts]

Effect of Collect Stats on Multi-value compressed [Jun 2008 - One Post]

Effect of ORDER BY in performance [Jan 2005 - 4 Posts]

Efficient way to modify column datatype. [Jul 2006 - 7 Posts]

Eliminating Column Titles during a FastExport [Jul 2004 - 4 Posts]

Email alerts through Teradata Manager [Nov 2001 - 5 Posts]

Emailing based on table activity [Jun 2009 - 4 Posts]

Embed Java program in Teradata UDF [Apr 2009 - 3 Posts]

Embedded Teradata calls in REXX [Sep 2004 - 4 Posts]

EMC vs. LSI [May 2003 - 8 Posts]

Empty Value [Nov 2003 - 8 Posts]

Enabling LastAccessTimeStamp [Jan 2007 - 5 Posts]

Encryption of Column Values [May 2003 - 7 Posts]

Encryption of data [Jun 2002 - 6 Posts]

Enhancements or Improvements to Stored Procedures [Jul 2007 - 5 Posts]

Environment Variable in BTEQ [Jan 2004 - 5 Posts]

Environment Variables: Teradata-to-DB2 II [Jun 2005 - 4 Posts]

Epoch function [Feb 2005 - 6 Posts]

Equivalent Data Type [May 2004 - 4 Posts]

Equivalent for CURSOR%NOTFOUND & SQL%ROWCOUNT [Jan 2009 - 3 Posts]

Equivalent of DB2's BIGINT in Teradata [Oct 2005 - 9 Posts]

Equivalent of FastLoad NULLIF in USING [Jun 2006 - 5 Posts]

Erratic results via Business Objects [Feb 2002 - 5 Posts]

Error - 3789: multiple Format opions [May 2006 - 5 Posts]

Error 2641 - table was restructured [Dec 2004 - 9 Posts]

Error 2644 [Jan 2002 - 5 Posts]

Error 2825 NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART [Sep 2005 - 5 Posts]

Error 3132: Access Logging step has failed [Sep 2008 - 6 Posts]

Error 3523 owner referenced by User doesn't have Select Grant Option on the table [Nov 2008 - 6 Posts]

Error 3523: An owner referenced by user does not have SELECT WITH GRANT OPTION [Sep 2004 - 5 Posts]

Error 3541: The request to assign new PERMANENT space is invalid [Mar 2004 - 6 Posts]

Error 3695 in Fast Export - A Single AMP Select [May 2005 - 4 Posts]

Error 5764 Lobs are not allowed to be selected on record and indicator modes [Aug 2005 - 2 Posts]

Error 5788: creating table from View structure [Mar 2008 - 8 Posts]

Error 6707 During Fastload of Timestamp(0) Field [May 2005 - 4 Posts]

Error 7453: Interval field overflow [Feb 2003 - 4 Posts]

Error 8006 while creating UDF [Apr 2005 - 5 Posts]

Error :3518 Too many column in composite Index [Jul 2005 - 6 Posts]

ERROR [207] MTDP: EM_NETCONN(207) [Jul 2007 - 5 Posts]

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

Error code -1 when executing replace procedure statement [Aug 2005 - 6 Posts]

Error Code 2971- The AMP Lock Table has Overflowed [Mar 2008 - 4 Posts]

Error code 3521: table reference detected where constant expected [Jun 2006 - 4 Posts]

Error for .import with filter condition [Feb 2007 - 7 Posts]

Error handling in BTEQ ??? [Nov 2005 - 6 Posts]

Error in Ab Initio MultiLoad component [Jun 2004 - 5 Posts]

Error in Mload: DBCHCL returned 100 [Jan 2008 - 2 Posts]

Error in readig HISTORY table in Queryman [Jun 2009 - 4 Posts]

Error in SQL Assistant: Invalid Procedure Call or Argument [Aug 2007 - 4 Posts]

Error invoking multiload on AIX4.3.2 server [Jan 2002 - 4 Posts]

Error Message " Internal error: Please do not [Apr 2007 - 5 Posts]

Error message in fast export [Nov 2003 - 7 Posts]

Error on multload [Feb 2004 - 6 Posts]

Error trapping a deadlock inside Bteq? [Sep 2005 - 5 Posts]

Error while importing a file in bteq [May 2005 - 4 Posts]

Error while loading the Terradata table using Teradata_Mload_External_Loader [Aug 2006 - 5 Posts]

Error while modifying constraint [Nov 2008 - 7 Posts]

Error with timestamp calculation [Jul 2006 - 7 Posts]

ERROR Writing a Stored Procedure?? [May 2004 - 7 Posts]

Error: 3541 The request to assign new PERMANENT [Jan 2006 - 4 Posts]

Error: A table may not have more than one identity column [Aug 2008 - 3 Posts]

Errors during mload [May 2008 - 2 Posts]

Errors: Right truncation of string data & Interval field overflow [Sep 2004 - 3 Posts]

Erwin and Soft RI [Apr 2004 - 4 Posts]

Erwin forward engineer [Apr 2004 - 6 Posts]

ERWIN postscripts and Teradata [Nov 2005 - 4 Posts]

ERWin with Teradata Enviornment [Nov 2004 - 2 Posts]

Escape Character in SQL [Nov 2003 - 5 Posts]

Essbase and Teradata. [Sep 2005 - 9 Posts]

Establishing connction to Teradata Manager 6.0 [Mar 2004 - 4 Posts]

Estimating row count [Dec 2002 - 9 Posts]

ET in Teradata DELETE MLOAD [Jun 2009 - 6 Posts]

Eternally Foolproof Casting from text to number [Jul 2007 - 6 Posts]

ETL and MSI Reporting Playing Nice [Jul 2003 - 4 Posts]

ETL approach [Nov 2002 - 6 Posts]

ETL Tools with Teradata [Jan 2001 - 6 Posts]

ETL: Push vs Pull [May 2004 - 4 Posts]

Even not having stats collected,would the optimizer know the size of a volatile table? [Jun 2006 - One Post]

Examples for a beginner [Apr 2002 - 11 Posts]

Excel spreadsheets [Jul 1999 - 10 Posts]

Exception handler [Aug 2005 - 4 Posts]

Exception handling for stored procedures and functions [Dec 2008 - 12 Posts]

Excessive Delays between DBQLogTbl's StartTime and FirstStepTime [Nov 2005 - 12 Posts]

Exchange Rate Join Problems [Jun 2001 - 5 Posts]

Excluding tables in Arcmain [Nov 2003 - 9 Posts]

Exclusion Joins [May 2004 - 10 Posts]

Exclusive locking with volatile [Jun 2008 - 3 Posts]

Executing a Macro using ADO or DAO [Sep 2002 - 4 Posts]

Executing Dynamic SQL using BTEQ scripts [Nov 2004 - 7 Posts]

Executing multiple SQLs in parallel through JDBC [Nov 2003 - 4 Posts]

Executing queries in parallel [Sep 2005 - 6 Posts]

Executing SQL from a Column [Apr 2001 - 4 Posts]

Executing the SQL Query based on Parameter [Apr 2006 - 4 Posts]

Execution of multiple macro's inside a macro [Oct 2006 - 6 Posts]

Execution Plans for ANSI vs non_ANSI formatted SQL [Oct 2001 - 6 Posts]

Execution times for queries [Oct 2002 - 10 Posts]

EXISTS predicate bug? [Feb 2004 - 10 Posts]

Exists/Not Exists versus IN/Not IN [Dec 2001 - 6 Posts]

Exiting on BTEQ errors [Mar 2007 - 14 Posts]

Expected lifespan of MPRAS? [Apr 2003 - 9 Posts]

Expecting Suggestions for Teradata Upgarde V2R5.0 [Sep 2005 - 4 Posts]

Experience with Locking Logger [Oct 2003 - 5 Posts]

Experience with the JDBC Type 4 Driver [Apr 2004 - 10 Posts]

Experiences with ETL Tools [Aug 2005 - 4 Posts]

Experiences with implementing Teradata Dynamic Workload Manager [Jun 2008 - 2 Posts]

Experiences with Teradata Compression? [Nov 2004 - 5 Posts]

Experiences with the Priority Scheduler? [Nov 2000 - 21 Posts]

Experiences with TSM and Teradata [Feb 2006 - 10 Posts]

Expiring LogonID Passwords [Jul 2003 - 4 Posts]

EXPLAIN cost estimates [Jan 2001 - 6 Posts]

EXPLAIN Failing On Some Multiple Statements [Dec 2008 - One Post]

Explain Plan for a Procedure [Jan 2009 - 3 Posts]

Explain Plan Question [Sep 2006 - 5 Posts]

EXPLAIN rights [Dec 2005 - 33 Posts]

Explaing EXPLAIN [Jun 2003 - 7 Posts]

Explanation of Allness Flag? [Jan 2004 - 4 Posts]

Export / Import of Decimal (10,2) field... [Oct 2005 - 4 Posts]

Export file in format PDF from NCR [Mar 2004 - 5 Posts]

Export from MS Access 2000 to Teradata [May 2004 - 6 Posts]

Export Issue Retrieving 400 Columns [Jul 2007 - 6 Posts]

Export results in a fixed format [Sep 2003 - 4 Posts]

Export to a text file using OLE-DB [Nov 2005 - 9 Posts]

Exporting & Importing Dates in SQL Assistant [May 2005 - 3 Posts]

Exporting 300G and importing it [Jul 2003 - 6 Posts]

Exporting Data from Teradata into a Unix Pipe [Sep 2001 - 6 Posts]

Exporting non-English character set [May 2008 - 2 Posts]

Exporting output for scheduled Queryman jobs [Apr 2003 - 5 Posts]

Exporting time [Jan 2002 - 5 Posts]

Exporting Unicode Data from MS Access to Teradata [Dec 2007 - 4 Posts]

External Authentication [Apr 2005 - 6 Posts]

Extra secondary index on large table [Sep 2004 - 4 Posts]

Extra security elements [Apr 2008 - 5 Posts]

Extract day of week from date [May 2003 - 5 Posts]

Extract values from field [Apr 2008 - 10 Posts]

Extracting characters from a string [Dec 2003 - 4 Posts]

Extracting DDL of a whole database [Feb 2003 - 16 Posts]

Extracting piece of data from a string of text [Apr 2005 - 4 Posts]

Extracting time from numeric field [Nov 2007 - 5 Posts]

Extracting value with Substring and position [May 2008 - 2 Posts]

Extracting Week from date [Jan 2009 - 4 Posts]

Extracting word from LOGONSOURCE [Apr 2006 - 4 Posts]



Factorial in Teradata [Sep 2005 - 7 Posts]

Facturation of CPU time use [Sep 2000 - 7 Posts]

Failed to Open a rowset error [Aug 2008 - 2 Posts]

Failure 2641 was restructured. [Oct 2006 - 6 Posts]

Failure 5708 Table header size exceeds limit [May 2005 - 9 Posts]

Failure ARC0805: Access Module returned error code 29: Empty file on read open. [Apr 2004 - 4 Posts]

Fallback vs. RAID1 vs. Journaling [Jan 2004 - 4 Posts]

Fast Export - VARCHAR concatenation [Nov 2002 - 4 Posts]

Fast Export 3807 error [Nov 2002 - 6 Posts]

Fast Export and file closure [Dec 2003 - 5 Posts]

Fast export and Varchar [Aug 2002 - 7 Posts]

Fast Export Checkpoint [Mar 2004 - 4 Posts]

Fast export data file problem [Jun 2006 - 6 Posts]

Fast Export Decimal problem [Nov 2004 - 9 Posts]

Fast Export DLL for DTS [Apr 2000 - 4 Posts]

Fast Export Error - Single AMP Select statement has been issued in Fast Export [Sep 2006 - 11 Posts]

Fast Export is skipping spaces at the end of [Apr 2008 - 2 Posts]

Fast Export question [Apr 2003 - 10 Posts]

FAST EXPORT Replace function [Aug 2004 - 16 Posts]

Fast export Version FEXP.07.06.02.000 [Apr 2003 - 5 Posts]

Fast Export, Multi Load or INSERT/SELECT [Feb 2004 - 5 Posts]

Fast load Script is getting paused [May 2005 - 4 Posts]

Fast Load- How to set filename as a variable in the fastload script [Jun 2006 - 4 Posts]

Fast loading a variable length dataset [Jan 2005 - 4 Posts]

Fast Path Insert [Mar 2003 - 8 Posts]

fast-export vertical & horizontal data distribution [Mar 2005 - 3 Posts]

Fastexport & Multiload Macro Generator [Apr 2006 - One Post]

Fastexport & Sesson Crashed, [Mar 2001 - One Post]

FastExport & the UNIX 2 Gigs limit. [Apr 2001 - 3 Posts]

Fastexport a file then fastload the file [May 2008 - 5 Posts]

FastExport and binary in first character position [May 2003 - 4 Posts]

FastExport and the number of sessions vs. skewing [Dec 2005 - 5 Posts]

FastExport and UTF8 translation of SQL [Feb 2008 - 6 Posts]

FastExport Benchmarking [Mar 2003 - 5 Posts]

Fastexport conundrum.. [Dec 2003 - 5 Posts]

FastExport Error from NT [Sep 2007 - 4 Posts]

Fastexport flatfile problem [Nov 2008 - 2 Posts]

Fastexport HEX chars at the beginning of each record [Nov 2008 - 8 Posts]

Fastexport manual inconsistency [Jun 2004 - 5 Posts]

FastExport Output Formatting [Mar 2001 - 8 Posts]

FastExport performance vs. Fastload [Mar 2005 - 7 Posts]

FastExport return code [Jul 2002 - 4 Posts]

FastExport S0C4 [Oct 2001 - 4 Posts]

FastExport Scenario: Appending files [Jul 2008 - 2 Posts]

Fastexport Script for Double Byte Characters [Nov 2006 - 4 Posts]

FastExport to a named pipe [Jul 2005 - 4 Posts]

FastExport with ACCEPT command [Nov 2003 - 4 Posts]

Fastexport, multiload, nulls and blanks [Oct 2005 - 5 Posts]

Fastexport-Outmod and RDBMS-Restarts [Oct 2002 - 8 Posts]

FastExport? [Mar 2004 - 7 Posts]

Fastload & pipe delimited file [May 2008 - 10 Posts]

FastLoad & MultiLoad [Jun 1999 - 2 Posts]

Fastload (pc .txt file) [Dec 2005 - 6 Posts]

Fastload + INS / SEL or MultiLoad [Aug 2007 - 7 Posts]

FASTLOAD - NOTIFY EXIT question [Jul 2003 - 10 Posts]

Fastload : Loading timestamp column values [Nov 2004 - 4 Posts]

Fastload a non-fixed-formatted date field [Jul 2006 - 5 Posts]

Fastload Acquisition Phase [Nov 2003 - 5 Posts]

Fastload and default values [Mar 2003 - 6 Posts]

Fastload and mixed records [Mar 2002 - 5 Posts]

Fastload and nullif [Oct 2003 - 6 Posts]

Fastload and PE connections [Jan 2009 - 2 Posts]

Fastload and TAB delimiter [Feb 2004 - 7 Posts]

Fastload comments [Mar 2001 - 4 Posts]

Fastload data between different version database v2r5 & v2r4 [Jun 2003 - One Post]

Fastload Data Transfer [Feb 2000 - 6 Posts]

Fastload error 3523 [Jan 2000 - 6 Posts]

Fastload Error 8017: The UserId, Password or Account is invalid [Apr 2007 - 4 Posts]

Fastload Error Table question [Feb 2003 - 9 Posts]

Fastload error: FDL4822 DEFINE statement [Feb 2009 - 2 Posts]

FastLoad Errors vs MLoad [Apr 2007 - 5 Posts]

Fastload FORMAT [Jul 2005 - 4 Posts]

Fastload from within DTS [Dec 2004 - 4 Posts]

FastLoad Getting File Read Errors - BTEQ & MultiLoad Do Not [Sep 2001 - 4 Posts]

Fastload Help [May 2001 - 4 Posts]

Fastload in Unix [Nov 2005 - 6 Posts]

FastLoad or MultiLoad Sample script [Feb 2004 - 5 Posts]

Fastload parsing performance [Jan 2009 - 4 Posts]

Fastload pipe delimited file from MVS [Nov 2008 - 4 Posts]

Fastload Problem: No room in database [May 2005 - 21 Posts]

FastLoad Record Delimiter [Nov 2007 - 4 Posts]

FastLoad Release Lock Command [Sep 2004 - 4 Posts]

Fastload syntax errors: 3808 [Jun 2005 - 5 Posts]

Fastload trailing nullcols equivalent [Feb 2009 - One Post]

FastLoad VS MLoad [Jan 2005 - 5 Posts]

Fastload vs Multiload [Aug 2001 - 7 Posts]

Fastload/fastexport and length problem [Sep 2004 - 7 Posts]

FastLoad: Discarding Duplicate Rows [Jan 2001 - 9 Posts]

Fastloading a Time Value [Jan 2003 - 4 Posts]

Fastloading delimited file [Apr 2005 - 4 Posts]

Fat vs Thin table headers [Feb 2008 - 3 Posts]

Feactures of FastExport [Jun 2004 - 5 Posts]

Features of Teradata metadata services [Oct 2006 - 7 Posts]

Feedback on Global Temporary Tables [May 2004 - 13 Posts]

Ferret PackDisk Basic Questions [Dec 2004 - 5 Posts]

Fetch Time from DBQL [Apr 2005 - 8 Posts]

Fexp script to a CSV file [Nov 2003 - 5 Posts]

Ficon and teradata [Jun 2009 - 2 Posts]

Filesystems on application nodes [Dec 2001 - 4 Posts]

Filter and convert alphanumeric data to numeric data [May 2008 - 3 Posts]

Filtering the Junk values from a field [Jul 2005 - 4 Posts]

Final SQL code--expanded with view definition [Jul 2007 - 4 Posts]

Find name of Join Index [Oct 2002 - 4 Posts]

Find the good information between the userid and the username in TERADATA V2R5 [May 2006 - 3 Posts]

Finding and removing locks [Dec 2003 - 7 Posts]

Finding Empty Tables [Jun 2003 - 12 Posts]

Finding frequency of NUSI usage [Apr 2009 - 8 Posts]

Finding Multiload locks [Aug 2007 - 13 Posts]

Finding out the table in Macros [Apr 2007 - 6 Posts]

Finding previous record puzzle [Feb 2005 - 6 Posts]

Finding previous value [Jan 2008 - 10 Posts]

Finding rows in one table not in another [Jul 2007 - 5 Posts]

Finding spool usage for each STEP in the explain [May 2006 - 5 Posts]

Finding tablename using Tableid [Feb 2007 - 7 Posts]

Finding TDPID [Feb 2004 - 5 Posts]

Finding the earliest combination of separate DATE and TIME fields [Aug 2005 - 6 Posts]

Finding the last day of the month [Feb 2003 - 11 Posts]

Finding the last Friday of the year [Dec 2006 - 8 Posts]

Finding the TDPID [Jan 2006 - 4 Posts]

Re: Finding View Info [Dec 2004 - One Post]

Finding View information [Dec 2004 - 10 Posts]

FIRST and LAST value question [Dec 2003 - 6 Posts]

First Row Function [Oct 2008 - 12 Posts]

Fixed width files from FastExport [Aug 2005 - 8 Posts]

Flat file limit [Dec 2008 - 4 Posts]

Fload problem: a discrepency between read and expected [Mar 2005 - 4 Posts]

Float data type compressions [Oct 2007 - 4 Posts]

Float to Timestamp Conversion [Mar 2004 - 8 Posts]

Flush the cache [Jan 2008 - 5 Posts]

FOR cursor in teradata [Apr 2008 - 2 Posts]

Format function [Apr 2005 - 4 Posts]

FORMAT Issue with FLOAT datatype? [Jul 2005 - 5 Posts]

Format of Date [Nov 2003 - 11 Posts]

Format of timestamp in select [May 2007 - 4 Posts]

FORMAT Problem [Jan 2003 - 4 Posts]

Format statement and floating point numbers [May 2002 - 12 Posts]

Formats with Multiload [Jan 2006 - 4 Posts]

Formatting string to DATE [Jun 2004 - 6 Posts]

Freq of index usage [Feb 2008 - 5 Posts]

From Lotus Notes DB to Teradata [Aug 2003 - 5 Posts]

FSLDM as ELDM [Apr 2009 - 2 Posts]

Full-Table Scans and Secondary Indexes [Jun 2002 - 8 Posts]

Fully qualified domain names and Teradata utilities [Nov 2003 - 6 Posts]

Function "Monthname" in SQL Assistant [Sep 2004 - 8 Posts]

Function for finding minimum among multiple values [Mar 2007 - 5 Posts]

Function for Pivoting Data [Feb 2008 - 2 Posts]

Function in teradata to calculate the Product??? [Mar 2004 - 9 Posts]

Functions of dates! [Oct 2000 - 11 Posts]



GCC compiler [Apr 2004 - 7 Posts]

Generate ddl [Oct 2003 - 4 Posts]

Generate unique id [Oct 2007 - 10 Posts]

Generated SQLs getting truncated [May 2007 - 9 Posts]

Generating a wide report using BTEQ [Apr 2006 - 6 Posts]

Generating new value every time INSERT work [Jan 2008 - 5 Posts]

Generating Oracle's chr(10) [Aug 2005 - 5 Posts]

Generating the Header and Trailer in the Data File [May 2005 - 4 Posts]

Generating week dates without sys_calendar [Sep 2004 - 12 Posts]

Generation of Sequential Rows [Jun 2006 - 7 Posts]

Generation of Surrogate Keys [Nov 2007 - 13 Posts]

Generic question [Mar 2002 - 14 Posts]

Get session information from dbscontrol window [May 2003 - 5 Posts]

Geting the database name by using SQL which is locked by a failed backup job [Jan 2005 - 11 Posts]

Getting 3916 errocode [Feb 2006 - 12 Posts]

Getting a complete list of users from dbc.users [Nov 2005 - 7 Posts]

Getting a session's own resource info [Oct 2008 - 5 Posts]

Getting a weird error when trying to log in from unix [Sep 2003 - 6 Posts]

Getting column headers in Fast Export [May 2008 - 2 Posts]

Getting error in import and repeat commands in bteq [Jun 2008 - 4 Posts]

Getting rid of Unrequired Journal [Jun 2006 - 5 Posts]

Ghost sessions [Dec 2002 - 8 Posts]

Global temp tables [Jan 2004 - 4 Posts]

Global Temporary Table not available [Mar 2003 - 4 Posts]

Global Temporary Tables (GTT) and Statistics [Dec 2005 - 5 Posts]

Global Temporary Tables and Statistics [Feb 2009 - 2 Posts]

GLOBAL TT against VOLATILE T [Mar 2000 - 4 Posts]

Grabbing the Return code [May 2008 - 4 Posts]

Graceful shut down of Teradata [Jun 2001 - 11 Posts]

GRAND TOTAL Not coming in the output screen [Dec 2006 - 12 Posts]

GRANT at database level.. [Jul 2003 - 8 Posts]

Grant Option Cannot be Granted to a Role [Nov 2006 - 9 Posts]

Grant to ALL user [Aug 2002 - 4 Posts]

GRANT TO PUBLIC [Feb 2002 - 4 Posts]

Grant/Revoke logons for all users [Nov 2006 - 4 Posts]

GREATEST of N numbers [Sep 2003 - 7 Posts]

Group By and non-aggregated values [Apr 2004 - 4 Posts]

Group by of multiple columns for teradata and [Dec 2006 - 5 Posts]

Group by on one column but select multiple columns [May 2005 - 4 Posts]

Group Key word [Nov 2008 - 8 Posts]

GSC tools [Jun 2002 - 5 Posts]

Guidelines for using Distinct vs. group by [Feb 2005 - 12 Posts]



Handling 21 digits in Teradata [Dec 2006 - 6 Posts]

Handling a 64 bit ID [Jan 2006 - 5 Posts]

Hard Coded Date in a Case Statement Issue [Nov 2004 - 5 Posts]

Hardware for Teradata [Feb 2009 - 3 Posts]

Has any had success with views that UNION Tables [Apr 2005 - 6 Posts]

Has anyone experienced a similar RDBMS failure, 8017? [Oct 2003 - 5 Posts]

Has anyone run Teradata utilities across a WAN ~1500 miles? [May 2008 - 2 Posts]

Hash joins [Aug 2001 - 5 Posts]

Help (on Stats) [Jan 2008 - 6 Posts]

Help for Canary Queries [May 2008 - 2 Posts]

Help in a procedure: Counting rows [Apr 2008 - 6 Posts]

Help on cursors in teradata [Dec 2008 - 5 Posts]

Help on Explain [Dec 2003 - 4 Posts]

Help on Join Index with Outer Joins, please. [Oct 2005 - 6 Posts]

Help on Join Indexes [May 2004 - 4 Posts]

Re: HELP TABLE query doesn't work with V2R 5.1.1 [Nov 2004 - 3 Posts]

Help to Transform UTF8 data file to Teradata using OLE DB AXMOD [Oct 2004 - 4 Posts]

Help understanding the Like operator [Nov 2004 - 4 Posts]

Help with dynamic SQL in Store Procedure [Jun 2008 - One Post]

Help with Ms Access dates [Jul 2008 - 2 Posts]

Help with T-SET [Feb 2009 - 2 Posts]

Help with TRIM and SUBSTR [Aug 2003 - 4 Posts]

Hexadecimal to binary conversion [May 2008 - 4 Posts]

Hexadecimal value for char-Mload error [Apr 2004 - 9 Posts]

High confidence in Explain [Feb 2008 - 5 Posts]

High skew while doing rank [Aug 2007 - 4 Posts]

Hints for Teradata Optimizer [Sep 2006 - 8 Posts]

Historical database space [Dec 2006 - 4 Posts]

History in Queryman [Mar 2002 - 4 Posts]

History of database access [Mar 2005 - 4 Posts]

History table monthend logic [Jan 2003 - 4 Posts]

HOLOS and V2R5 Upgrade. [Jan 2005 - 4 Posts]

Home grown performance reporting [Dec 2003 - 11 Posts]

Horizontal Rules Based partitions [Oct 2004 - 4 Posts]

Hot Amp [Jun 2000 - 8 Posts]

How to Concatenate Column Values using SQL/Macros [Aug 2005 - 5 Posts]

How About Insert Select Statement in MLOAD [Aug 2004 - 8 Posts]

How can I advance a date value? [May 2004 - 10 Posts]

How Can I Avoid Repeating an Expression? [Aug 2008 - 13 Posts]

How Can I know the status of a Session ? [Mar 2008 - 3 Posts]

How can I tell when the last time a table was modified? [Aug 2003 - 12 Posts]

How can i use .ACCEPT in my script? [Jun 2008 - 2 Posts]

How can retrieve BMP/JPG/GIF thru SQL Assistant? [Jan 2005 - 10 Posts]

How can we find, who dropped production table [Nov 2006 - 5 Posts]

How can you check the return code or condition code from an NT or SOLARIS based ARCMAIN [Jun 2002 - 4 Posts]

How COPs work [Feb 2008 - 2 Posts]

How DBCMNGR table gets populated? [Jul 2006 - 5 Posts]

How do I calculate Spool Usage [Jun 2004 - 9 Posts]

How do i can increase DBC database space? [Aug 2004 - 20 Posts]

How do I CAST a numeric into a numeric? [Jun 2004 - 4 Posts]

How do i extract time out of a datetime field [Apr 2004 - 6 Posts]

How do I get rid of frozen spool space? [Jul 2003 - 4 Posts]

How do I get values into a BTEQ script w/o an IMPORT file? [Feb 2003 - 10 Posts]

How Do You Measure/Validate Compression Savings? [Jan 2007 - 21 Posts]

How does MLoad connect? [May 2006 - 4 Posts]

How does queryman calculates the total number of rows? [Nov 2003 - 8 Posts]

How does Teradata Manager determine 100% CPU Busy [Mar 2009 - 2 Posts]

How good is Explain on a SQL ? [Apr 2006 - 10 Posts]

How GROUP BY improves the performance than [Mar 2008 - 5 Posts]

How much statistics to collect [Dec 2003 - 9 Posts]

How setup a e-mail notification from mload on failure of job [Jan 2003 - 14 Posts]

How to achieve ROWID in Teradata [Jul 2008 - 5 Posts]

How to Achieve the decimal part [Jul 2008 - 7 Posts]

How to add a new AMP or VPROC ??? [Nov 2005 - One Post]

How to adjust time on a Teradata server? [May 2002 - 4 Posts]

How to Alter table a UPI column [May 2008 - 3 Posts]

How to Analyze tables in Teradata? [Jul 2008 - 13 Posts]

How to archive more than one tables from a database [Jun 2006 - 7 Posts]

How to avoid Product join [Dec 2008 - 5 Posts]

How to build cubes [Feb 2008 - 3 Posts]

How to change date formats in views? [Jul 2006 - 8 Posts]

How to change the time format in teradata [Nov 2006 - 5 Posts]

How to check the value of a bit in a BYTE field. [Jul 1999 - 4 Posts]

How to clear the aborting sessions? [Oct 2003 - 4 Posts]

How to code a join or restructure table? [Feb 2008 - 9 Posts]

How to concatenate the column values [Jan 2004 - 8 Posts]

How to connect teradata to Active Directory Services Interface. [Mar 2006 - 4 Posts]

How to connect to SQL Server Database through Bteq [Aug 2006 - 9 Posts]

How to convert decimal to hex [Aug 2003 - 6 Posts]

How to Convert Records into Columns [Dec 2005 - 4 Posts]

How to create sys generated keys [Sep 2003 - 13 Posts]

How to create the structure of database window [Aug 2003 - 4 Posts]

How to delete selectively [Jun 2005 - 7 Posts]

How to determine column data types for VIEWS [Aug 2006 - 4 Posts]

How to determine if encryption is turned on [Mar 2009 - 2 Posts]

How to determine if the crashdumps capability is enabled [Mar 2008 - 2 Posts]

How to Disconnect Users During Loads [Apr 2003 - 13 Posts]

How to display a record set using Stored procedure [Nov 2002 - 5 Posts]

How to display complete month name [Mar 2008 - 4 Posts]

How to do a backup without using a tool? [Apr 2009 - 5 Posts]

How to do timestamp arithmetic [Jan 2002 - 4 Posts]

How to Drop identity property? [Sep 2008 - One Post]

How to drop macros created on DBC with a user that currently doesn't exist [Jan 2000 - 2 Posts]

How to Drop Table with Double Quotes in the Name [Jul 2003 - 4 Posts]

How to dump all object definitions in a database [Feb 2007 - 10 Posts]

How to fetch specific number of rows [Jun 2003 - 8 Posts]

How to figure out who is filling up the Transient Journal [Jan 2004 - 4 Posts]

How to Find Index Structure of a Table [Jun 2007 - 4 Posts]

How to find Partitioning Space? [Oct 2007 - 4 Posts]

How to find the table list for particular value of a column in a Database. [Jul 2006 - 5 Posts]

How to find the week-ending-date for a given date? [Feb 2004 - 8 Posts]

How to FORMAT date [Sep 2006 - 8 Posts]

How to generate title column using bteq export [Aug 2008 - 6 Posts]

How to generate title column using fixed-length bteq export [Aug 2008 - 2 Posts]

How to get batch variable in mload script [Dec 2002 - 4 Posts]

How to get column types in views [Mar 2007 - 5 Posts]

How to Get Count(*) in UNIX Variable [Dec 2008 - 10 Posts]

How to get prompt for input variable [May 2008 - 5 Posts]

How to get table names from table ids [Aug 2004 - 5 Posts]

How to get the names of all the databases under a particular user id [Nov 2005 - 4 Posts]

How to get the REAL explaination for a query with variable [Oct 2006 - 5 Posts]

How to get top N records [Jul 2006 - 7 Posts]

How to handle logins in scripts and Ascential DataSTage jobs? [Mar 2005 - 5 Posts]

How to hide passwoed for Mload script [Jul 2008 - 3 Posts]

How to identify all multi-column stats [Jul 2008 - 5 Posts]

How to Identify LOCKS using Data Dictionary and Queries. [Aug 2005 - 9 Posts]

How to identify numerics in alphanumerics ? [Jun 2004 - 6 Posts]

How to identify the spool space of a particular [Mar 2007 - 4 Posts]

How to identify which column in TD2621 error [Apr 2004 - 5 Posts]

How to implement the sequence concept in teradata [Apr 2003 - 14 Posts]

How to improve MLoad performance [Apr 2007 - 5 Posts]

How to know state by script ? [Jun 2006 - 5 Posts]

How to know the size of storage space of NUSI??? [Mar 2005 - 5 Posts]

How to know which database I am using? [Jan 2008 - 7 Posts]

How to leave an intentional lock for testing [Nov 2005 - 15 Posts]

How to load data after BMC Unload [Apr 2009 - 3 Posts]

How to make use of distinct option with count window function. [Jul 2004 - 4 Posts]

How to merge contiguous date ranges [Sep 2006 - 5 Posts]

How to migrate blob object from oracle to [Dec 2008 - 3 Posts]

How to pass external arguements to mload script [Jan 2003 - 7 Posts]

How to pass the User-ID and Password on a Command-Line [Aug 2004 - 5 Posts]

How to prevent high skewness between large_tableA join large_tableB [Dec 2006 - 4 Posts]

How to print heading one time only in a BTEQ query? [Feb 2004 - 13 Posts]

How to print messages from BTEQ Script? [Mar 2003 - 6 Posts]

How to query a table having both Primary as well as Secondary Index [Jun 2003 - 6 Posts]

How to release locks from a table. [Jul 2004 - 9 Posts]

How to remove 'spaces' in a telephone number field using Teradata SQL [Jan 2004 - 12 Posts]

How to reset a fasltoad job [Mar 2003 - 5 Posts]

How to restrict users for Access ( TD [May 2008 - One Post]

How to retrieve tablename and its count dynamically [Aug 2004 - 6 Posts]

How to revoke abort session from pmon for developers [Feb 2008 - 7 Posts]

How to run the Select SQL generated as a result of a SQL in Macro or Procedure [Aug 2007 - 7 Posts]

How to select row numbers with something like rownum [Jun 2004 - 6 Posts]

How to simulate built in function RPAD of Oracle in Teradata [Apr 2005 - 5 Posts]

How to stop or avoid Rollback or recovery process [Aug 1999 - 4 Posts]

How to stop Roll Back with out making table Invalid. [Aug 2005 - 4 Posts]

How to store a JPEG in a table? [Nov 2002 - 6 Posts]

How to take Teradata backup [Jun 2004 - 5 Posts]

How to USE IF THEN ELSE in MultiLoad [Nov 2002 - 5 Posts]

How to use Informatica and Teradata support tools for DW [Jan 2002 - 5 Posts]

How to validate the invalid references created [Jun 2006 - 4 Posts]

How to write procedure in teradata [Feb 2008 - 14 Posts]

How we can turn on & off Locking Logger? [Apr 2008 - 5 Posts]



I'm stumped...case logic on a left join subquery vs. case logic on a select query [Feb 2003 - 12 Posts]

Idea for the implementation of a view needed [Apr 2003 - 4 Posts]

Ideas on querying the Call_hist detailed record table [Jul 2003 - 5 Posts]

Ideas on Teradata Business Continuity [Jul 2003 - 4 Posts]

Identifying backup is running [Jun 2007 - 6 Posts]

Identifying foreign keys in queryman or winddi [Feb 2003 - 7 Posts]

Identifying Large NUSI ? [Mar 2006 - 17 Posts]

Identifying Partitioned Tables [Feb 2008 - 4 Posts]

Identifying row failed in CHECKTABLE [Sep 2001 - 5 Posts]

Identifying Table usage [Apr 2006 - 7 Posts]

Identity -- min, max significance [Apr 2008 - 2 Posts]

Identity Column & UPI [Apr 2006 - 8 Posts]

Identity Column Crisis [Dec 2003 - 8 Posts]

Identity Column with DEFAULT option on a UPI [Apr 2008 - 2 Posts]

Identity Columns [May 2004 - 5 Posts]

Identity function sequence number [Apr 2009 - 3 Posts]

IDLE and RESPONDING sessions for Cognos Users [Sep 2008 - 4 Posts]

Idle logons [Feb 2000 - 5 Posts]

Idle Network Users [Jun 2003 - 6 Posts]

IDLE Session auto-kill [Mar 2003 - 4 Posts]

Idle Sessions Tenacity [Jul 2001 - 9 Posts]

IDs datatypes for schema design [Jan 2001 - 6 Posts]

If Exists Then ...Else .... [Jul 2004 - 6 Posts]

Illegal seek error [Nov 2003 - 5 Posts]

Impact of a Heartbeat Query [Jan 2008 - 5 Posts]

Impact of changing MaxDecimal from 15 to 18 [Sep 2004 - 7 Posts]

Impact of Increasing MaxParseTreeSegs [Mar 2008 - 7 Posts]

Impacts of adding column to a large table [Feb 2008 - 2 Posts]

Implications of 2 different DDLs of a same view?? [Nov 2002 - 5 Posts]

Import causing all-amp operation [Jul 2001 - 8 Posts]

Import Data from .csv file to a table using MultiLoad [Feb 2004 - 9 Posts]

IMPORT File and BTEQ 'variables' [Nov 2004 - 4 Posts]

Import File Size Limitation in MLoad/FastLoad/Tpump [Nov 2002 - 4 Posts]

Import via ODBC [Dec 2000 - 9 Posts]

Import/Export data with decimal characters [Dec 2007 - 6 Posts]

Importing Column Title & Comment Metadata into BI [Jan 2008 - 2 Posts]

Importing data from text file [Apr 2006 - 5 Posts]

Improper column reference in the search condition of a [Sep 2002 - 6 Posts]

Improving performance of Bteq Export [Apr 2003 - 4 Posts]

IN clause limt [Dec 2008 - 8 Posts]

Inconsistent Behavior of SQL passed through ODBC connection. [Feb 2007 - 4 Posts]

Inconsistent behaviour of 'Coalesce' function in VB application [Nov 2003 - 6 Posts]

Inconsistent ODBC connection [Aug 2006 - 4 Posts]

Increasing Spool space for a User [Sep 2003 - 8 Posts]

Incremental backup in Teradata DW [Jan 2009 - 4 Posts]

Incremental backups [Mar 2007 - 4 Posts]

Incremental Benefit of Fallback [Jan 2003 - 4 Posts]

Incrementing field with an INSERT [Mar 2007 - 5 Posts]

Index Building [Dec 2007 - 5 Posts]

Index columns reversed in SHOW TABLE [Oct 2006 - 7 Posts]

Index help for filter columns [Sep 2008 - 5 Posts]

Index Mechanism? [Apr 2006 - 10 Posts]

Index size / space utilization [Jan 2006 - 4 Posts]

Indexes vs statistics [Jan 2004 - 7 Posts]

Indexing Intersection (association) tables [Jun 2009 - 2 Posts]

Indextypes Q, M, and K. [Jan 2007 - 6 Posts]

Indextypes Q, M, and K [Nov 2007 - 4 Posts]

INDICATORS FIELD in FastLoad Script [Nov 2002 - 9 Posts]

Info regarding teradata function [Feb 2008 - 2 Posts]

Info required for compatible data types [Aug 2008 - 2 Posts]

Informatica and Altered MLoad Control File Considerations [Aug 2003 - 5 Posts]

Informatica pushdown optimization [Oct 2006 - 4 Posts]

Informatica- FEXP Issue : FEXP_87016 : Received [Aug 2008 - 2 Posts]

Information about collect statistics already done for tables in particular Database [May 2007 - 2 Posts]

Information on COVER INDEX and query optimization... [Apr 2004 - 4 Posts]

INITIATE PARTITION ANALYSIS [Mar 2008 - 3 Posts]

Inmod and Mload VARTEXT [Dec 2002 - 6 Posts]

Inner Join on 1=1 [Feb 2004 - 8 Posts]

Inner Join Problems [Nov 2003 - 6 Posts]

Input data to fastexport [Oct 2003 - 4 Posts]

Inputs/Best Practices for migration from V2R2/R3 to V2R4 and higher versions [May 2002 - 4 Posts]

Insert count not match [May 2009 - 3 Posts]

Insert data into table [Feb 2002 - 20 Posts]

INSERT INTO big table [Oct 2001 - 12 Posts]

Insert into empty table with statistics [Jan 2005 - 10 Posts]

Insert select with sample [Oct 2001 - 7 Posts]

Insert values into a volatile table [Jun 2009 - 3 Posts]

Insert Values problem [Feb 2004 - 5 Posts]

INSERT/SELECT out of one table into two [Feb 2003 - 5 Posts]

Inserting a Timestamp value [Sep 2001 - 5 Posts]

Inserting Explains into a Table [May 2003 - 5 Posts]

Inserting in to Volatile table [Jul 2002 - 4 Posts]

Inserting Rows into tables with Secondary Indexes [Oct 2003 - 6 Posts]

Inserting Timestamps using Queryman [May 2003 - 8 Posts]

Inserts with Secondary Indexes [Sep 2000 - 4 Posts]

Installation of teradata Software [Apr 1999 - 4 Posts]

Installing Client Software Patches [Feb 2005 - One Post]

Installing on HP-UX Machine 11.11 running on HP [Sep 2008 - 2 Posts]

Insufficient memory to parse request error [Nov 2003 - 15 Posts]

Integer vs Character PI [Aug 2001 - 9 Posts]

Intelligent rounding off [Nov 2005 - 11 Posts]

Intercept the Teradata logon to run a script [Nov 2007 - 4 Posts]

Interesting Calculations If U spend time ! [Sep 2004 - 6 Posts]

Internal session blocking [May 2008 - One Post]

Internal session problem [Sep 2003 - 5 Posts]

Interpreting the ACCLOGRULETBL? [Oct 2004 - 4 Posts]

Interval in a where clause [Dec 2004 - 4 Posts]

INTERVAL math and error 7453 [Sep 2005 - 4 Posts]

Interval Overflow Error [Jan 2005 - 10 Posts]

Introduction, Issue, Debates, concerns. [Nov 2005 - 19 Posts]

Invalid operation on ANSI date time [Jan 2004 - 5 Posts]

Invalid views [Jan 2007 - 7 Posts]

Invitation to Next BPUG for Teradata Conference Call: Thursday July 26 - 2:00 CST [Jul 2001 - One Post]

IO, CPU and Memory usage for back up job [Feb 2009 - 2 Posts]

IPC on MPP [Apr 2007 - 5 Posts]

Is collect statistics ok along with read lock [Nov 2005 - 5 Posts]

Is compressing a column a design change? [Jul 2003 - 11 Posts]

Is it correct query? [Mar 2005 - 4 Posts]

Is it possible to call the option "change Password" of SQL Assistant from an API? [Sep 2004 - 6 Posts]

Is it possible to have Show/Help access to a table without having Select to the data? [Sep 2005 - 5 Posts]

Is it possible to manipulate activity count? [Jun 2004 - 6 Posts]

Is it possible to modify table? [Apr 2003 - 12 Posts]

Is Real-Time Data Loading Real? [Feb 2005 - 6 Posts]

Is Table being used by Stored Procedure or Macro [Apr 2006 - 4 Posts]

Is the Procedure running ? [Jan 2009 - 4 Posts]

Is there a DD view to check if a table is being loaded? Error 2652 [May 2005 - 6 Posts]

Is there an alternative to secondary Indexs. [Apr 2005 - 5 Posts]

Is there an equivalent of DUAL in Teradata [Jul 2004 - 23 Posts]

Is there any system column like the Oracle RowNum in Teradata? [Oct 2003 - 14 Posts]

Is there any way to find all tables which have two particular column in a database [Feb 2007 - 8 Posts]

Is this a BTEQ Limitation? [Jan 2006 - 6 Posts]

Is TRUNCATE available in teradata [Jul 2004 - 5 Posts]

Is your file system full? [Oct 2001 - 5 Posts]

IS_NUMBER [Sep 2003 - 6 Posts]

ISO DATE question [Jul 2003 - 5 Posts]

Issue in delete [Dec 2007 - 5 Posts]

Issue in opening Queryman [May 2006 - 12 Posts]

Issue while creating and inserting in teradata tables through java [Nov 2008 - 5 Posts]



Java connect problem [Feb 2003 - 6 Posts]

JCL sample code to move MLoad log file [Mar 2006 - 5 Posts]

JDBC - Resolving DNS alias -"InetAddress" caching [Jun 2008 - One Post]

JDBC and global temporary tables [Jul 2006 - 5 Posts]

JDBC and the number of records being returned [Jun 2007 - 4 Posts]

JDBC autoCommit(false) question [Sep 2008 - 8 Posts]

JDBC connection with Teradata [Oct 2006 - 5 Posts]

JDBC connectivity [Apr 2008 - 2 Posts]

JDBC driver and the use of the '?' [May 2009 - 6 Posts]

JDBC Gateway Connection Problem [Sep 2003 - 5 Posts]

JDBC Type 4 / URL string [Sep 2004 - 7 Posts]

JDBC Type 4 Driver [Jan 2003 - 4 Posts]

JDBC vs. OLE DB [Jan 2005 - 6 Posts]

Job scheduling on windows platform [Feb 2005 - 4 Posts]

Join behaving of a PI join [Jan 2008 - 2 Posts]

Join Index and Load performance [Feb 2005 - 4 Posts]

Join Index error [Jul 2006 - 10 Posts]

Join Index Question [Dec 2007 - 4 Posts]

Join index successes? [Apr 2003 - 6 Posts]

Join Index usage [Nov 2003 - 14 Posts]

Join Index with UNION stmt.. [Feb 2006 - 4 Posts]

Join Index [Apr 2003 - 5 Posts]

Join indices [Jun 1999 - 4 Posts]

Join Order In Teradata [Aug 2003 - 8 Posts]

Join with column faster than join with primary index column? [Mar 2008 - 4 Posts]

Joining Teradata and MS Access Tables [Mar 2006 - 5 Posts]

Joining to current month [Jul 2004 - 4 Posts]

Joins using varchar and char columns [Oct 2002 - 5 Posts]



Keeping source in sync with the warehouse [Apr 2004 - 4 Posts]

Kill a session and unlock a Table [Feb 2005 - 14 Posts]

Killing a rollback process [Apr 2001 - 5 Posts]

Killing queries [Aug 2003 - 4 Posts]

Killing table locks in multiload [Dec 2002 - 7 Posts]

Known issues with changing Teradata System [Jan 2008 - 2 Posts]



Large file size with perl and mload [Feb 2003 - 4 Posts]

Large varchar [Apr 2006 - 4 Posts]

Last Access Time of a Table [Aug 2006 - 4 Posts]

LAST row in an aggregate group [Jun 2009 - 5 Posts]

Lastupdate timestamp [Nov 2008 - 4 Posts]

Latest DDL's ..... [Feb 2006 - 13 Posts]

LEAD/LAG Analysis [Sep 2003 - 5 Posts]

Leading zero's in INTEGER column [Dec 2003 - 4 Posts]

Left join problem [Oct 2002 - 4 Posts]

Left Outer Join and Explain Plan [Jul 2003 - 6 Posts]

Left Outer Join on Partition (PPI) table [Apr 2004 - 7 Posts]

Left-over spool table found : transaction aborted [Dec 2004 - 4 Posts]

Left-over spool table found: transaction aborted [Apr 2006 - 6 Posts]

Length of Primary Index Columns [Aug 2008 - 2 Posts]

Length of timestamp [Nov 2006 - 13 Posts]

Lengthy aborts of simple SELECT statements [Oct 2004 - 3 Posts]

Less spoolspace and performance [Sep 2005 - 6 Posts]

Let me know how to incorporate dealy inside a procedure. [Oct 2005 - 10 Posts]

Like Function [Apr 2003 - 8 Posts]

Limit rows returned from a query [May 2002 - 7 Posts]

Limitations on RANK() function [Jan 2009 - 3 Posts]

Limited Select [Jan 2001 - 15 Posts]

Limiting the number of rows returned from Teradata SQL [Nov 2001 - 4 Posts]

Limits of CPU [Jun 2002 - 6 Posts]

Link Teradata tables in Access 2003 [Jan 2007 - 6 Posts]

Linked Server from SQL Server to Teradata [Jul 2002 - 5 Posts]

Linking to Teradata from MS Access [Jan 2006 - 4 Posts]

Linux and Teradata [Jun 2001 - 8 Posts]

LINUX Client [Jun 2008 - 3 Posts]

Linux ODBC setup [Nov 2007 - 6 Posts]

Linux vs MP-RAS 'gotchas' [Apr 2009 - 2 Posts]

Linux vs MPRAS [Jul 2006 - 5 Posts]

List all existing nodes [Oct 2005 - 13 Posts]

List of objects used by views [May 2003 - 6 Posts]

List of V2R6 Features [Sep 2007 - 5 Posts]

Load ASCII using TDAT Utility with HEX input data. [Sep 2004 - 4 Posts]

Load data from Oracle to Teradata in Linux [Jan 2009 - 6 Posts]

Loading a numeric with format like ZZZ.ZZZ.ZZZ,ZZ [Jan 2008 - 4 Posts]

Loading a PS file into Teradata [Oct 2005 - 4 Posts]

Loading a table from another table [Nov 2002 - 6 Posts]

Loading an XLS file [Aug 2005 - 9 Posts]

Loading Chinese Characters into the database [Jun 2006 - 13 Posts]

Loading data from Oracle to Teradata [Aug 2006 - 10 Posts]

Loading data from Oracle via SQL Assistant [Nov 2007 - 5 Posts]

Loading Fact data directly onto Teradata [Dec 2002 - 16 Posts]

Loading Large Objects (with the utilities?) [May 2008 - 2 Posts]

Loading Packed data to A Date column [May 2000 - 13 Posts]

loading rows from Excel/ access into teradata [Feb 2002 - 7 Posts]

LOB features in TD Demo [Jul 2006 - 5 Posts]

LOBs in Teradata. [Dec 2004 - 4 Posts]

Local Variables in Macro [May 2009 - 5 Posts]

Lock a user [Apr 2003 - 4 Posts]

LOCK ROW FOR WRITE in Bteq [Jun 2000 - 5 Posts]

Lock Statement causing Deadlocking [Mar 2005 - 7 Posts]

Lock woes [May 2003 - 5 Posts]

Locked Tables -Query [Apr 2003 - 4 Posts]

Locking a Database for READ only [Jun 2007 - 5 Posts]

Locking issue with views [Sep 2003 - 7 Posts]

Locking Log [Jul 2003 - 7 Posts]

Locking Row for Access Stmt [Jan 2008 - 8 Posts]

Locking/unlocking a table [Jun 2007 - 4 Posts]

Locks in fastload [Oct 2007 - 4 Posts]

Locks on table [May 2002 - 11 Posts]

Logical and physical rows [Oct 2006 - 4 Posts]

Logon file for the Fastload [Apr 2005 - 4 Posts]

LOGON Problem???? [Feb 2003 - 8 Posts]

Long Connection Times with newer ODBC driver? [Jan 2005 - 8 Posts]

Long Logon times via CLIv2 [Jul 2002 - 14 Posts]

Long running script / NUSI's [Aug 2001 - 4 Posts]

Long time to CREATE VOLATILE TABLE [May 2004 - 9 Posts]

Long-term Archive of user's data [Apr 2004