|
"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 |