|
"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 (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 & 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 & 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 & 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 & 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 & 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 & 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 & 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 & 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, & 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 & 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]
| 
