Home Page for the TeradataForum
 
 

 

Subject Index for 2005


 

The threads below were posted in the year 2005.


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

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

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


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 & 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 & 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 [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 & 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 & 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 & 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 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