Home Page for the TeradataForum
 

 

Subject Index for 2007


 

The threads below were posted in the year 2007.


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


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

 
<< 2006 2008 >>
 
 
 

2 infiles in Multiload [Fri, 19 Oct - 8 Posts]

2689 Vs 3604 [Mon, 12 Feb - 2 Posts]

2926 No more room in journal table for %DBID.%TVMID [Thu, 18 Oct - One Post]



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

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

3714: Insufficient memory [Sun, 03 Jun - 9 Posts]



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



7547: Target row updated by multiple source rows [Sun, 03 Jun - 4 Posts]



8066 toshostenable message [Wed, 28 Feb - One Post]



A question on Left Join [Wed, 12 Dec - 20 Posts]

Accent Insensitive Matches [Tue, 06 Feb - 11 Posts]

Access locks and the future [Wed, 01 Mar - One Post]

AccessCount and LastAccessTimeStamp in Indices view [Wed, 18 Jul - One Post]

Accessing 2 Tdata servers from single UNIX BOX [Fri, 13 Apr - 2 Posts]

Accessing or Loading DB2 data from Teradata [Tue, 24 Apr - 2 Posts]

Adding new columns to an 11 billion row table [Mon, 27 Aug - 4 Posts]

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

Alert policy setting not working for all idle jobs [Sat, 19 May - One Post]

Alter Partition [Tue, 17 Apr - One Post]

Alter Table from Datype date to timestamp [Thu, 22 Feb - 7 Posts]

AMP IS DOWN [Fri, 09 Nov - 5 Posts]

Ampusage and Coexistent Systems [Wed, 11 Jul - 2 Posts]

Ampusage and node model [Tue, 20 Mar - 6 Posts]

Arcamin Restore in V2R6.02 [Mon, 29 Oct - 2 Posts]

Archive Methods [Thu, 04 Oct - One Post]

Archiving By PPI [Mon, 30 Jul - One Post]

Arcmain heredoc [Tue, 06 Feb - 3 Posts]

Arcmain Lock Question [Thu, 24 May - One Post]

Are you Teradata or NCR? [Tue, 25 Sep - One Post]

Auto DB space add [Mon, 03 Dec - 5 Posts]

Automatic Teradata killing sessions [Wed, 13 Jun - 7 Posts]

Average Response Time [Sat, 19 May - One Post]

Avoid the Product Join [Wed, 21 Feb - 9 Posts]



Best way to debug a Stored Procedure [Wed, 17 Jan - 5 Posts]

Between Statement [Tue, 14 Aug - 9 Posts]

Between: not working as expected [Wed, 21 Nov - 18 Posts]

BigINT and Timestamp [Fri, 27 Apr - 2 Posts]

Blanks and Coalesce behavior [Mon, 11 Jun - 4 Posts]

Blocking and queuing [Fri, 16 Feb - 2 Posts]

Break Point for using a Sparse Join Index [Thu, 05 Jul - 5 Posts]

Broken Pipe Error in Mload [Wed, 25 Apr - 7 Posts]

BTEQ - export string with CRLF [Tue, 20 Feb - 4 Posts]

BTEQ connection error [Fri, 23 Mar - 4 Posts]

BTEQ Export Limit [Wed, 12 Dec - 11 Posts]

BTEQ not called by crontab in unix [Thu, 25 Jan - 9 Posts]

Bteq SHOW TABLE export [Fri, 10 Aug - 8 Posts]

BTEQ via Web-Interface Hanging [Tue, 12 Jun - 4 Posts]



C compiler on Teradata Demo 8.1 [Thu, 30 Aug - 2 Posts]

Cache in teradata? [Wed, 14 Nov - 8 Posts]

Calculate Percentages for a column [Tue, 06 Nov - 7 Posts]

Calculating number of compressible values as a [Thu, 08 Nov - 3 Posts]

Calculating spool space used by a single Query [Mon, 06 Aug - 2 Posts]

CALL statement in dynamic sql [Tue, 09 Oct - 2 Posts]

Calling a procedure in a select statement [Thu, 18 Jan - 5 Posts]

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

Casting integer as Time [Wed, 03 Jan - 20 Posts]

CASTing to lesser precision [Tue, 14 Aug - 2 Posts]

Re: Change CPU Limit [Wed, 03 Jan - 2 Posts]

CHAR(1) Vs BYTEINT [Mon, 27 Aug - 5 Posts]

Chart CPU Utilization [Tue, 27 Nov - 6 Posts]

Check constraint. [Tue, 14 Aug - 13 Posts]

Check for existing attributes in a table [Sat, 27 Oct - 2 Posts]

ClearPeakDisk will not clear DBC peak permspace [Tue, 08 May - 2 Posts]

CLI error 315 (SESSCRASHED) [Tue, 16 Oct - 2 Posts]

CLI error: MTDP: EM_MOSI(204): Error coming from MOSI routine [Tue, 04 Dec - One Post]

CLIv2 for RedHat Linux [Mon, 19 Mar - One Post]

Coalesce on timestamps [Fri, 23 Nov - 7 Posts]

Code examples for doing collect statistics in a [Tue, 24 Apr - One Post]

COLLECT DEMOGRAPHICS [Thu, 28 Jun - 2 Posts]

Collect Stats on multiple columns in a table [Tue, 27 Mar - 4 Posts]

Collect Stats on PI: Index vs Column [Mon, 10 Dec - 8 Posts]

Collecting statistics and 'no confidence' [Sat, 21 Jul - 8 Posts]

Column level security [Fri, 30 Mar - 4 Posts]

COLUMNTYPE LOOKUP [Thu, 18 Jan - 5 Posts]

Compare Indexes with same table name [Tue, 04 Dec - 2 Posts]

Complete Refresh of data : Mload or Fastload [Fri, 14 Dec - 4 Posts]

Compression Algorithm [Mon, 22 Oct - 7 Posts]

Compression in ERWin [Wed, 15 Aug - 2 Posts]

Compression of Archive Files [Thu, 19 Apr - 2 Posts]

Concurrent Backups through netvault 7.1 [Thu, 19 Apr - 3 Posts]

Conditionally Converting a Many to One relationship [Thu, 18 Oct - 5 Posts]

Connect to Teradata from VB.Net [Wed, 03 Jan - 2 Posts]

Control line feeds [Tue, 25 Sep - 5 Posts]

Controlling abort session for PMON [Thu, 21 Jun - 5 Posts]

Controlling the activity count column [Wed, 22 Aug - 2 Posts]

Convert HostData to Readable format [Mon, 05 Mar - 4 Posts]

Convert Oracle Stored Procedure to Teradata Stored Procedure [Fri, 14 Sep - 4 Posts]

Converting MULTISET Table to Set Table [Mon, 23 Apr - 9 Posts]

Counting a column multiple times based on CASE [Fri, 05 Jan - 6 Posts]

CPU sec variations [Wed, 08 Mar - 8 Posts]

Create table in a Macro [Tue, 07 Aug - 4 Posts]

Create table with comments [Fri, 07 Dec - 4 Posts]

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

CURRENT_TIMESTAMP function bug? [Mon, 25 Jun - 3 Posts]

Cursors - passing variables to system test... [Wed, 14 Mar - 3 Posts]

Cybermation ESP agent on MP-RAS [Fri, 02 Feb - 2 Posts]



Data BlockSize [Wed, 12 Dec - 5 Posts]

Data Collection tables not populating &amp; Dashboard [Thu, 13 Jul - One Post]

Data row too long!!! [Wed, 15 Feb - 7 Posts]

Data storage patterns under Fastload (and [Thu, 06 Sep - 3 Posts]

Data transfer from one server to other [Thu, 13 Dec - 4 Posts]

Database full when deleting rows [Tue, 26 Jun - 11 Posts]

DataStage Enterprise Edition [Wed, 10 Jan - 4 Posts]

Datastage job with sequencer [Thu, 30 Aug - 2 Posts]

Datastage: Sequential or Parallel [Thu, 06 Sep - One Post]

DBC Tables Backup. [Fri, 12 Jan - 3 Posts]

DBQL ending automatically [Mon, 22 Oct - 3 Posts]

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

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

Default character set of an user [Thu, 26 Jul - 7 Posts]

Delete and update with join [Wed, 07 Feb - 7 Posts]

Delete Statement taking a long time to run. [Tue, 27 Nov - 9 Posts]

Dependant objects [Mon, 19 Feb - 8 Posts]

Designing wide (fat) tables [Wed, 06 Jun - 7 Posts]

Development enviroment [Thu, 16 Aug - 5 Posts]

Differences between Table Partitionings [Mon, 15 Oct - 2 Posts]

Discovering View Dependencies - Show Select * From [Tue, 10 Apr - One Post]

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

Doing an update of a row using self join. [Fri, 12 Jan - One Post]

Drop constraint not null [Thu, 09 Aug - 4 Posts]

Dual Active DR solutions [Thu, 15 Feb - One Post]

Dyanmically Generate SQl [Wed, 01 Aug - 2 Posts]

Dynamic assignment of node for logon [Fri, 20 Apr - 3 Posts]

Dynamic View creation [Wed, 15 Aug - 4 Posts]

Dynamically passing upperbound value for RANDOM [Tue, 21 Aug - 2 Posts]



E-mailing facility without using cronjobs [Tue, 24 Jul - One Post]

Enabling LastAccessTimeStamp [Tue, 30 Jan - 5 Posts]

Enhancements or Improvements to Stored Procedures [Thu, 19 Jul - 5 Posts]

Error 2513 -- A data row is too long [Mon, 26 Mar - 2 Posts]

Error 53 - file not found MONPM.DLL [Wed, 11 Apr - 3 Posts]

ERROR [207] MTDP: EM_NETCONN(207) [Fri, 06 Jul - 5 Posts]

Error for .import with filter condition [Tue, 27 Feb - 7 Posts]

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

Error Message " Internal error: Please do not [Tue, 24 Apr - 5 Posts]

Error records number report in fastexport log [Fri, 07 Sep - 3 Posts]

Error when loading NULL's in DATE field using [Tue, 27 Mar - 2 Posts]

Error when loading Tables using TPT [Thu, 23 Mar - One Post]

Error while opening DBW Tool!! [Mon, 23 Apr - 2 Posts]

Error while opening MULTITOOL [Wed, 25 Apr - One Post]

Estimate Column Size [Wed, 12 Dec - 2 Posts]

Eternally Foolproof Casting from text to number [Fri, 20 Jul - 6 Posts]

Exiting on BTEQ errors [Thu, 08 Mar - 14 Posts]

Experimenting with ISPs [Tue, 25 Sep - One Post]

Explain Anomaly: Direct Query vs View [Tue, 18 Dec - One Post]

Export Issue Retrieving 400 Columns [Tue, 17 Jul - 6 Posts]

Exporting Unicode Data from MS Access to Teradata [Wed, 12 Dec - 4 Posts]

Extracting First,Middle and last Name [Sat, 19 May - 2 Posts]

Extracting time from numeric field [Wed, 07 Nov - 5 Posts]

Extradcting and Ordered list of Values present in a single column [Tue, 26 Jun - 3 Posts]

Extraneous Columns On GROUP BY [Mon, 20 Aug - 2 Posts]



Fast load - double quote [Thu, 24 May - One Post]

FastExport Error from NT [Thu, 20 Sep - 4 Posts]

Fastload + INS / SEL or MultiLoad [Wed, 08 Aug - 7 Posts]

Fastload check point [Tue, 14 Aug - 2 Posts]

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

FastLoad Errors vs MLoad [Thu, 26 Apr - 5 Posts]

FastLoad Record Delimiter [Thu, 29 Nov - 4 Posts]

Ferret and Disable flags [Thu, 21 Jun - One Post]

Final SQL code--expanded with view definition [Wed, 11 Jul - 4 Posts]

Finding Multiload locks [Wed, 29 Aug - 13 Posts]

Finding out the table in Macros [Fri, 13 Apr - 6 Posts]

Finding rows in one table not in another [Fri, 27 Jul - 5 Posts]

Finding tablename using Tableid [Tue, 27 Feb - 7 Posts]

Finding the set/multiset property of a table in the data dictionary [Fri, 21 Dec - 3 Posts]

Flat file headers [Mon, 04 Jun - One Post]

Float data type compressions [Tue, 02 Oct - 4 Posts]

Flow control and what to check [Mon, 22 Oct - One Post]

For...Do loop syntax [Wed, 05 Sep - 3 Posts]

Format of timestamp in select [Fri, 04 May - 4 Posts]

Frequently Used Columns in Queries [Tue, 13 Mar - 2 Posts]

Full path for schmon [Wed, 09 May - 2 Posts]

Function for finding minimum among multiple values [Thu, 29 Mar - 5 Posts]



Gathering statistics within a transaction [Wed, 31 Jan - 3 Posts]

Generate unique id [Mon, 29 Oct - 10 Posts]

Generated SQLs getting truncated [Mon, 01 May - 9 Posts]

Generation of Surrogate Keys [Thu, 29 Nov - 13 Posts]

Global temp table -- Peculiar behavior on update [Mon, 12 Nov - 2 Posts]



Help on DIAGNOSTIC command [Sun, 03 Jun - 2 Posts]

Hexadecimal Dataset - Conversion to ASCII (Standard [Thu, 12 Apr - One Post]

High skew while doing rank [Thu, 09 Aug - 4 Posts]

Hot Standby Nodes and DNS names and/or cop entries [Tue, 11 Sep - 2 Posts]

How are Tperfs calculated? [Tue, 27 Nov - 3 Posts]

How Backup table to file using TDBACKEX? [Fri, 19 Jan - One Post]

How Do You Measure/Validate Compression Savings? [Tue, 30 Jan - 21 Posts]

How to build the normalized funtionality in Mload [Tue, 14 Aug - 3 Posts]

How to dump all object definitions in a database [Fri, 02 Feb - 10 Posts]

How to find and kill a hanging thread? [Tue, 10 Jul - 3 Posts]

How to Find Index Structure of a Table [Tue, 26 Jun - 4 Posts]

How to find Number of days in a year from SQL [Sat, 18 Aug - 3 Posts]

How to find Partitioning Space? [Mon, 29 Oct - 4 Posts]

How to get 5 digit month diff [Thu, 28 Jun - 3 Posts]

How to get column types in views [Thu, 22 Mar - 5 Posts]

How to get confidence on derived spool [Fri, 29 Jun - 3 Posts]

How to Get Output of SQL in UNIX Variable [Mon, 10 Sep - 2 Posts]

How to grant permission to run dbw [Wed, 31 Jan - One Post]

How to identify the spool space of a particular [Sat, 24 Mar - 4 Posts]

How to improve confidence level on built locally on the AMPs SPOOL space [Tue, 24 Jul - 3 Posts]

How to improve MLoad performance [Tue, 24 Apr - 5 Posts]

How to insert a new-line char? [Wed, 10 Jan - 2 Posts]

Re: How to Load CLOB into Teradata [Mon, 01 Jan - 3 Posts]

How to restart the MLOAD job from UV table [Sat, 19 May - 3 Posts]

How to restore selected users? [Wed, 24 Oct - One Post]

How to run multiple BTEQ in BTET mode [Tue, 20 Mar - One Post]

How to run the Select SQL generated as a result of a SQL in Macro or Procedure [Tue, 21 Aug - 7 Posts]



IBM/Orcacle equivalents of DBQL? [Thu, 07 Jun - 2 Posts]

IDCOL Batch Size [Mon, 22 Oct - One Post]

Identifying backup is running [Wed, 06 Jun - 6 Posts]

Import doubt [Fri, 20 Apr - 3 Posts]

Import/Export data with decimal characters [Fri, 07 Dec - 6 Posts]

In WHERE clause multiple equality conditions ORed [Tue, 11 Sep - 3 Posts]

Inconsistent Behavior of SQL passed through ODBC connection. [Wed, 21 Feb - 4 Posts]

Incremental backups [Fri, 16 Mar - 4 Posts]

Incrementing field with an INSERT [Mon, 12 Mar - 5 Posts]

Index Building [Tue, 11 Dec - 5 Posts]

Indextypes Q, M, and K. [Wed, 24 Jan - 6 Posts]

Indextypes Q, M, and K [Wed, 21 Nov - 4 Posts]

Info on using DataStage EE with Teradata [Wed, 07 Mar - 3 Posts]

Informatica database driver error using teradata . [Tue, 03 Jul - One Post]

Re: Informatica-TDAT connectivity [Fri, 12 Jan - 3 Posts]

Information about collect statistics already done for tables in particular Database [Thu, 24 May - 2 Posts]

Ingrain encryption for Teradata [Wed, 27 Jun - One Post]

Insert / Select No More Spool [Wed, 26 Sep - 3 Posts]

Inserting/Updating through a View using MLoad [Wed, 04 Apr - One Post]

Installing Teradata on RedHat Linux Enterprise AS 4.0 [Tue, 30 Jan - 5 Posts]

Installing Trend Antivirus [Tue, 30 Jan - One Post]

Interagate 6.3.3 not working with TTU 8.1 [Wed, 11 Jul - 3 Posts]

Intercept the Teradata logon to run a script [Thu, 01 Nov - 4 Posts]

Invalid views [Tue, 16 Jan - 7 Posts]

IPC on MPP [Wed, 11 Apr - 5 Posts]

Is there a way to get the Access Logging turned on [Fri, 26 Jan - One Post]

Is there any command on BTEQ to drop a file [Wed, 09 May - 4 Posts]

Is there any way to find all tables which have two particular column in a database [Wed, 28 Feb - 8 Posts]

Is this possible in pure SQL [Fri, 13 Jul - 3 Posts]

Issue in delete [Mon, 03 Dec - 5 Posts]



JDBC and the number of records being returned [Thu, 07 Jun - 4 Posts]

JDBC invalid date and partitioned table [Fri, 12 Jan - One Post]

JDBC Parameters [Wed, 31 Oct - 2 Posts]

Join Index Question [Tue, 04 Dec - 4 Posts]



Link Teradata tables in Access 2003 [Thu, 04 Jan - 6 Posts]

Linux ODBC setup [Wed, 07 Nov - 6 Posts]

List of V2R6 Features [Thu, 20 Sep - 5 Posts]

Loading data from Oracle via SQL Assistant [Thu, 15 Nov - 5 Posts]

Local time vs. UTC time [Thu, 24 May - One Post]

Locking a Database for READ only [Wed, 20 Jun - 5 Posts]

Locking/unlocking a table [Tue, 05 Jun - 4 Posts]

Locks in fastload [Fri, 12 Oct - 4 Posts]

Locks on a table [Tue, 21 Aug - 2 Posts]

Looking up ranges of RANGE_N partitioned tables [Thu, 08 Nov - 3 Posts]

LPAD similar function in teradata [Wed, 19 Dec - 8 Posts]

lslpp: 0504-307 No match was found for the SWVPD data search. [Fri, 09 Feb - 2 Posts]

LSN error using FASTLOAD [Wed, 28 Nov - 3 Posts]

LSN Error with MLOAD [Wed, 21 Nov - 4 Posts]



MAX vs rank-qualify [Mon, 23 Jul - 4 Posts]

Maximum amount of CPU allowed [Wed, 21 Mar - 6 Posts]

Maximum number of dml statements in a Tpump Script [Thu, 20 Sep - One Post]

Merging large volumes of data into large history tables [Sat, 07 Apr - 19 Posts]

Minimal Stats Sampling and a well-informed [Sat, 19 May - 6 Posts]

MINUS works well; EXCEPT has an exception [Fri, 20 Jul - 5 Posts]

Missing UDF Libraries [Wed, 29 Aug - 3 Posts]

Mload &amp; Clob in Teradata [Fri, 19 Jan - 4 Posts]

Re: MLoad and PPI question [Mon, 01 Jan - 3 Posts]

Mload error message - 2795 [Tue, 18 Sep - 7 Posts]

Mload script to copy data from 1 table to another table in Teradata [Wed, 20 Jun - 6 Posts]

Mload: Taking very long time to run [Mon, 05 Nov - 5 Posts]

Modify Profile and Error 7547 [Mon, 22 Jan - 5 Posts]

Modifying MaxLoadTasks [Tue, 13 Mar - 2 Posts]

MONITOR SESSION using PM API [Wed, 21 Feb - 7 Posts]

MSAccess Results with SQLassistant [Thu, 22 Feb - 2 Posts]

MTDP: EM_NOHOST(224) error [Tue, 07 Aug - 4 Posts]

Multi stream backup for Teradata [Fri, 20 Apr - One Post]

MULTI VALUE COMPRESSION [Mon, 10 Sep - 4 Posts]

Multi-column index COLLECT STATISTICS script [Mon, 29 Jan - 3 Posts]

Multiload data in a table with identity column [Thu, 08 Nov - 3 Posts]

MultiLoad Delete Failure 2554 [Thu, 20 Sep - 3 Posts]

Multiload error 3857 from BTEQ export file [Fri, 26 Oct - 2 Posts]

Multiload Upsert Performance. [Wed, 17 Jan - 3 Posts]

Multiload/fastload threshold increased? [Tue, 13 Feb - 3 Posts]

Multiload: Control output error (UTY2408) [Wed, 25 Apr - One Post]

Multiple file inputs to PC Fastload [Fri, 02 Feb - 3 Posts]

Multiple MLOAD to same target table [Mon, 12 Mar - 5 Posts]

Multiple record types using mload [Wed, 28 Feb - 9 Posts]

MULTISET/SET - PK - NO PK [Tue, 11 Sep - One Post]

MVS Copy and Paste to SQL Assist 7.2.0.4 [Fri, 12 Oct - 6 Posts]

MVS: MQ Series to Tpump [Thu, 01 Nov - One Post]



Name Format Change [Fri, 21 Sep - 6 Posts]

Named Pipes Access Module [Tue, 17 Apr - One Post]

Named pipes with Fastload [Fri, 02 Feb - 3 Posts]

NCR Announces Intention to Separate into Two [Mon, 08 Jan - One Post]

Need to know difference between dbc.ampusage and DBCMNGR.LogSchmonSystem [Wed, 14 Feb - 2 Posts]

Need Your help for moving object from one database to another. [Thu, 24 May - 2 Posts]

No more ARCMAIN on IBM AIX Servers with V2R6? [Thu, 24 May - One Post]

Non-default DATABLOCK SIZE [Fri, 06 Apr - 3 Posts]

Non-displayable character in file. [Sat, 19 May - One Post]

Null Value [Wed, 06 Jun - 2 Posts]

NULLIF in .FIELD [Mon, 19 Mar - 7 Posts]

NULLs in the file to Mloaded [Tue, 27 Mar - 2 Posts]

Number of pi duplicates [Tue, 25 Sep - 3 Posts]

Number of records deleted? [Tue, 21 Aug - 5 Posts]



ODBC returning gargabe! [Fri, 10 Aug - One Post]

ODBC TIMESTAMP math problem (datatype - or ANSI Date Time error) [Thu, 30 Aug - 8 Posts]

ODBC Upgrade, V2R3 to V2R6.1 [Sat, 13 Jan - 2 Posts]

OffSite Tape Storage [Fri, 12 Jan - 2 Posts]

OLELoad and EOF on INPUT stream [Fri, 20 Jul - 2 Posts]

Only diff in Tables is PI column definition: [Thu, 16 Aug - 3 Posts]

Optimized Joins in Teradata initiated thru SAS [Mon, 29 Oct - 2 Posts]

Optimizer plan - Use of stats [Sat, 19 May - One Post]

Optimum range of data to load data using TPUMP [Tue, 31 Jul - One Post]

Oracle Gateway Version Support [Wed, 06 Jun - One Post]

Oracle Stored Procs and Macros [Mon, 17 Dec - 5 Posts]

Oracle2Teradata [Wed, 07 Mar - 3 Posts]

ORDER BY in INSERT SELECT to GENERATE Sequence [Fri, 12 Jan - 6 Posts]

Order of inner joins alter plan [Fri, 30 Mar - 7 Posts]

Out of Spool after Collecting Statistics [Wed, 11 Apr - 5 Posts]

Owner Grant Access [Tue, 14 Aug - 2 Posts]



Parent Child Relationship [Mon, 03 Dec - 6 Posts]

Parition Elimination with Using Clause [Fri, 17 Aug - 2 Posts]

Parsing of SQL and macro efficiency [Mon, 05 Mar - 4 Posts]

Partition Statistics [Thu, 29 Mar - 2 Posts]

Partition Table PPI automation [Wed, 03 Jan - 6 Posts]

Parts of a string delimited by underscore [Wed, 09 May - 3 Posts]

PeakSpool and SUM Step [Fri, 22 Jun - One Post]

Performance Data for Query Director? [Tue, 01 May - One Post]

Performance difference between SQL89 and SQL92 [Mon, 26 Feb - 2 Posts]

Performance Group Ids [Mon, 24 Apr - 3 Posts]

Performance impact on Packdisk [Wed, 28 Nov - One Post]

Performance of a self join [Mon, 05 Mar - 11 Posts]

Performance of Teradata SQL Assistant 7.1 [Fri, 05 Jan - 5 Posts]

Performance of Volatile table [Fri, 06 Apr - One Post]

Perl module for Teradata and Windows [Thu, 15 Feb - One Post]

Phone number character data cleaning? [Tue, 24 Apr - 3 Posts]

PMON data tables [Tue, 06 Feb - 9 Posts]

PowerDesigner - COLLECT STATISTICS [Thu, 03 May - 2 Posts]

PPI and Mulitple Columns [Mon, 05 Feb - 6 Posts]

Privileges required to "Grant Index access on a table" [Thu, 06 Dec - 9 Posts]

Problem connecting to TeraData via ADO from Windows 2003 machine [Thu, 11 Jan - 4 Posts]

Problem Returning Time [Tue, 27 Feb - 4 Posts]

Problem setting the error_message in UDF [Wed, 24 Jan - 7 Posts]

Problem with handling null values for Partition [Fri, 26 Oct - 6 Posts]

Problem with Teradata Manager E-mail Alerts [Sat, 19 May - One Post]

Problem with Tpump [Tue, 28 Aug - 6 Posts]

Problems posting? [Wed, 12 Sep - One Post]

Process/command to renice [Sat, 06 Jan - 3 Posts]

Pseudo Tables in EXPLAIN [Tue, 27 Mar - 5 Posts]



Query on Sessions [Wed, 24 Oct - 2 Posts]

Question about APPLY with TDWM [Thu, 29 Nov - One Post]

Question about Revoke/disable LOGON [Wed, 20 Jun - 4 Posts]

Re: Question on Spool/Profiles [Tue, 02 Jan - 2 Posts]

Question on Stored Procedures. [Fri, 23 Feb - 2 Posts]

Question regarding current spool usage [Wed, 10 Jan - 4 Posts]

Question regarding dummy table [Wed, 10 Jan - 11 Posts]

Questions about result in alert.log [Wed, 31 Jan - 5 Posts]

Queue on CPU [Tue, 28 Aug - One Post]



Random BTEQ program error [Mon, 22 Oct - 2 Posts]

Random Date Updates [Fri, 26 Oct - 4 Posts]

Rank in Teradata [Tue, 28 Aug - 3 Posts]

Ratio of reserved space to data space [Mon, 03 Dec - 3 Posts]

Re-Creation of a View after drop and Recreating of the Table [Fri, 26 Jan - 6 Posts]

Recover VSN from header tape with ASF2 [Thu, 16 Aug - 2 Posts]

Release locks left by failed backup [Mon, 05 Mar - 2 Posts]

Remote console -- Cannot see utilities [Sat, 30 Jun - 3 Posts]

Remove non-numeric characters. [Mon, 19 Feb - 2 Posts]

Removing duplicates from table [Wed, 17 Oct - 12 Posts]

Replacing a character [Thu, 22 Feb - 4 Posts]

Representation of Partitioned Priomary Indexes in DBC [Fri, 14 Dec - 6 Posts]

Requirements for Informatica full pushdown optimization [Thu, 18 Jan - 3 Posts]

Reset Peak Spool for one or more users [Thu, 24 May - 2 Posts]

Response between Message based application around database [Fri, 12 Jan - 2 Posts]

Restoring a database without ARC Main [Tue, 30 Oct - 2 Posts]

Restrict Audit Tables [Mon, 23 Apr - 3 Posts]

Restricting String column to accept only Lower Case Values [Tue, 03 Apr - 9 Posts]

Return Code "8" [Tue, 17 Apr - 9 Posts]

Rollback &amp; Recovery Issue [Mon, 19 Nov - 2 Posts]

Row CheckSum [Thu, 20 Dec - 14 Posts]

ROWNUM CONVERSION FOR TERADATA [Fri, 09 Feb - 7 Posts]



Scan the whole tape to restore the small table [Tue, 20 Mar - 7 Posts]

Script to reproduce logging in DBQL [Mon, 26 Feb - One Post]

Secondary Indexes Stats and Usage [Wed, 31 Oct - 4 Posts]

Segregation of Duties - Security and DBA [Mon, 03 Dec - 5 Posts]

Select from a view Using UNION ALL spools out. [Wed, 21 Feb - 2 Posts]

Selecting date without quotes [Mon, 16 Jul - 12 Posts]

Separate database for Views and Locking [Thu, 11 Oct - 5 Posts]

SET Table and UPI [Tue, 09 Jan - 3 Posts]

Set Tables with UPI [Thu, 25 Oct - 6 Posts]

SET Versus MULTISET [Thu, 15 Feb - One Post]

Shifting from RAID 1 to RAID 5 [Sun, 01 Apr - One Post]

Show table shows different database [Mon, 06 Aug - 4 Posts]

Single Pass MV Compression Analysis [Fri, 20 Apr - 4 Posts]

Skew on voltile table [Sat, 19 May - 2 Posts]

Slow Hash Join [Tue, 17 Jul - One Post]

Sorting views created on various tables [Fri, 21 Dec - 3 Posts]

Space, another final frontier... [Wed, 24 Oct - 2 Posts]

Specify input format for date [Fri, 06 Apr - 4 Posts]

SPL1078:E(L12), User is not authorized to use the DDL/DCL/Dynamic SQL statement. [Mon, 06 Aug - 7 Posts]

Spooling View in OJ - V2R6.2 [Fri, 22 Jun - One Post]

SQL Assistant - Export Results [Thu, 26 Apr - 6 Posts]

SQL Assistant 7.2 - compatible Access versions [Fri, 04 May - 2 Posts]

SQL Assistant 7.2 error DoQuery-14 [Sun, 09 Sep - 4 Posts]

SQL Assistant 7.x slow &amp; and crashes on fetching DB2 answer sets [Mon, 29 Oct - 8 Posts]

SQL Assistant and Window Focus [Thu, 19 Apr - 7 Posts]

SQL Assistant error: unable to open history [Tue, 26 Jun - 3 Posts]

SQL Assistant help - Window being minimized [Wed, 12 Dec - 7 Posts]

SQL Functions in MLOAD Script.. [Fri, 20 Apr - 3 Posts]

SSO Linux &amp; V2R6.2 [Fri, 22 Jun - 2 Posts]

Starting XDBW from telnet connection [Mon, 05 Nov - 4 Posts]

Statistics and lock contention [Fri, 09 Mar - 11 Posts]

Statistics in BT; ET; [Mon, 26 Nov - 17 Posts]

Statistics on DBC tables [Mon, 23 Apr - 2 Posts]

Stats on Non-Indexed Columns [Thu, 08 Nov - One Post]

Stored Procedure - 3927 Error [Thu, 24 May - 2 Posts]

Stored Procedure execution mode [Wed, 20 Jun - 2 Posts]

Storing result from macro in a table [Thu, 12 Apr - 3 Posts]

Storing Sound [Wed, 21 Mar - 4 Posts]

Strange rounding [Fri, 13 Apr - One Post]

STRING functions: Counting character occurrences [Mon, 01 Jan - 10 Posts]

String reversal function [Tue, 03 Apr - 4 Posts]

String Reverse [Tue, 13 Mar - One Post]

Stripping numeric data in varchar(900) [Mon, 27 Aug - 3 Posts]

SUBSTR query [Tue, 20 Feb - 7 Posts]

Summarizing dbc.qrylog table [Wed, 04 Apr - 5 Posts]

Surrogates through Mload [Tue, 16 Oct - 7 Posts]

Syntax - Diagnostic Stats [Wed, 19 Dec - 3 Posts]

System function of mload [Tue, 31 Jul - 2 Posts]



Table Function access to Oracle [Mon, 05 Feb - One Post]

Table skew and Primary Index [Fri, 12 Jan - 7 Posts]

TD Administrator and "connection has been reset by peer" [Mon, 06 Aug - 3 Posts]

Teradata / Essbase fact tables [Sun, 03 Jun - 2 Posts]

Teradata and Cognos [Mon, 27 Aug - One Post]

Teradata and ETL [Wed, 05 Sep - 3 Posts]

Teradata and SRDF [Thu, 06 Dec - 5 Posts]

Teradata Database Migration Via odbc [Fri, 16 Feb - 2 Posts]

Teradata DB account vs. Business Objects Portal [Thu, 16 Aug - 4 Posts]

Teradata Demo version for Vista? [Mon, 25 Jun - One Post]

Teradata ERwin question: Format Property [Wed, 29 Aug - 3 Posts]

Teradata JDBC 4 / v3.04 and java connectivity [Tue, 09 Oct - 2 Posts]

Teradata Join condition with case statement [Mon, 02 Apr - 4 Posts]

Teradata license cost [Mon, 05 Feb - One Post]

Teradata Manager Ampusage Data Collector [Mon, 02 Jul - 2 Posts]

Teradata Manager as windows service [Tue, 27 Nov - One Post]

Teradata Manager Dashboard Documentation [Mon, 02 Jul - One Post]

Teradata Manager Data Collector for Resusage [Tue, 06 Feb - 6 Posts]

Teradata ODBC for LINUX Red Hat 64 Bit [Mon, 06 Aug - 2 Posts]

Re: Teradata SQL Assistant on Citrix servers [Wed, 03 Jan - 2 Posts]

Teradata utilities through DNS names [Tue, 09 Oct - 8 Posts]

Teradata Utility Backup on NetVault [Tue, 14 Aug - 2 Posts]

Teradata V2R6 and Websphere connectivity [Thu, 24 May - One Post]

Teradata V2R6 and BO connectivity [Thu, 24 May - One Post]

Teradata Views looking at Tables in a different [Wed, 19 Dec - 8 Posts]

Teradata.Client.Provider [Wed, 03 Jan - 2 Posts]

Test data insertion into Varbyte column [Wed, 05 Sep - One Post]

Testing that the data is in a set format [Wed, 05 Sep - One Post]

TF to access external data [Fri, 13 Apr - 2 Posts]

The IBM IIW data model implemented on Teradata? [Thu, 19 Apr - One Post]

The last occurance of a character [Mon, 02 Jul - 6 Posts]

The Queue on CPU [Sun, 03 Jun - One Post]

Throttle I/O [Tue, 16 Jan - 2 Posts]

Throttle load utility [Mon, 29 Jan - 3 Posts]

To check for Non ASCII in the data [Tue, 12 Sep - 5 Posts]

To remove Two continuos Blanks from Data [Sun, 03 Jun - 3 Posts]

TOP vs SAMPLE function [Tue, 04 Dec - 3 Posts]

Total CPU, AWT, memory and I/O usage of a multiload [Fri, 17 Aug - 2 Posts]

Total payment volume per transaction per customer [Wed, 27 Jun - 3 Posts]

tpt and oledb [Wed, 26 Sep - One Post]

Tpump error: UTY6625 Packing has changed to 17 [Fri, 07 Sep - 5 Posts]

Turning on Permanent Journals [Sat, 01 Sep - One Post]

Type 3 JDBC driver [Tue, 23 Jan - 4 Posts]



UDF Failure 3706 Syntax error: Invalid statement [Wed, 12 Dec - 13 Posts]

Unable to GlobalAlloc memory for LAN message buffer [Wed, 24 Jan - 3 Posts]

Unable to read multi files using variables [Fri, 20 Apr - 2 Posts]

Unchecking the 'Allow Use of ODBC SQL Extensions in queries' for Microstrategy [Tue, 30 Oct - 3 Posts]

Unexpected behavior in Fastload [Tue, 23 Oct - 4 Posts]

Unicode flag in dbc View [Sat, 19 May - 4 Posts]

Unicode surprise [Fri, 06 Jul - 10 Posts]

UNIX equivalent of HUTCNS [Thu, 19 Apr - 3 Posts]

Update for 'Dates, Times and Timestamps in Teradata' [Mon, 19 Mar - One Post]

Update vs Delete/Insert [Fri, 17 Aug - 4 Posts]

UPDATE with a SUBQUERY [Mon, 08 Jan - 3 Posts]

Update with left outer join [Mon, 12 Feb - 6 Posts]

UPDATE, SET, &amp; Subquery Re-visited [Wed, 25 Jul - 3 Posts]

Updating a partition table [Fri, 05 Jan - 4 Posts]

Upgrading to V2R6.1...any words of wisdom? [Fri, 14 Sep - 2 Posts]

Usage of RC Media and RC Configuration tables [Mon, 30 Apr - 2 Posts]

Use of Stored Procedures [Wed, 18 Apr - 2 Posts]

Use of surrogate keys in place of dates [Tue, 03 Jul - One Post]

Username and last modified information for a particular table [Tue, 02 Jan - 4 Posts]

Using a Macro to create the mload Script [Mon, 30 Apr - 5 Posts]

Using Coalesce in Multiload [Tue, 27 Mar - 2 Posts]

Using FastEXport with Named Pipes [Fri, 09 Mar - 7 Posts]

Using Netbackup to copy a portion of a table from a backup tape [Thu, 13 Dec - 4 Posts]

Using NULLIF in fastload [Tue, 03 Jul - 4 Posts]

Using table name dynamically [Fri, 14 Dec - 4 Posts]



VARCHAR expansion in Spool [Fri, 02 Feb - 2 Posts]

varhar(8) to date [Thu, 13 Jul - 7 Posts]

Verifying tables structures between two different databases [Thu, 13 Dec - 9 Posts]

View statistic values [Wed, 25 Jul - 10 Posts]

View to Anonymize Data ?? [Thu, 29 Mar - 3 Posts]



Was data collection adversely affected by running out of room in database dbc? [Tue, 27 Mar - 2 Posts]

What is IS STAGED [Thu, 19 Jul - 5 Posts]

When Teradata says it is a "BIG" table [Fri, 27 Jul - 2 Posts]

Who has Select Access to Views/Tables [Mon, 10 Sep - 7 Posts]

WIDTH Problem in BTEQ [Tue, 13 Nov - 7 Posts]

Working with duplicate rows [Thu, 16 Aug - 12 Posts]

Workings of TOP n [Mon, 10 Dec - 2 Posts]

Workload Balance Question [Thu, 01 Mar - 2 Posts]



XML [Wed, 17 Jan - One Post]

Xref of SQLSTATE to SPL codes [Fri, 28 Sep - 3 Posts]






 
  Top Home Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2016 - All Rights Reserved
Last Modified: 28 Dec 2016