Home Page for the TeradataForum
 

 

Subject Index for 2005


 

The threads below were posted in the year 2005.


With over 33,000 posts, additional indexes have been provided to help navigate the Archives:


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

 
<< 2004 2006 >>
 
 
 

"NOT LIKE ANY" [Fri, 07 Jan - 14 Posts]



2616 numeric overflow while calculating huge numbers [Sun, 27 Mar - 3 Posts]

2644:NO MORE ROOM IN DATA BASE [Wed, 16 Nov - 3 Posts]

2666 error code: Date Format Error [Tue, 20 Sep - 2 Posts]



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

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



5142 cycl pack Error [Mon, 14 Nov - 3 Posts]



A new Perl interface to Teradata [Wed, 19 Oct - One Post]

A new UDF: 'stat_dt' [Mon, 21 Nov - One Post]

Ab Initio &amp; Mload/TPump system variables [Wed, 02 Mar - 2 Posts]

Abort RESPONDING sessions [Fri, 27 May - 5 Posts]

ABORTED SESSION TAKES TOO LONG TO ABORT [Wed, 14 Sep - 3 Posts]

About Release Lock [Mon, 18 Jul - 3 Posts]

Access all rows in DBC.Users [Wed, 31 Aug - 7 Posts]

Access module and Notify exit. [Mon, 11 Jul - One Post]

Access Rights : Privilege Codes [Tue, 04 Jan - 5 Posts]

Accessing Data across two servers [Wed, 28 Sep - 6 Posts]

Accessing data in 'Unknown' partition [Tue, 11 Jan - One Post]

Accountnames for Teradata installed UserIDs [Wed, 07 Sep - 7 Posts]

Activity Count in Stored Procedures? [Thu, 12 May - 4 Posts]

ActivityCount as an output [Wed, 02 Mar - 2 Posts]

Adding Nodes and Performance [Mon, 16 May - 3 Posts]

Additional XMS cells are in use [Fri, 07 Jan - 2 Posts]

Admin Comment: Changes to the TeradataForum [Fri, 26 Aug - 2 Posts]

Advantage to adding new COP entries? [Tue, 14 Jun - 5 Posts]

AIX 5.3 and TTU ? [Wed, 18 May - 3 Posts]

Re: Alert Policy and controlling access to dbcmngr.alertcontrol [Mon, 10 Jan - 2 Posts]

ALTER TABLE of a 400 million row table [Mon, 25 Jul - 2 Posts]

ALTER table to change column width [Wed, 07 Dec - 8 Posts]

AMP down and Multiload [Wed, 08 Jun - 3 Posts]

AMP Down [Wed, 25 May - 2 Posts]

Analytical function and datatype 'date' [Tue, 30 Aug - 6 Posts]

Another comment/question on SQL Assistant [Fri, 04 Feb - 4 Posts]

Answer: Fastload restart [Wed, 13 Jul - One Post]

Any experiences with Warehouse Builder [Tue, 06 Dec - One Post]

Any limits on IN LIST ? [Tue, 01 Feb - 3 Posts]

Any V2R6 Success or Horror Stories [Thu, 17 Mar - 4 Posts]

Anybody writing Embedded SQL programs for Windows [Wed, 23 Feb - One Post]

Anyone installed V2R6? [Thu, 06 Jan - One Post]

Anyone using Raid 5 [Wed, 26 Oct - 3 Posts]

Applying LEFT OUTER JOIN in the WHERE condition [Thu, 13 Jan - 4 Posts]

ARC on Network System [Thu, 01 Dec - 6 Posts]

Arcmain restart option [Mon, 25 Apr - 3 Posts]

ARCMAIN throughput - limiting factors [Fri, 04 Nov - 14 Posts]

Are my Primary Indexes being used? [Tue, 18 Jan - 7 Posts]

Assigning Default profile [Tue, 08 Nov - One Post]

Auto logoff user in teradata [Thu, 03 Feb - 2 Posts]

Automated PPI Maintenance [Fri, 23 Sep - 7 Posts]

AWS alerts and tivoli [Thu, 15 Sep - One Post]

AWS Alerts to Tivoli [Fri, 29 Jul - One Post]

AWS messages to Email/Pager [Wed, 06 Jul - 2 Posts]



Back to SQL School [Fri, 17 Jun - 3 Posts]

Backing up Structures (DDL) [Fri, 25 Feb - 8 Posts]

Backup and Recovery of Large Multi-Terabyte tables? [Wed, 27 Jul - 5 Posts]

Backup of Terabytes of data [Mon, 13 Jun - One Post]

Batch processing using BTEQ [Tue, 10 May - 2 Posts]

Batch userid to connect from unix only [Fri, 24 Jun - 5 Posts]

BEFORE trigger [Fri, 08 Apr - One Post]

Re: Best Approach to Recursive Queries without CONNECT BY [Wed, 05 Jan - 5 Posts]

Best practice for FreeSpacePercent (FSP) [Wed, 27 Apr - One Post]

Beta program: tdexport [Tue, 06 Sep - One Post]

Beta Test Invitation from Ward Analytics [Fri, 29 Jul - 5 Posts]

Biggest table in DB [Fri, 08 Apr - 4 Posts]

BTEQ - Macros inside transactions [Wed, 12 Oct - 6 Posts]

BTEQ - suppressing column headers [Mon, 21 Feb - 4 Posts]

BTEQ 8.2.2.2 [Thu, 31 Mar - 6 Posts]

BTEQ and comments anomaly [Wed, 10 Aug - 2 Posts]

BTEQ call to Stored Procedure [Wed, 06 Apr - 2 Posts]

BTEQ cast a POSITION [Wed, 30 Mar - 6 Posts]

Bteq export command and 2 garbage characters [Thu, 10 Nov - One Post]

BTEQ export to CSV file and large numbers [Tue, 09 Aug - 9 Posts]

BTEQ Export to Fastload in record mode is failing [Mon, 16 May - 4 Posts]

BTEQ export [Thu, 05 Aug - 7 Posts]

BTEQ Infile parm question [Fri, 28 Jan - 4 Posts]

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

BTEQ Log on Error [Thu, 13 Oct - 4 Posts]

BTEQ OS Command Failures [Wed, 19 Jan - 2 Posts]

BTEQ output and delimited text file [Thu, 15 Dec - 9 Posts]

BTEQ-LIMIT and Oracle ROWNUM [Tue, 05 Jul - 3 Posts]

Bugs with identity column [Fri, 14 Oct - 8 Posts]

Business Objects and JDBC [Wed, 26 Jan - 7 Posts]

Business Objects Designer and TDATA.DLL [Wed, 09 Mar - 5 Posts]



Calculate TIMESTAMP difference [Wed, 18 May - 4 Posts]

Calling a stored procedure from TPUMP [Fri, 20 May - 4 Posts]

Calling a stored Procedure from within an SP [Fri, 09 Sep - 4 Posts]

Calling an UDF in insert statement in MultiLoad [Fri, 29 Jul - One Post]

Can DBQL be used with Access Logging? [Thu, 07 Apr - 4 Posts]

Can I execute this update query ? [Thu, 31 Mar - 4 Posts]

Can you tell after-the-fact that a Rollback did take place ..? [Mon, 28 Feb - 2 Posts]

Cannot logon to Teradata demo system [Thu, 10 Nov - 8 Posts]

Capturing Updated Rows ! [Fri, 07 Jan - 3 Posts]

CAST DECIMALs [Thu, 24 Feb - 2 Posts]

Cast Function [Tue, 15 Nov - 2 Posts]

Cast problem : invalid date format [Wed, 07 Dec - 4 Posts]

Cast to Decimal - Error 2679 [Mon, 01 Aug - 4 Posts]

CEIL &amp; Least function in TD [Fri, 30 Dec - 3 Posts]

Change in Behavior of the Query [Tue, 06 Sep - 5 Posts]

Change the date format on the Teradata server [Tue, 15 Nov - 5 Posts]

Change the OWNER of a database [Tue, 08 Mar - 4 Posts]

Changing a default database within a macro [Thu, 17 Mar - 5 Posts]

Changing oracle code to teradata [Wed, 16 Feb - 4 Posts]

Changing table from set to multiset [Thu, 20 Oct - 3 Posts]

Channel vs Lan Attached systems [Wed, 19 Jan - One Post]

Character Set Problem Help .... [Mon, 09 May - 5 Posts]

Check Table and un-hashed tables [Thu, 16 Jun - 3 Posts]

Check Values is Numeric? [Wed, 07 Dec - 7 Posts]

Checking the last update made !! [Thu, 21 Apr - 4 Posts]

CHECKSUM question [Wed, 13 Jul - 2 Posts]

Checktable [Fri, 24 Jun - One Post]

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

CLI error 220 [Wed, 27 Apr - 5 Posts]

CLI with Microsoft .NET [Tue, 01 Mar - 5 Posts]

Client connection to Teradata Demo server [Wed, 20 Jul - 2 Posts]

Client Request Load Balancing [Fri, 09 Sep - 6 Posts]

CNT - channel extension and arcmain [Wed, 14 Sep - One Post]

COALESCE or CASE ? [Tue, 19 Jul - 9 Posts]

Coexistence and disk families [Mon, 05 Dec - 4 Posts]

Cognos and Password changes [Thu, 08 Sep - 2 Posts]

Cold Fusion and Teradata [Fri, 18 Nov - 4 Posts]

Collect stats and DBC.indexes.IndexStatistics [Wed, 18 May - 3 Posts]

Collect Stats in a Procedure [Mon, 01 Aug - 11 Posts]

Column Data Encryption? [Wed, 16 Feb - 6 Posts]

Combining Business Data with Performance Data? [Fri, 18 Mar - 3 Posts]

Comma in string [Tue, 28 Jun - 10 Posts]

Comments in ARC Utility [Tue, 11 Jan - 6 Posts]

Commit Statements [Fri, 23 Dec - One Post]

Compare rows of tableA to rows of tableB - HOW? [Fri, 16 Sep - 10 Posts]

Compare teradata with other databases [Fri, 16 Sep - 5 Posts]

Compiling Teradata Stored Procedures [Tue, 29 Mar - 3 Posts]

Complex View causes EVL Stack Overflow [Fri, 09 Sep - One Post]

COMPRESSing spaces [Fri, 20 May - 4 Posts]

Compression and join indexes [Mon, 13 Jun - 10 Posts]

Concurrent MultiLoads and the same target [Tue, 05 Apr - 2 Posts]

Conditional macro execution [Wed, 05 Jan - 5 Posts]

Configuring ODBC driver on IBM AIX. [Wed, 19 Oct - 2 Posts]

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

Connection Error: 11004 WSA E No_Data [Thu, 17 Feb - 4 Posts]

Connection Time Out [Mon, 18 Jul - 2 Posts]

Connectivity To Node [Thu, 24 Mar - 3 Posts]

Consistency in resource usage for an SQL [Sat, 05 Feb - 2 Posts]

Constraints and indexes [Thu, 17 Mar - 4 Posts]

Continual loading with TPump [Thu, 29 Sep - One Post]

Controlling user access to data [Tue, 22 Nov - One Post]

Convert Decimal into Varchar without a trailing dot [Thu, 03 Nov - 5 Posts]

Convert hex number to int? [Wed, 30 Mar - 9 Posts]

Copying Dictionary Tables using Arcmain [Tue, 19 Apr - 3 Posts]

Copying Stats Definition [Tue, 20 Dec - 3 Posts]

Correlating Multiple Views and Join Views to Base Tables [Tue, 02 Aug - 4 Posts]

Count distinct set of rows [Tue, 07 Jun - 4 Posts]

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

CREATE FUNCTION - BTEQ ISSUE [Wed, 14 Sep - 3 Posts]

Create set table: problem [Sun, 24 Jul - 2 Posts]

CreateTimeStamp and CreateID columns in v2r2 [Tue, 20 Dec - One Post]

Creating a Named Pipe in FastExport [Fri, 24 Jun - 2 Posts]

Creating Multiset tables using ERwin - Revisited [Thu, 03 Nov - 6 Posts]

Creating PPI table [Sun, 03 Jul - 3 Posts]

CRLFs in DBC.TABLES.REQUESTTEXT [Tue, 03 May - 4 Posts]

CRM Screen refresh/focus question [Thu, 26 May - One Post]

Crystal Reports and ODBC [Thu, 28 Jul - 4 Posts]

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

Current Spool ( PMON ) showing a negative Value. [Mon, 02 May - 2 Posts]

Customizing Arcmain [Tue, 13 Sep - 3 Posts]

Cylinder reads [Tue, 12 Jul - One Post]



Re: Data Generation tools/Data encryption [Thu, 04 Feb - 3 Posts]

Data Load Error WRT_8114 [Mon, 12 Sep - 8 Posts]

Data Load Problem with embedded hex '00' [Thu, 22 Dec - 3 Posts]

Data modeling consideration [Thu, 18 Aug - 3 Posts]

Database Name in Teradata [Mon, 21 Mar - 7 Posts]

Database spool space [Wed, 16 Nov - 2 Posts]

Datablocksize and Freespace [Fri, 16 Sep - 4 Posts]

Date Fomat Problem in Macro between V2R5 and [Tue, 18 Oct - 10 Posts]

Date Format Changed [Tue, 15 Feb - 2 Posts]

DATE Format of INPUT Parameter for STORED PROCEDURE [Mon, 31 Jan - 6 Posts]

Day-light saving functions [Tue, 12 Apr - One Post]

DAYOFWEEK Function and BTEQ [Sun, 14 Aug - 6 Posts]

DBA Guru! [Tue, 04 Jan - 4 Posts]

DBC Access for Table Delete? [Wed, 16 Feb - 2 Posts]

DBC Space management [Fri, 24 Jun - 3 Posts]

DBC.AMPUSAGE and request CPU totals [Wed, 25 May - 2 Posts]

DBC.INDEXES and Index Types [Wed, 02 Mar - 5 Posts]

DBQL Skips Logging SQL When Busy? [Thu, 10 Nov - 5 Posts]

Dbscontrol - Cylinder Saved for Perm [Mon, 20 Jun - 3 Posts]

Deadlocking between ARC and SQL? [Tue, 30 Aug - One Post]

Deadlocking [Fri, 04 Mar - 4 Posts]

Deciles Query [Tue, 22 Mar - 4 Posts]

Default charset in volatile tables [Mon, 21 Feb - 5 Posts]

Default Data Format [Tue, 17 May - 2 Posts]

DefaultCharType problem [Thu, 21 Apr - 3 Posts]

Defining key columns on view [Fri, 01 Jul - 2 Posts]

Defragment of cylinder[s] and mini-cylinder packs [Fri, 24 Jun - One Post]

DELETE DATABASE Command [Fri, 02 Dec - 2 Posts]

Deleting Duplicate rows [Wed, 17 Aug - 15 Posts]

Deleting the partial rows [Fri, 18 Feb - 6 Posts]

Delimiter in FastExport text file [Wed, 30 Nov - 2 Posts]

Denormalized Data Structures [Thu, 03 Mar - 5 Posts]

Design Considerations for FS-LDM/3NF model [Sat, 24 Sep - 7 Posts]

Diagnostic Lookahead [Tue, 15 Nov - 3 Posts]

Difference between allocation and performance group [Tue, 21 Jun - 2 Posts]

Difference between Backup tools [Tue, 13 Sep - 7 Posts]

Difference between Defrag and Packdisk [Wed, 30 Nov - 3 Posts]

Difference between Delete and delete All syntax [Wed, 14 Sep - 11 Posts]

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

Different Data Types and Performance [Fri, 26 Aug - 3 Posts]

Different Explains for the same query [Wed, 02 Feb - 8 Posts]

Dirty Reads... Done Dirt Cheap [Fri, 24 Jun - 5 Posts]

Discrepancies between ITEQ and BTEQ [Tue, 11 Jan - 2 Posts]

Disk &amp; Memory Events trap [Thu, 27 Oct - One Post]

Distance based on latitude and longitude [Thu, 26 May - 22 Posts]

Distinguish chracters from intergers [Thu, 10 Mar - 9 Posts]

Distribution of spool files: Based on PI or NUSI [Tue, 25 Jan - 2 Posts]

Docs/pointers to TD architecture [Fri, 18 Mar - 4 Posts]

Does Teradata database 5.1 support internationalization [Wed, 15 Jun - 4 Posts]

DOS FastLoad and CLI315's [Thu, 20 Jan - 15 Posts]

Drop partition with CASE_N [Tue, 04 Jan - 4 Posts]

Drop Stats before loading data ? [Thu, 08 Dec - 4 Posts]

Drop table with RI constraints [Fri, 07 Jan - 2 Posts]

Dropping a join index [Wed, 29 Jun - 3 Posts]

Dropping double quotes from VARCHAR cols [Tue, 29 Nov - 4 Posts]

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

Dynamic cursors in procedure [Mon, 27 Jun - 2 Posts]

Dynamic Query [Thu, 27 Jan - 2 Posts]



Effect of ORDER BY in performance [Tue, 04 Jan - 4 Posts]

Embedded SQL Preprocessor on Linux available ? [Wed, 27 Jul - One Post]

Environment Variables: Teradata-to-DB2 II [Wed, 08 Jun - 4 Posts]

Epoch function [Wed, 09 Feb - 6 Posts]

Equivalent of DB2's BIGINT in Teradata [Mon, 10 Oct - 9 Posts]

Error 2644 - No more room in database [Mon, 16 May - 3 Posts]

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

Error 3695 in Fast Export - A Single AMP Select [Thu, 26 May - 4 Posts]

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

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

Error 8006 while creating UDF [Wed, 13 Apr - 5 Posts]

Error : 3712 Insufficient memory for Plastic Steps [Tue, 06 Sep - 2 Posts]

Error :3518 Too many column in composite Index [Tue, 26 Jul - 6 Posts]

Error code -1 when executing replace procedure statement [Mon, 08 Aug - 6 Posts]

Error handling in BTEQ ??? [Thu, 10 Nov - 6 Posts]

Error handling in Procedure [Tue, 11 Oct - 2 Posts]

Error linking Embedded SQL C Windows program [Mon, 21 Feb - One Post]

Error trapping a deadlock inside Bteq? [Thu, 29 Sep - 5 Posts]

Error while importing a file in bteq [Wed, 25 May - 4 Posts]

ERWIN postscripts and Teradata [Wed, 30 Nov - 4 Posts]

Essbase and Teradata. [Tue, 20 Sep - 9 Posts]

Essbase Loads to Teradata [Tue, 19 Apr - One Post]

Example Of Abort/Rollback [Thu, 23 Jun - One Post]

Exception handler [Wed, 17 Aug - 4 Posts]

Exception occur at create table [Tue, 29 Mar - 3 Posts]

Excessive Delays between DBQLogTbl's StartTime and FirstStepTime [Tue, 08 Nov - 12 Posts]

Execute a macro with multiple criteria [Fri, 08 Jul - 3 Posts]

Executing queries in parallel [Fri, 23 Sep - 6 Posts]

Exit From Stored Procedure [Mon, 28 Nov - 3 Posts]

Expecting Suggestions for Teradata Upgarde V2R5.0 [Thu, 08 Sep - 4 Posts]

Experiences with ETL Tools [Mon, 08 Aug - 4 Posts]

Experiences with Teradata V2R6 [Tue, 06 Dec - 2 Posts]

Explain Analysis [Fri, 12 Aug - 3 Posts]

EXPLAIN in Macro? [Tue, 22 Mar - 2 Posts]

EXPLAIN rights [Thu, 01 Dec - 33 Posts]

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

Export Append problem? [Thu, 13 Jan - 3 Posts]

Export data to flat file using bteq [Fri, 15 Apr - 2 Posts]

Export to a text file using OLE-DB [Mon, 28 Nov - 9 Posts]

Exporting &amp; Importing Dates in SQL Assistant [Wed, 04 May - 3 Posts]

ExtendedFetch with MicroStrategy [Wed, 17 Aug - One Post]

External Authentication [Tue, 19 Apr - 6 Posts]

Extracting names from a CLOB column [Sun, 06 Mar - 2 Posts]

Extracting piece of data from a string of text [Fri, 08 Apr - 4 Posts]



Factorial in Teradata [Thu, 15 Sep - 7 Posts]

Failover while preserving sessions [Mon, 19 Sep - One Post]

Failure 5708 Table header size exceeds limit [Thu, 05 May - 9 Posts]

Fast Export and &SYSRC [Thu, 24 Feb - 2 Posts]

Fast load Script is getting paused [Fri, 27 May - 4 Posts]

Fast loading a variable length dataset [Thu, 27 Jan - 4 Posts]

Fast Path Insert not possible with Begin Transaction???? [Thu, 07 Jul - One Post]

fast-export vertical &amp; horizontal data distribution [Mon, 14 Mar - 3 Posts]

FastExport and the number of sessions vs. skewing [Tue, 27 Dec - 5 Posts]

FastExport Error (UTY8737) and Rejected Records [Wed, 09 Feb - One Post]

FastExport Inmod [Thu, 20 Oct - 2 Posts]

FastExport performance vs. Fastload [Fri, 04 Mar - 7 Posts]

FastExport Performance [Fri, 27 May - 2 Posts]

FastExport to a named pipe [Mon, 18 Jul - 4 Posts]

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

FastExport [Wed, 12 Jan - One Post]

Fastload (pc .txt file) [Thu, 08 Dec - 6 Posts]

FastLoad Date Format [Thu, 07 Apr - One Post]

Fastload FORMAT [Sun, 17 Jul - 4 Posts]

Fastload getting aborted due to data problems [Fri, 20 May - One Post]

Fastload in Unix [Fri, 18 Nov - 6 Posts]

Fastload Problem: No room in database [Wed, 25 May - 21 Posts]

FASTLOAD Q: Check points [Wed, 29 Jun - 3 Posts]

Fastload syntax errors: 3808 [Fri, 10 Jun - 5 Posts]

FastLoad VS MLoad [Mon, 17 Jan - 5 Posts]

Fastloading delimited file [Fri, 15 Apr - 4 Posts]

Fetch Time from DBQL [Tue, 05 Apr - 8 Posts]

Filtering the Junk values from a field [Fri, 08 Jul - 4 Posts]

Find all partitions in a table [Wed, 06 Jul - 2 Posts]

Finding History of Blocked Sessions [Wed, 19 Oct - 2 Posts]

Finding previous record puzzle [Tue, 22 Feb - 6 Posts]

Finding revoked logons [Thu, 08 Sep - 3 Posts]

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

Fixed width files from FastExport [Thu, 11 Aug - 8 Posts]

Fload problem: a discrepency between read and expected [Tue, 22 Mar - 4 Posts]

Flushing Residual Spool From Amps [Tue, 06 Sep - 3 Posts]

Format function [Tue, 05 Apr - 4 Posts]

FORMAT Issue with FLOAT datatype? [Tue, 12 Jul - 5 Posts]

FreeSpace Percent [Sat, 04 Jun - One Post]

Function equivalent to ReplaceChar [Fri, 16 Sep - One Post]

Fw: ResUsage info..need help analysing [Wed, 03 Aug - 2 Posts]



Generating Oracle's chr(10) [Wed, 17 Aug - 5 Posts]

Generating the Header and Trailer in the Data File [Fri, 13 May - 4 Posts]

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

Getting a complete list of users from dbc.users [Thu, 17 Nov - 7 Posts]

Getting comma separated list out of table records [Mon, 17 Oct - 3 Posts]

Getting row count at run time [Thu, 30 Jun - 3 Posts]

Global Temporary Tables (GTT) and Statistics [Mon, 12 Dec - 5 Posts]

GMT to CST conversion. [Thu, 14 Apr - 3 Posts]

Good practice programming in TD [Fri, 05 Aug - 3 Posts]

Grant option in DB [Sat, 04 Jun - 2 Posts]

GRANT role ON object WITH GRANT OPTION not allowed [Tue, 26 Jul - 3 Posts]

Group by on one column but select multiple columns [Mon, 23 May - 4 Posts]

Group by vs distinct, optimizer confidence and estimates [Mon, 17 Jan - One Post]

Guidelines for Teradata Upgrade [Thu, 03 Mar - 2 Posts]

Guidelines for using Distinct vs. group by [Fri, 11 Feb - 12 Posts]

Guidelines for using IN vs. EXISTS [Tue, 15 Feb - 2 Posts]



Handling common SQL blocks in a Stored Proc [Tue, 29 Mar - 2 Posts]

Has any had success with views that UNION Tables [Mon, 11 Apr - 6 Posts]

Hash Indexes [Wed, 01 Jun - 2 Posts]

Help need on Tricky SQL [Thu, 11 Aug - 8 Posts]

Help needed with Triggers [Fri, 07 Oct - 2 Posts]

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

Help required with Mload! [Fri, 30 Dec - 5 Posts]

Help View [Mon, 17 Jan - 3 Posts]

Help with bteq script to load a table [Thu, 10 Feb - 5 Posts]

Here is my frustration of the day from MLOAD [Mon, 26 Sep - 2 Posts]

Hidden Steps in explain... [Thu, 03 Feb - 2 Posts]

Hierarchical queries [Mon, 04 Apr - 2 Posts]

High CPU and low I/O [Thu, 28 Jul - 3 Posts]

Historic Free Cylinders per vproc? [Wed, 19 Jan - One Post]

History of database access [Tue, 15 Mar - 4 Posts]

History treatment Using Upsert Logic [Wed, 19 Oct - 3 Posts]

Holes in Roles? [Mon, 04 Apr - 3 Posts]

HOLOS and V2R5 Upgrade. [Wed, 12 Jan - 4 Posts]

How to Concatenate Column Values using SQL/Macros [Thu, 04 Aug - 5 Posts]

How are stored procedures stored on AMPs. [Mon, 11 Apr - 3 Posts]

How can I enable production statistics on test system? [Wed, 30 Mar - 3 Posts]

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

How confident is "High Confidence" [Tue, 11 Jan - One Post]

How create XML file with SQL? [Thu, 20 Oct - 2 Posts]

How do I use the NOT CS clause in the IN CLAUSE ? [Mon, 22 Aug - 2 Posts]

How sample works? [Thu, 08 Dec - 2 Posts]

How to add a new AMP or VPROC ??? [Tue, 29 Nov - One Post]

How to avoid Deadlock? [Tue, 24 May - 2 Posts]

How to change de Creator Name of a table [Thu, 06 Jan - 4 Posts]

How to convert oracle pl/sql to teradata code [Tue, 06 Sep - 2 Posts]

How to Convert Records into Columns [Fri, 09 Dec - 4 Posts]

How to delete selectively [Wed, 29 Jun - 7 Posts]

How to find the length of a Decimal field in [Thu, 01 Dec - 2 Posts]

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

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

How to handle partition maintenance [Fri, 20 May - 3 Posts]

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

How to insert a JPEG or BMP file in Teradata database table [Mon, 10 Jan - 3 Posts]

How to kill a session [Tue, 18 Oct - One Post]

How to kill the locked session in teradata [Wed, 29 Jun - 2 Posts]

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

How to leave an intentional lock for testing [Tue, 29 Nov - 15 Posts]

How to read data using CLI [Fri, 16 Sep - One Post]

How To restrict the number of rows returned by a user's queries [Fri, 24 Jun - One Post]

How to rollback the insert statement in Teradata [Fri, 01 Jul - 2 Posts]

How to simulate built in function RPAD of Oracle in Teradata [Tue, 05 Apr - 5 Posts]

How to stop Roll Back with out making table Invalid. [Mon, 22 Aug - 4 Posts]

How to Substring data [Sun, 14 Aug - 3 Posts]

How to use "Client System Variables" in BTEQ? [Mon, 18 Apr - 2 Posts]

How to use a string in TWB script. [Wed, 16 Feb - 2 Posts]

HP-UX : lf_axsmod.so [Mon, 21 Nov - 3 Posts]



Identify Referenced columns [Wed, 19 Oct - One Post]

Identifying Candidate Columns for Statistics [Tue, 12 Apr - 2 Posts]

Impact of Huge Access Rights Table [Mon, 15 Aug - 3 Posts]

IN list improvement for V2R6 [Tue, 22 Nov - 3 Posts]

Incremental Backup [Mon, 12 Sep - 2 Posts]

Index Type [Fri, 09 Dec - 3 Posts]

Indexes and column order - does it make a difference? [Fri, 01 Jul - 2 Posts]

Information about Event_Tag (DBC.Sw/Hw_event_log) [Mon, 11 Jul - 3 Posts]

Inheritance of role rights [Wed, 09 Nov - 2 Posts]

Inrange 9800 channel extender ? [Wed, 30 Nov - One Post]

Insert into empty table with statistics [Thu, 20 Jan - 10 Posts]

Installation Steps for v2r5.1 DB needed. [Thu, 15 Sep - 2 Posts]

Installing Client Software Patches [Thu, 10 Feb - One Post]

Installing MetaDataService [Wed, 20 Apr - One Post]

Intelligent rounding off [Thu, 17 Nov - 11 Posts]

Internal Error when adding / dropping ranges from [Fri, 23 Dec - One Post]

Internal Format of MLOAD/FEXP data files [Wed, 06 Jul - 3 Posts]

Internal Row Size [Wed, 06 Apr - 2 Posts]

INTERVAL math and error 7453 [Mon, 05 Sep - 4 Posts]

Interval Overflow Error [Mon, 10 Jan - 10 Posts]

Introduction, Issue, Debates, concerns. [Thu, 03 Nov - 19 Posts]

Invalid precision: cbColDef value out of range [Thu, 23 Jun - One Post]

Is blocking of request expensive [Wed, 13 Jul - 2 Posts]

Is collect statistics ok along with read lock [Wed, 16 Nov - 5 Posts]

Is FLOAT data type the right choice [Mon, 31 Oct - 2 Posts]

Is it correct query? [Mon, 14 Mar - 4 Posts]

Is it possible to have Show/Help access to a table without having Select to the data? [Thu, 29 Sep - 5 Posts]

Is it possible to run two instance of Teradata [Thu, 29 Sep - One Post]

Is Real-Time Data Loading Real? [Wed, 02 Feb - 6 Posts]

Is the Workload Information in TASM available in a Table in Teradata? [Mon, 12 Sep - One Post]

Is there a DD view to check if a table is being loaded? Error 2652 [Mon, 16 May - 6 Posts]

Is there an alternative to secondary Indexs. [Mon, 18 Apr - 5 Posts]

Is USI useful for avoiding NUPI row check [Wed, 24 Aug - 3 Posts]

ISSUE - FAST LOAD IN MVS [Wed, 14 Dec - 2 Posts]

Issue in Space Release [Tue, 28 Jun - 3 Posts]



J2EE - iBATIS or ORM [Mon, 14 Feb - One Post]

Java - Teradata updates [Tue, 22 Mar - 2 Posts]

JDBC and Idle Response [Tue, 29 Nov - 3 Posts]

JDBC exception for double byte characters [Wed, 19 Oct - 2 Posts]

JDBC Exception need help!!! [Wed, 27 Apr - 3 Posts]

JDBC vs. OLE DB [Fri, 14 Jan - 6 Posts]

Job scheduling on windows platform [Mon, 07 Feb - 4 Posts]

Join Index and Load performance [Tue, 15 Feb - 4 Posts]

Join Index and SelfJoin [Mon, 25 Jul - 2 Posts]

Join Index Postscript for Erwin [Fri, 18 Nov - One Post]

Journalling Option [Thu, 29 Sep - 3 Posts]



Keeping and re-using Tpump generated macros [Fri, 06 May - 3 Posts]

Key Tables and Primary Indexes [Wed, 16 Mar - 2 Posts]

Kill a session and unlock a Table [Thu, 24 Feb - 14 Posts]



Less spoolspace and performance [Mon, 05 Sep - 6 Posts]

Let me know how to incorporate dealy inside a procedure. [Wed, 19 Oct - 10 Posts]

Linked Server Using OLEDB [Thu, 13 Jan - One Post]

Liquid Office Usage??? [Tue, 28 Jun - 2 Posts]

List all existing nodes [Wed, 26 Oct - 13 Posts]

Load order of Fast Load Utility [Wed, 17 Aug - 2 Posts]

Loading a PS file into Teradata [Fri, 14 Oct - 4 Posts]

Loading an XLS file [Fri, 19 Aug - 9 Posts]

Loading xml file [Thu, 19 May - 2 Posts]

Lock Statement causing Deadlocking [Wed, 09 Mar - 7 Posts]

Logic in a Tpump DML [Tue, 03 May - 2 Posts]

Logon file for the Fastload [Fri, 15 Apr - 4 Posts]

Logon Security and generic passwords [Thu, 24 Feb - One Post]

Long Connection Times with newer ODBC driver? [Mon, 31 Jan - 8 Posts]



Macros with Cognos and Teradata? [Mon, 28 Feb - 2 Posts]

MACROS with Stored Procedures [Wed, 21 Dec - One Post]

Maintaining Partitions Dynamically [Tue, 31 May - 3 Posts]

Managing the Teradata Manager Server [Fri, 30 Dec - 4 Posts]

Mandated Password Complexity within Teradata? [Tue, 16 Feb - 3 Posts]

Masking identification numbers [Mon, 25 Apr - 6 Posts]

Mass update &amp; dummy tpump job [Wed, 10 Aug - 4 Posts]

Max data file size for load utilities [Tue, 06 Sep - 5 Posts]

Max values in 'IN' clause [Fri, 09 Dec - 2 Posts]

Maximum columns allowd in primary index and foreign key constraints in V2R5 [Thu, 13 Jan - 2 Posts]

Maximum length on bteq export in report mode? [Mon, 21 Mar - 3 Posts]

Maximum Limits of Users in Warehouse [Fri, 28 Jan - 33 Posts]

MaxParseTreeSegs &amp; OptMaxGlobalJI [Tue, 03 May - One Post]

MDS superuser [Wed, 05 Jan - 2 Posts]

MDS Web Services [Thu, 24 Feb - One Post]

Re: MERGE INTO [Wed, 10 Aug - 2 Posts]

Migrating from IBM MVS to Linux [Mon, 25 Apr - 4 Posts]

Migrating Oracle date fields in Teradata [Wed, 16 Mar - 3 Posts]

Migrating to a Unicode compliant database [Wed, 02 Mar - 3 Posts]

Mini Cylpack [Mon, 19 Dec - 3 Posts]

Missing Character in Long View Definition [Fri, 18 Feb - 2 Posts]

MLoad &amp; Removing Binary Zeros [Mon, 15 Mar - 5 Posts]

MLOAD CLI 311 Error [Wed, 23 Nov - One Post]

Mload date calculation [Wed, 14 Dec - 2 Posts]

MLoad error - UTY0805 RDBMS failure, 3857: Cannot use value [Tue, 09 Aug - One Post]

MLoad Error UTY0676: Invalid Data Entry Block [Wed, 04 May - 2 Posts]

Mload Fixed Length and bad records [Wed, 07 Dec - 8 Posts]

MLoad performance question [Tue, 29 Nov - 4 Posts]

Mload statistics [Mon, 31 Oct - 2 Posts]

Mload thinks these are duplicates [Tue, 22 Mar - 3 Posts]

MOd function in view [Thu, 17 Feb - 4 Posts]

Modification history of table [Wed, 09 Nov - 2 Posts]

Modular Programming [Thu, 29 Sep - 4 Posts]

Monitor Rates Settings [Mon, 04 Jul - 2 Posts]

Monitoring Deadlocks [Wed, 16 Feb - One Post]

Monitoring mload progress in application phase [Mon, 06 Jun - 2 Posts]

Monitoring Priority Scheduler using Heart-beat queries in every Performance Group [Mon, 20 Jun - 3 Posts]

Moving huge data from UDB to Teradata [Tue, 07 Jun - 6 Posts]

Moving object between systems by using Teradata Administrator(WINDDI) [Wed, 09 Feb - 9 Posts]

MS Access to Teradata 5.1.1 with ODBC 3.03.00.04 [Thu, 13 Jan - 3 Posts]

Multi Column Statistics Puzzle [Wed, 09 Mar - 4 Posts]

Multi-type Partitioning [Wed, 14 Dec - 4 Posts]

Multi-Value compression of a Sec-Idx and ipact on Multi-Load [Thu, 18 Aug - 5 Posts]

Multiload -- Logon Failed error [Mon, 31 Oct - 5 Posts]

MultiLoad Client Basic Questions [Wed, 12 Jan - 2 Posts]

Multiload error messages reference [Thu, 10 Nov - One Post]

MultiLoad from Informatica [Thu, 27 Oct - 4 Posts]

MultiLoad performance vs NUPI [Fri, 29 Apr - 5 Posts]

MultiLoad Port? [Tue, 26 Apr - 2 Posts]

MultiLoad With VARTEXT/Delimited Input File [Thu, 17 Feb - 6 Posts]

Multiple TTU versions on One Box [Thu, 27 Jan - 3 Posts]

MULTISET Tables [Tue, 29 Nov - 6 Posts]

Mutlload Timestamp field from date [Fri, 29 Jul - 2 Posts]

MVS TDP0 connection failure - capturing in a JCL [Thu, 10 Feb - 2 Posts]

MVS utility configuration file [Thu, 22 Dec - 7 Posts]



Naming standards for Roles [Fri, 21 Jan - 3 Posts]

NCR Put throws an error looking for FD_PDE.txt [Thu, 29 Sep - One Post]

Need a program to test Unix ODBC install for Teradata [Tue, 10 May - 7 Posts]

Need help in accessing SQL Server table from Teradata [Tue, 02 Aug - 4 Posts]

Need help on MULTITOOL [Mon, 29 Aug - 4 Posts]

Need to remove blank spaces from data [Wed, 13 Jul - 5 Posts]

Nested summary tables [Mon, 25 Jul - One Post]

Newline indicators [Wed, 14 Sep - 5 Posts]

Nodename for cop entries [Mon, 18 Apr - 3 Posts]

NoDerivedStats [Tue, 13 Dec - 2 Posts]

Non-TPA Nodes Value and Experiences [Fri, 07 Jan - 5 Posts]

Null values in a select [Wed, 16 Feb - 12 Posts]

NULLS LAST and NULLS FIRST [Fri, 29 Jul - 4 Posts]

NULLS to Spaces [Mon, 19 Dec - 6 Posts]

NUSI Access Performance Issues [Thu, 13 Oct - 5 Posts]



Objectname as a parameter to macro [Tue, 06 Dec - 3 Posts]

Obtaining the Thread Id of an Active Session [Thu, 08 Sep - 4 Posts]

ODBC 3.04.00.00 and MS Access [Wed, 03 Aug - 6 Posts]

ODBC Driver 3.04 VERY slow data retrieval [Mon, 18 Jul - 5 Posts]

ODBC Driver directories [Mon, 23 May - 3 Posts]

ODBC entry question.... [Mon, 14 Nov - 4 Posts]

ODBC HYT00 Login Timeout Expired message [Fri, 15 Apr - 3 Posts]

OK What Gives??? [Tue, 01 Nov - 3 Posts]

OLAP functions "assume to redistribute" ?!? [Mon, 04 Apr - 3 Posts]

Ole load automation [Thu, 02 Jun - 7 Posts]

Open SSH anyone have it installed on MP-RAS ? [Fri, 21 Jan - 2 Posts]

Operating system of Remote Login Teradata Database [Tue, 13 Sep - 10 Posts]

Optimal PI [Tue, 23 Feb - 5 Posts]

Optimizer and bind variables [Mon, 11 Jul - One Post]

Optimizer and Transitive Property of Equality [Thu, 04 Aug - 10 Posts]

Options Parcel information is invalid. [Tue, 19 Apr - 3 Posts]

ORACLE 10G VS TD V2R5.1 [Thu, 07 Apr - One Post]

Oracle Date [Wed, 17 Aug - 3 Posts]

Oracle to Teradata migration [Wed, 03 Aug - 6 Posts]

Order by clause [Thu, 06 Jan - 5 Posts]

Order of columns with in index or stats [Mon, 26 Sep - 2 Posts]

OS support for different Teradata Database [Tue, 12 Apr - 2 Posts]

Out of spool and OLAP functions [Tue, 22 Nov - 6 Posts]

Outer Join Syntax [Wed, 06 Apr - 2 Posts]

OVERLAP function and Stored Procedure [Wed, 27 Apr - One Post]



Packdisk and Defrag [Thu, 05 May - 3 Posts]

Packdisk automation [Wed, 16 Nov - 9 Posts]

Parsing DBC.Table's RequesText [Tue, 13 Dec - 10 Posts]

Partition elimination using Date function [Thu, 09 Jun - 5 Posts]

Partition elimination [Fri, 18 Mar - One Post]

Partition Index Question... [Mon, 12 Dec - 2 Posts]

Partitioned Primary Indices - Is there a way to see [Mon, 26 Sep - 4 Posts]

Partitioning and Indexing Suggestions... [Wed, 13 Apr - One Post]

Partitioning in Teradata [Tue, 22 Mar - 2 Posts]

Partitions and indexes [Wed, 06 Jul - 4 Posts]

Partners Enhancement request [Thu, 17 Nov - One Post]

Passing the value for an IN clause to a stored [Wed, 21 Dec - 5 Posts]

Password change for first time users [Tue, 25 Jan - 4 Posts]

PasswordMinChar in syssecdefaults [Wed, 08 Jun - 4 Posts]

Pattern Matching Operator [Mon, 19 Sep - 5 Posts]

PDE not accessible: Cannot access node global [Sat, 19 Nov - 2 Posts]

Perl DBD and encrypted logins... [Wed, 12 Oct - 6 Posts]

Perl odbc connections are slow [Tue, 31 May - One Post]

Perl with DBD::ODBC or DBD::Teradata. [Mon, 25 Jan - One Post]

Permissions to DBC.Databases / DBC.Tables [Wed, 17 Aug - 6 Posts]

PI columns - location. [Mon, 10 Jan - One Post]

PI Review Query - Crosstab with Perm, Skew, RowCounts, [Thu, 07 Apr - One Post]

Pictures and SQL Assistant [Mon, 10 Jan - One Post]

Plan and execution traces [Fri, 05 Aug - 2 Posts]

PMON and Node utilization on an idle machine [Thu, 09 Jun - 4 Posts]

PMON Overhead [Fri, 05 Aug - 8 Posts]

Powerdesigner V.11 [Fri, 17 Jun - 3 Posts]

PPI Number of Columns [Thu, 10 Feb - 5 Posts]

PPI Partition Order [Mon, 28 Mar - One Post]

PPI table - empty partitions. [Thu, 02 Jun - 11 Posts]

PPI vs Collect Stats [Fri, 28 Jan - One Post]

Preserving table statistics across table DDL [Wed, 12 Oct - 5 Posts]

Preventing TJ [Sun, 17 Jul - 7 Posts]

Primary Index selection on new tables [Fri, 08 Jul - 3 Posts]

Primary Index vs Single Condition [Thu, 11 Aug - 4 Posts]

Print Statement [Tue, 22 Feb - 2 Posts]

Priority Scheduler charting [Mon, 11 Apr - 4 Posts]

Priority scheduler question. [Tue, 28 Sep - 3 Posts]

Priveleges to which user name [Fri, 08 Apr - One Post]

Problem Executing a macro [Mon, 22 Aug - 2 Posts]

Problem in compiling Stored procedure [Thu, 31 Mar - 3 Posts]

Problem with Current_date function [Wed, 20 Apr - 13 Posts]

Problem with Multiload and different types of records in a flatfile [Mon, 14 Feb - 5 Posts]

Problem with PPI Table Creation? [Tue, 19 Apr - 7 Posts]

Problem with priority scheduler. [Thu, 27 Oct - 2 Posts]

Problem with with Decimal field in Fast Export [Mon, 29 Aug - 6 Posts]

Problems loading Decimal(18) [Wed, 14 Sep - 5 Posts]

Procedure NAme Function [Fri, 16 Dec - 2 Posts]

Procedure Problem. [Tue, 15 Feb - 4 Posts]

Pros and cons of using Join Indexes [Fri, 07 Oct - 4 Posts]

Purging Data from tables [Tue, 23 Mar - 11 Posts]

PUT Fails to start configuration [Thu, 15 Sep - 2 Posts]



Qualify Clause in Delete Query [Wed, 07 Dec - 6 Posts]

Qualify in MicroStrategy tool? [Tue, 07 Jun - 4 Posts]

Query Length Time Increase [Thu, 10 Feb - 4 Posts]

Query Logging Ghosts [Mon, 14 Feb - 5 Posts]

Query output differences between V2R4 and V2R5 [Thu, 24 Feb - 4 Posts]

Query to get the last space in a string. [Wed, 21 Sep - 8 Posts]

Queryman vs interagate and ODBC [Fri, 29 Apr - 3 Posts]

Question -- Unix 3.03 &amp; Control-M [Fri, 10 Jun - One Post]

Question about CLI error: EM_GSSINITFAIL(235) [Fri, 05 Aug - 5 Posts]

Question about inserting rows [Thu, 03 Nov - 5 Posts]

Question about MLOAD ni combination with Informatica [Thu, 10 Feb - One Post]

Question about SAMPLING [Mon, 06 Jun - 2 Posts]

Question around recursive queries [Fri, 16 Dec - One Post]

Question of Aborting an Abort operation [Thu, 16 Jun - 5 Posts]

Question on Concurrent sessions [Thu, 31 Mar - 8 Posts]

Question on COPY [Tue, 08 Mar - One Post]

Question on Cube operator [Tue, 17 May - One Post]

Question regarding Selection limits [Thu, 07 Jul - 8 Posts]

Question to PM / API return values Monitor Session Group 2 data values [Tue, 08 Mar - 4 Posts]

Questions about Packages &amp; Stored Procedures [Fri, 21 Jan - 2 Posts]

Questions about the advisability of manual modification of interval statistics [Wed, 18 May - 9 Posts]

Questions abt Permanent Journal [Thu, 17 Mar - 2 Posts]

Questions regarding skewed tables [Wed, 12 Oct - One Post]

Queueing Jobs in a Disaster Recovery Scenario to Reduce Tape Contention [Tue, 22 Nov - 3 Posts]



R&D-DW-RFID [Thu, 16 Jun - 3 Posts]

R6.1 anyone? [Thu, 08 Dec - One Post]

Random Amp Sampling [Mon, 14 Feb - 3 Posts]

Random function with a column value [Thu, 03 Mar - 8 Posts]

Rank and dense_rank [Sun, 24 Jul - 5 Posts]

Ranking in Queryman [Tue, 11 Jan - 3 Posts]

Read zip file for loading data in fastload [Fri, 13 May - 3 Posts]

Realtime DW: Msg Qs [Thu, 04 Aug - 4 Posts]

Recommendation for diagnostic helpstats tool [Thu, 13 Oct - One Post]

Reconfiguration and Database Space [Wed, 16 Mar - 4 Posts]

Record Count Dynamically [Wed, 09 Mar - 2 Posts]

Record count stored in Data Dictionary [Wed, 26 Jan - 13 Posts]

Recording downtime [Tue, 05 Apr - 2 Posts]

Recursive Queries and conditioning hierarchies [Wed, 26 Oct - 4 Posts]

Redestributing large tables instead of replicating a small table [Mon, 26 Sep - 25 Posts]

Referential Integrity [Sat, 09 Jul - One Post]

Reg TeraData/CLI Connection [Tue, 01 Feb - 3 Posts]

Regarding the Spool Space during the EXPLAIN plan taken agianst SQL query [Fri, 15 Apr - 2 Posts]

Regarding usage Of MAX function [Sat, 06 Aug - 4 Posts]

Releasing MLoad lock during the Acquistion Phase [Sat, 22 Jan - 5 Posts]

Rename database [Fri, 18 Feb - 2 Posts]

Replace Text Function [Thu, 13 Oct - 7 Posts]

Replication in Teradata V2R6 [Thu, 01 Sep - One Post]

Requesting "Newbie Help" - What should I pay [Tue, 06 Dec - 2 Posts]

Reserve Words for V2R6 [Fri, 28 Jan - 6 Posts]

Restoring Dictionary information. [Fri, 29 Jul - One Post]

Restrict number of Rows Affected [Thu, 10 Mar - 9 Posts]

Restricting IPs [Thu, 06 Jan - 6 Posts]

ResUsageSvpr - msgworkqlenmax &amp; msgworkqlensum [Wed, 27 Apr - 2 Posts]

Return Code 8 [Fri, 07 Jan - 11 Posts]

Returning ONLY the data portion of a SELECT via BTEQ inSTDOUT [Thu, 01 Sep - 6 Posts]

Reusing INMODS [Fri, 02 Dec - 3 Posts]

Revoking ALLNESS option on a database privilege [Wed, 21 Dec - 2 Posts]

Revoking the grant to PUBLIC authority [Thu, 27 Jan - One Post]

Right Aligning Character Field [Wed, 27 Apr - 3 Posts]

Roles &amp; Profiles Looking for feedback [Thu, 10 Mar - 5 Posts]

Rounding in TERADATA and performance [Wed, 27 Jul - 2 Posts]

Rounding time to the nearest quarter hour [Fri, 16 Sep - 2 Posts]

Row insert Update Timestamp [Thu, 10 Mar - One Post]

Row selection in SQL Assistant [Thu, 10 Feb - 7 Posts]

Row to Column Function [Thu, 25 Aug - 6 Posts]

ROWID based join! [Fri, 12 Aug - 6 Posts]

Running macro from EXCEL . [Mon, 14 Feb - 4 Posts]



Sampling [Tue, 07 Jun - 2 Posts]

Scalability in Teradata - in terms of AMPs [Mon, 14 Nov - 3 Posts]

Scheas supported [Tue, 31 May - 4 Posts]

Script and "@" symbol [Tue, 25 Jan - 4 Posts]

Secondary Index on Volatile tables [Wed, 02 Feb - 7 Posts]

Secure JDBC Teradata Connection [Wed, 13 Apr - 2 Posts]

Select and Case performance [Fri, 08 Jul - 2 Posts]

Self Join within an Update [Wed, 26 Jan - 2 Posts]

SESSION DISCONNECTS [Mon, 05 Dec - 6 Posts]

Session Pools [Mon, 07 Feb - 2 Posts]

set role ALL [Tue, 16 Aug - 3 Posts]

SET Role in Fastload [Wed, 21 Dec - 9 Posts]

Set table vs. Multiset table with Unique Primary index [Mon, 14 Feb - 2 Posts]

Set Type in Priority Scheduler [Wed, 23 Mar - One Post]

Shared Nothing Arch [Thu, 08 Dec - One Post]

Should we use Teradata Warehouse Builder [Wed, 13 Jul - 2 Posts]

SHOW Procedure [Fri, 11 Mar - 4 Posts]

show table and compression [Fri, 18 Feb - One Post]

SIMILAR predicate [Sat, 15 Oct - One Post]

Simple PPI question [Thu, 10 Nov - 8 Posts]

Skew puzzle [Thu, 06 Jan - 3 Posts]

Skewed tables and VARCHAR column [Fri, 28 Oct - 9 Posts]

SKEWING Issue [Thu, 08 Dec - 2 Posts]

Some clarification about of vpacd [Tue, 18 Jan - One Post]

Sort before Join [Wed, 22 Jun - 7 Posts]

Sorting in teradata [Wed, 09 Feb - 4 Posts]

Source data for Multiload!!! [Wed, 01 Jun - 9 Posts]

SP Error 42000 [Fri, 01 Apr - 3 Posts]

Space distribution in Database [Tue, 31 May - One Post]

Spool space calculation [Tue, 13 Sep - 2 Posts]

Spool space parameter in DATABASE [Wed, 01 Jun - 2 Posts]

SQL Assistant - Problems saving queries [Tue, 25 Jan - 4 Posts]

SQL Assistant - Problems with file interface [Thu, 20 Jan - 2 Posts]

SQL Assistant 7.0 and "Query scheduler start up [Wed, 28 Sep - 4 Posts]

SQL Assistant 7.0 with ODBC 3.04 [Tue, 26 Jul - 25 Posts]

SQL Assistant and Null values [Mon, 26 Sep - 6 Posts]

SQL Assistant and search for ??? [Wed, 16 Feb - 4 Posts]

SQL assistant and the max rows returned [Wed, 14 Sep - 3 Posts]

SQL Assistant Custom.syn [Wed, 14 Sep - 3 Posts]

SQL Assistant doesn't like pasting, as the other children do [Thu, 03 Feb - 4 Posts]

SQL Assistant Error Popup [Tue, 13 Sep - 9 Posts]

SQL Assistant Import [Fri, 05 Aug - 5 Posts]

SQL Assistant interferes with other apps [Mon, 24 Oct - 8 Posts]

SQL Assistant versions 7 and 8 [Fri, 17 Jun - 7 Posts]

SQL Case statement help needed. [Sat, 05 Feb - 3 Posts]

SQL Error: expecting something between ( and the select word [Sun, 17 Jul - 11 Posts]

Sql for checking number ofcurrent utilities [Mon, 27 Jun - 2 Posts]

Sql question :: Trim(count(*)) [Wed, 02 Mar - One Post]

SQL to flattening a table [Fri, 24 Jun - 7 Posts]

Sql to identifiy blocked uer [Thu, 01 Dec - 2 Posts]

SQL using Ltrim function [Thu, 28 Apr - 4 Posts]

SSANAME3 [Tue, 07 Jun - One Post]

Staffing a Real-World Warehouse [Fri, 18 Feb - 2 Posts]

Standard Deviation [Fri, 05 Aug - 2 Posts]

Startup procedure of Teradata System [Mon, 11 Jul - 2 Posts]

Statement not recognizing latin char set [Mon, 03 Oct - 3 Posts]

statistics AFTER reconfig ? [Fri, 09 Jun - 8 Posts]

Re: Statistics and collection date [Wed, 23 Mar - 5 Posts]

Statistics and data distribution [Thu, 10 Nov - 3 Posts]

Statistics Help [Mon, 28 Mar - 8 Posts]

Stats on Volatile table -- Possible?? [Fri, 07 Jan - 8 Posts]

Storage of Join Index tables. [Wed, 07 Sep - 2 Posts]

Stored Procedure - VC++ Compiler [Sat, 14 May - 3 Posts]

Stored Procedure Compile anomaly [Mon, 07 Jun - 3 Posts]

Stored Procedure Error Message [Sat, 21 May - 2 Posts]

Stored Procedure Integer Input Parameter Handling [Tue, 23 Aug - 3 Posts]

Stored procedure or view. [Tue, 25 Jan - One Post]

Stored Procedure/VC++ Compiler: Code 5547 [Fri, 22 Apr - 2 Posts]

Stored Procedures and DBQL [Mon, 17 Jan - 3 Posts]

Stored procedures results [Thu, 10 Nov - 33 Posts]

Storing Chinese characters in Table [Mon, 26 Sep - 3 Posts]

Storing Errorcode from BTEQ into table [Fri, 21 Jan - 5 Posts]

Strange syntax on in clauses [Mon, 25 Apr - 4 Posts]

String parsing [Thu, 23 Jun - 2 Posts]

Subquery in Explain [Wed, 03 Aug - 3 Posts]

Support for PPI and UDF [Wed, 05 Jan - One Post]

Suppressing SQL Statistics in BTEQ [Tue, 29 Nov - 3 Posts]

Syntax error in trigger code [Tue, 25 Jan - 3 Posts]

Syntax error while creating UDF [Thu, 31 Mar - 3 Posts]

System Table Maintenance [Thu, 07 Apr - 2 Posts]

System Variables [Tue, 13 Dec - 4 Posts]



TABLE Current Perm not updated after running DEFRAG or PACKDISK [Thu, 24 Feb - 3 Posts]

TD Manager Node Alerts [Fri, 30 Dec - One Post]

TD SQL Exam: Doubts [Sun, 24 Jul - 2 Posts]

TDAministrator: References does not list all views [Fri, 18 Feb - 2 Posts]

TDConnect Application Server [Wed, 02 Feb - One Post]

TDQM / Teradata DWM API [Wed, 30 Mar - One Post]

TDQM timestamps [Wed, 15 Jun - 3 Posts]

Teradata DBA Activities [Mon, 24 Oct - One Post]

Teradata Administrator &amp; comments [Fri, 08 Jul - One Post]

Teradata and Essbase [Thu, 12 May - 2 Posts]

Teradata and Oracle SQL [Fri, 22 Apr - 2 Posts]

Teradata Coding Standards? [Thu, 01 Sep - One Post]

Teradata connection from PERL [Tue, 02 Aug - 3 Posts]

Teradata connection to two machines [Fri, 29 Apr - 6 Posts]

Teradata database version problem [Mon, 14 Mar - 4 Posts]

Teradata Driver for HOLOS access [Wed, 19 Oct - 8 Posts]

Re: Teradata equivalent of DB2 TRANSLATE [Thu, 15 Sep - 5 Posts]

Teradata equivalent of TRANSLATE [Wed, 14 Sep - One Post]

Teradata error message 2450 [Mon, 07 Feb - 4 Posts]

Teradata Extension Error - Error code 3144 [Wed, 13 Jul - One Post]

Teradata Hashing vs data types [Fri, 18 Mar - 4 Posts]

Teradata JDBC-Unicode Driver Problem [Fri, 08 Jul - 6 Posts]

Teradata Manager 6.1/TTU7.1 and Windows 2003? [Fri, 03 Jun - One Post]

Teradata manager alerting [Thu, 10 Nov - 2 Posts]

Teradata Manager Upgrade 6.1 to 7.0 [Thu, 11 Aug - 6 Posts]

Teradata Manager: Password was incorrect [Tue, 18 Jan - One Post]

Teradata ODBC and ASP - Session remains open [Sat, 29 Jan - 4 Posts]

Teradata ODBC Error in Informatica. [Wed, 27 Jul - One Post]

Teradata ODBC error using Analysis Services [Thu, 20 Jan - 4 Posts]

Teradata ODBC Performance [Thu, 27 Jan - 2 Posts]

Teradata partners conference. [Mon, 25 Jul - 2 Posts]

Teradata prepare: Transaction ABORTed due to idle timeout. [Wed, 29 Jun - One Post]

Teradata privileges [Tue, 05 Apr - 2 Posts]

Teradata row distribution and hashing [Tue, 28 Jun - 12 Posts]

Teradata Stored Procedures and ETL [Tue, 09 Aug - 2 Posts]

Teradata under Windows [Wed, 16 Nov - 3 Posts]

TERADATA UPSERT/MERGE [Mon, 17 Jan - 2 Posts]

Teradata V2R5.1 and Perl [Tue, 28 Jun - 3 Posts]

Teradata Visual Explain without access to QCF [Tue, 12 Jul - 11 Posts]

Teradata Vs oracle Comparison doc anybody has it? [Thu, 17 Feb - One Post]

Teradata Vs Oracle Grid [Sun, 17 Jul - 2 Posts]

Teradata Warehouse builder for TTU 8.0 [Mon, 24 Jan - 4 Posts]

Terajdbc driver on UNIX [Mon, 24 Jan - 8 Posts]

TERAOBDC performance [Wed, 26 Jan - 4 Posts]

TerMgr DataCollection for Priority Scheduler [Mon, 14 Mar - 5 Posts]

Testing demo V2R6, want to spoil cache [Thu, 14 Apr - 5 Posts]

The HOSTS dosen't work [Tue, 06 Sep - 9 Posts]

The return of the UDF Library [Mon, 14 Nov - One Post]

The story of a wild query... [Mon, 29 Mar - 4 Posts]

The use of ID Columns [Sat, 24 Sep - 2 Posts]

Thoughts on Anomy.Anom [Thu, 17 Nov - 6 Posts]

Time out Waiting for Lock on UV Table. [Thu, 28 Jul - 2 Posts]

Time Stamp for Last Update [Thu, 25 Aug - 2 Posts]

To skip record in Multiload. [Wed, 22 Jun - 2 Posts]

Topics for training [Thu, 11 Aug - 5 Posts]

Tpump failures - session forced off. [Mon, 20 Jun - 3 Posts]

TPump Multiload - On trial..... [Sat, 22 Jan - One Post]

TPump Rate Change Problem [Wed, 25 May - 2 Posts]

TPump Update [Mon, 14 Mar - 30 Posts]

TPUMP: rate and pack correlation [Sun, 17 Jul - 2 Posts]

Tracking system object usage question [Fri, 18 Mar - One Post]

Transaction Rollback [Thu, 30 Jun - 17 Posts]

Transversal of index #1 [Mon, 25 Jul - 2 Posts]

Trends Analysis with Teradata Manager 6.0 [Tue, 25 Jan - 3 Posts]

Trigger deployment [Thu, 10 Mar - 3 Posts]

Trim Function for multiple characters [Fri, 27 May - 4 Posts]

TTU7.1 with AIX 5.3 ? [Tue, 22 Mar - 3 Posts]



UDF + NOT EXISTS + CASE [Thu, 15 Sep - 7 Posts]

UMBDLOC.C [Wed, 12 Jan - 2 Posts]

Umlat Character Case gets converted [Fri, 24 Jun - 2 Posts]

Unexpected handling of duplicate results [Tue, 23 Aug - 3 Posts]

Re: Unicode setting in ODBC [Thu, 28 Jul - 4 Posts]

UNION or UNION ALL [Wed, 19 Oct - 4 Posts]

Unique Secondary Index Conundrum [Tue, 09 Aug - 2 Posts]

Uniqueness checking on AccLogTbl [Thu, 05 May - 6 Posts]

Unix FastExport problem [Mon, 29 Aug - One Post]

Unix Variable In Fastload script [Tue, 29 Mar - 5 Posts]

Unknown Error in arcmain log [Wed, 02 Mar - 4 Posts]

Untranslateable characters [Sat, 09 Jul - 2 Posts]

Updatable cursors via CLI [Thu, 21 Apr - 2 Posts]

UPDATE vs DELETE-INSERT [Wed, 16 Nov - 5 Posts]

UPDATE, SET, &amp; Subquery [Tue, 10 May - 4 Posts]

Update/Insert (Upsert) [Thu, 03 Mar - 4 Posts]

Updating a CLOB column [Thu, 23 Jun - 4 Posts]

Updating with Volatile Table [Thu, 02 Jun - One Post]

UPSERT Vs MERGE [Sun, 24 Jul - 2 Posts]

Upsert with added Update in Multiload [Fri, 18 Feb - 2 Posts]

Urban myth / Legend / Complete fabrication [Wed, 07 Sep - 7 Posts]

Urgent Crash Dumps !!! [Wed, 23 Nov - 5 Posts]

Urgent: Cannot load profiles from database. Error 224 [Fri, 11 Nov - 2 Posts]

Urgent: Question on Teradata batch upsert [Fri, 09 Sep - 6 Posts]

Usage of MLScript in Fast export [Fri, 11 Feb - 2 Posts]

Use of Charset name instead of Charset code in CLIV2 [Wed, 12 Jan - One Post]

Use of Indexes in Teradata [Wed, 09 Mar - 6 Posts]

Use of Insert/Select Versus Fastload [Mon, 24 Oct - 8 Posts]

Useful Data Dictionary Query - NUSI Columns (Crosstab), NUSI &amp; Table Access Counts [Thu, 18 Mar - One Post]

Useful Data Dictionary Query - PI Columns (Crosstab), Skew, Table Size, Access Counts [Thu, 18 Mar - One Post]

User connecting Session Pool [Mon, 14 Feb - 3 Posts]

User Setup: SECADMIN vs SYSDBA [Wed, 14 Sep - 2 Posts]

Username,password,role,profile...groups.. [Tue, 05 Apr - 4 Posts]

USI as a uniqueness constraint [Tue, 03 May - One Post]

Using "Like" and sub queries [Tue, 06 Sep - 5 Posts]

Using Add_Months with column defined as 'YYYYMM' (Char(6)) [Mon, 06 Jun - 4 Posts]

Using IDCs in tables [Thu, 18 Aug - 3 Posts]

Using MLoad to update several columns [Thu, 12 May - 3 Posts]

Using rexec/rsh from Windows client [Tue, 26 Jul - 4 Posts]

Using TDQM to block jobs [Mon, 07 Feb - 2 Posts]

Using Teradata Procedural Language [Fri, 11 Mar - 3 Posts]

Using Variable in bteq [Wed, 30 Nov - 2 Posts]

UTY4017 Not enough data in vartext record number 1. [Thu, 17 Feb - 9 Posts]



V2 R5 And IN-LIST Processing [Fri, 11 Feb - 2 Posts]

V2R5 and deadlocking [Thu, 24 Feb - One Post]

V2R5 and mail output hanging [Fri, 28 Jan - One Post]

V2R5 query to return tables for which user has permissions, given the database name. [Fri, 22 Apr - One Post]

V2R5.1 dynamic partition elimination [Wed, 06 Apr - 13 Posts]

V2R6 and AD [Wed, 12 Oct - One Post]

V2R6 Experiences [Mon, 11 Jul - One Post]

V2R6 Windows XP problem: Connection failed. [Thu, 01 Dec - 3 Posts]

Varbyte Conversion [Wed, 14 Dec - 2 Posts]

View column data type [Tue, 08 Nov - 16 Posts]

Views referring tables [Fri, 18 Feb - 15 Posts]

Views with Missing Tables [Fri, 01 Apr - 2 Posts]

Visual Explain Error [Thu, 10 Nov - 9 Posts]

Visual Explain memory Error [Thu, 28 Apr - 2 Posts]



Warehouse Builder 05.00.00 [Thu, 05 May - 2 Posts]

Warning Error: 3705 - Request executed in interpretive EVL mode [Tue, 17 May - 2 Posts]

What are the major differences of Teradata on Mainframe [Fri, 20 May - 2 Posts]

What is Dynamic sampling? [Thu, 17 Mar - 2 Posts]

What is LIBPM [Mon, 28 Nov - 7 Posts]

What is Terdata SQL? [Tue, 02 Aug - 5 Posts]

Re: What would cause explains to slow down? [Fri, 19 Feb - 5 Posts]

What's the Max value for the Float data type? [Tue, 02 Aug - 4 Posts]

When is Spool released? [Thu, 13 Oct - 3 Posts]

Where is the DDL for Temporary Tables stored? [Thu, 17 Feb - 4 Posts]

Which is faster [Fri, 25 Feb - 2 Posts]

Why are Revoke Statements passive [Sat, 08 Jan - 3 Posts]

Why do I get a spool space error [Thu, 20 Oct - 13 Posts]

Why do these queries produce different results. [Sun, 17 Jul - 7 Posts]

Why does a badly skewed join run that badly? [Mon, 09 May - 4 Posts]

Why is Join Index feature so restricted! [Tue, 05 Apr - 4 Posts]

Why Multiload won't support USI [Thu, 19 May - 4 Posts]

Why UPI on DBC.Acctg? [Thu, 14 Apr - 7 Posts]

win50post_data_restore [Thu, 10 Feb - 4 Posts]

WINDDI Set Up [Fri, 18 Nov - 5 Posts]

Workarounds for Decimal18+ [Thu, 03 Feb - 5 Posts]

Writing to file from a Teradata SQL statement [Mon, 17 Oct - 2 Posts]

Writing UDF for Numeric Datatypes [Mon, 01 Aug - 8 Posts]

wrong execution plans with volatile tables? [Mon, 28 Feb - One Post]



X-Term Solution [Tue, 01 Mar - 5 Posts]

XML - Export From BTEQ [Wed, 09 Nov - 5 Posts]

XML file as input for TPUMP: is it possible? [Thu, 13 Jan - 5 Posts]



Yet another Perl interface for Teradata [Thu, 17 Nov - One Post]



zos 1.6 anyone running it ? [Thu, 11 Aug - 3 Posts]






 
  Top Home Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2016 - All Rights Reserved
Last Modified: 28 Jun 2020