Home Page for the TeradataForum
 

 

Subject Index for 2013


 

The threads below were posted in the year 2013.


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.

 
<< 2012 2014 >>
 
 
 

'Median' value of three dates [Tue, 05 Mar - 6 Posts]



3419: TDWM Filter violation for query request: for rule name 'high steps rows limit' [Fri, 30 Aug - 3 Posts]

3610 QueryBanding in View for security check [Fri, 12 Jul - One Post]

3916 errocode [Fri, 07 Jun - 3 Posts]



7451 Invalid Timestamp Error [Thu, 28 Mar - 6 Posts]



[3710] Insufficient memory to parse this request, during QueryRewrite phase [Fri, 21 Jun - 4 Posts]

[SET] AUTOKEYRETRIEVE [OFF|COLUMN|ROW] [Wed, 15 May - One Post]



Access count in DBC.Indices [Mon, 01 Jul - 6 Posts]

Access Log Cost [Thu, 12 Dec - One Post]

Accessrights reporting macro - updated version [Mon, 15 Apr - One Post]

Adding a Name to Primary Index without recreating it [Tue, 15 Oct - 4 Posts]

Admin Comment: Outage on Tuesday, 15 Jan 2013 [Wed, 16 Jan - One Post]

Admin Comment: Removal of Copyrighted Material [Mon, 14 Jan - One Post]

Ampusage and dbqlogtbl [Tue, 09 Apr - One Post]

Any Limit on datasize for FASTLOAD in TD 14.0? [Fri, 08 Nov - 3 Posts]

Anyone using Tivoli Storage Manager? [Thu, 16 May - 2 Posts]

ARCMAIN : the clause "partitions where" [Tue, 25 Jun - One Post]

ARCMAIN To Copy Archived Database & Children [Wed, 20 Mar - 3 Posts]

Authentication error between TARA and TSM [Sat, 29 Jun - 5 Posts]

Automatically use latest backup using [Thu, 06 Jun - 2 Posts]

Avoiding 2646 when joining with large null [Fri, 05 Apr - 5 Posts]



Backup/TD issues in TD14.10 [Fri, 27 Sep - 2 Posts]

Big Data [Tue, 08 Jan - 3 Posts]

Bobj query and rollback [Wed, 03 Apr - 3 Posts]

BYTE Conversion to DECIMAL(18)? [Tue, 28 May - 3 Posts]



Can I use variables in SQL Assistant? [Wed, 15 May - 2 Posts]

Can the ROW_NUMBER data type be changed? [Tue, 23 Apr - 6 Posts]

Can't drop a table [Fri, 23 Aug - One Post]

Can't logon to TD system [Tue, 16 Apr - 2 Posts]

Canary query metrics [Mon, 05 Aug - 2 Posts]

Capturing the error cd and desc [Thu, 05 Sep - 2 Posts]

Case-sensitive password [Wed, 13 Mar - 7 Posts]

CAST(CURRENT_TIME AS TIME) reporting wrong time in TD 14.0 [Thu, 17 Oct - 6 Posts]

Changed MaxParseTreeSegs [Wed, 17 Apr - One Post]

Characters rejected by Fastload [Thu, 07 Nov - 4 Posts]

Checking for numeric characters in each row of a particular column [Mon, 15 Jul - 7 Posts]

CheckTable Utility -- alter default settings to ViewPoint screen [Mon, 08 Apr - 5 Posts]

Collect statistics and bad effects [Tue, 04 Jun - 4 Posts]

Collect stats on the Data dictionary tables [Fri, 04 Jan - 5 Posts]

Collect Stats Report [Mon, 14 Jan - 8 Posts]

Column constraints [Sun, 27 Jan - 3 Posts]

Column or character expression is larger than max [Thu, 06 Jun - One Post]

Compare 2 tables in 2 different databases [Thu, 17 Jan - 4 Posts]

Compare Fields in Separate Records [Wed, 26 Jun - 4 Posts]

Compress Teradata Backups [Thu, 25 Jul - 2 Posts]

Compression scripts for 13.10 [Mon, 21 Jan - One Post]

Conditional Update with CASE [Fri, 13 Dec - 6 Posts]

Connection reset by peer error [Thu, 27 Jun - 5 Posts]

Converting Byte filed to Hexadecimal [Mon, 02 Sep - 9 Posts]

Re: Converting to date format [Wed, 02 Jan - 5 Posts]

CPU consumption on compression [Mon, 26 Aug - 6 Posts]

CPU/IO ratio on DBC.dbqlogtbl [Wed, 07 Aug - One Post]

Re: Creating a new table by copying other table with a portion of data [Wed, 02 Jan - 8 Posts]



Data format issue [Mon, 21 Jan - 7 Posts]

DateTimeFormat's in SQLA/TD [Sun, 14 Apr - 3 Posts]

DBC AccessRights table is skewed [Tue, 10 Dec - 5 Posts]

dbcmngr.LogHeartbeat [Tue, 02 Jul - One Post]

DBQL log with enabled object logging is not [Fri, 26 Jul - One Post]

DDL inside a Macro [Thu, 03 Jan - 2 Posts]

Delete going into delay [Tue, 13 Aug - 2 Posts]

Description or Purpose of System Users in [Tue, 03 Dec - 2 Posts]

Diff between SET with UPI and MULTISET with UPI [Tue, 05 Nov - 6 Posts]

Difference between ARCMAIN format and Universal format [Mon, 04 Nov - 3 Posts]

Differences between EDW Appliance and EDW system [Tue, 27 Aug - 2 Posts]

Differential Backup [Mon, 08 Jul - 8 Posts]

Download sqla 13.11.0.6 [Wed, 30 Jan - 2 Posts]

Drop Indexes before load or insert [Thu, 13 Jun - 4 Posts]

Duration of blocked/blocking Query [Thu, 14 Mar - 4 Posts]



Effectiveness of NOPI [Wed, 16 Jan - 3 Posts]

Empty partition for a table [Tue, 19 Feb - 3 Posts]

Error : 3704: "0A"X not a valid Teradata SQL [Tue, 05 Feb - 9 Posts]

ERROR [HYT00][ODBC TERADATA DRIVER] Query time out expired [Tue, 16 Jul - 4 Posts]

Error in casting decimal to char [Wed, 29 May - 2 Posts]

Error when call PM API monitor session [Sun, 14 Apr - One Post]

Error while FTP data from MF file to CSV file [Tue, 30 Apr - 4 Posts]

Exclude Multiple Databases from Backup/Restore [Thu, 18 Apr - 10 Posts]

Expalin under estimating the stats calculation in 13.10 version [Tue, 08 Oct - 7 Posts]

Explain Plan- Redistribution Related [Fri, 15 Mar - 4 Posts]

Explain Plan-- Partitioned table [Fri, 22 Feb - 5 Posts]

EXPLAIN running for 23 seconds [Sun, 07 Apr - 7 Posts]

Export results to a file from Teradata Adhoc tool [Tue, 25 Jun - 4 Posts]

Exporting DECIMAL(15,2) from DB2 [Sun, 23 Jun - 3 Posts]

Extract TASM Rule set [Tue, 05 Feb - 13 Posts]

Extracting a diagnoses [Thu, 04 Apr - 5 Posts]



Fast export failure - Memory fault [Tue, 02 Jul - 2 Posts]

Fastest Way to Delete data from Table [Fri, 21 Jun - 3 Posts]

FastLoad : Line rejected due to "Field too large" [Mon, 10 Jun - One Post]

Fastload Error - The request exceeds the length [Mon, 11 Mar - 3 Posts]

Fastload Error : NO RECORD OF THE LAST REQUEST WAS FOUND [Thu, 31 Jan - 10 Posts]

FastLoad script with delimited input file [Wed, 11 Dec - 4 Posts]

Fields on which Partitioned is collected [Wed, 27 Mar - 7 Posts]

Find different users current running queries [Tue, 07 May - 2 Posts]

Find Global temporary space usage [Thu, 07 Mar - 5 Posts]

Find out Used & Unused Tape Drives from NetBackup [Fri, 08 Mar - 4 Posts]

Find SQLs that take most CPUs and longest elapsed [Thu, 04 Apr - One Post]

Finding current running queries [Thu, 09 May - 2 Posts]

Finding query starttime stamp and end timestamp [Mon, 06 May - 7 Posts]

Forgotten password of Teradata Account [Mon, 12 Aug - 4 Posts]



Getting error 5977 : Ordered analytical function [Mon, 04 Feb - 3 Posts]

Getting TIME from TIMESTAMP [Sat, 13 Apr - 2 Posts]

Global temporary space usage [Thu, 22 Aug - 8 Posts]

Grant Access to Role [Mon, 08 Jul - 8 Posts]



Handling IN clause in stored procedure [Thu, 17 Jan - 4 Posts]

HASHROW Conversion [Wed, 03 Apr - 4 Posts]

Hexadecimal delimiter. [Thu, 21 Mar - 6 Posts]

High AMP I/O Skew Always [Wed, 19 Jun - 6 Posts]

HOSTDATA col of Mload error table [Thu, 28 Mar - 3 Posts]

How to "dump" a table? [Tue, 04 Jun - 7 Posts]

How to bypass Transient journal [Wed, 27 Mar - 4 Posts]

How to check whether PI has STATS collected [Wed, 14 Aug - 4 Posts]

How to filter data: numeric vs alpha [Fri, 11 Jan - 2 Posts]

How to find Minimum of 3 or more columns? [Mon, 25 Feb - One Post]

How to find tables unsed for a 1year or more [Wed, 23 Jan - 2 Posts]

How to identify data usage in Teradata [Fri, 16 Aug - One Post]

How to identify database privieges for selected users [Tue, 05 Mar - 9 Posts]

How to Implement INCREMENTAL BACKUPS IN TERADATA [Wed, 14 Aug - 2 Posts]

How to implement SCD Type II through FastLoad [Mon, 14 Oct - 5 Posts]

How to increase the size of text o/p from sql assistant [Thu, 11 Apr - 7 Posts]

How to load BLOB data type using fastload [Tue, 08 Jan - One Post]

How to retrieve lost answer set in SQL Assistant [Thu, 21 Mar - 9 Posts]

How to turn on Temporal Feature [Mon, 01 Apr - 3 Posts]



Re: I/O, CPU and AMP SKEW [Tue, 01 Jan - 7 Posts]

Identity search or map doesn't work while testing [Wed, 19 Jun - One Post]

Implicit Join vs Explicit Join in Teradata [Mon, 01 Jul - 7 Posts]

Improve the Throughput of Data Transmission [Mon, 04 Nov - 3 Posts]

Incremental backups using PJ and Partitions [Thu, 26 Sep - 2 Posts]

Information PowerCenter 9.1 & Business Objects 4.0 over Teradata RDBMS 14.00 [Mon, 22 Apr - One Post]

Insert failed: Invalid operation on an ANSI [Wed, 08 May - 4 Posts]

Issues with generated Identity columns [Wed, 15 May - 2 Posts]

Issues with MERGE query [Mon, 22 Jul - One Post]

Iterate INDEX function [Sat, 18 May - 2 Posts]



Journal DB rapidly growing in space [Fri, 22 Feb - 5 Posts]

Julian date issue [Sun, 10 Feb - 4 Posts]



Kill a backup Job [Thu, 20 Jun - 3 Posts]



LDAP Authentication [Mon, 09 Dec - 2 Posts]

Left Join query [Fri, 08 Feb - 2 Posts]

LIKE operator to compare two columns [Mon, 05 Aug - 5 Posts]

Limit/Reset Rank [Wed, 03 Apr - 5 Posts]

Load time in Db2 and teradata. [Tue, 25 Jun - 2 Posts]

Loading Cyrillic Alphabet [Mon, 08 Jul - 5 Posts]

Loading Mainframe Packed decimal column into Teradata table [Mon, 22 Apr - 4 Posts]

Locking 2 tables [Wed, 07 Aug - 7 Posts]

Login error to SQLA 13.11 [Wed, 30 Jan - One Post]



Macro vs Multi statement request in teradata [Wed, 28 Aug - 14 Posts]

Macro with In List parm [Wed, 11 Dec - 3 Posts]

Memory Management error: Failed to connect [Thu, 07 Mar - One Post]

Merge delete performance tuning [Tue, 10 Sep - 5 Posts]

MERGE Failed 5977: Invalid MERGE-INTO statement [Mon, 28 Jan - 4 Posts]

MERGE question [Mon, 18 Mar - 4 Posts]

MERGE Vs UPSERT in a table having MPPI [Thu, 03 Jan - 2 Posts]

MERGE-IN SQL [Fri, 11 Jan - One Post]

Migrating Performance Groups to Workloads in [Fri, 21 Jun - 3 Posts]

Migration between two Teradata Machines [Thu, 04 Apr - 4 Posts]

Mload Hangs in acquisition phase [Thu, 27 Jun - One Post]

Modify Profiles [Tue, 26 Nov - 6 Posts]

Multi Value Compression script [Thu, 28 Mar - One Post]

MultiLoad Acquisition Phase Hangs [Mon, 17 Jun - 5 Posts]



Need to filter Numeric value from Alphanumeric string [Wed, 13 Feb - 5 Posts]

No more spool at night [Tue, 04 Jun - 9 Posts]

Not enough information to log on [Fri, 25 Jan - 3 Posts]



ODBC driver errors [Thu, 29 Aug - 2 Posts]

Online Archive Backup and its consequences [Thu, 08 Aug - 3 Posts]

Only Directly Granted Rights Displayed in SQL Administrator 13.10.0.03 [Fri, 28 Jun - 4 Posts]

Oracle data types in Teradata [Thu, 04 Apr - 2 Posts]

OREPLACE [Wed, 06 Nov - 7 Posts]



Parameterize the attributes - TPT [Wed, 10 Jul - One Post]

Parameterized column selection [Fri, 29 Mar - 3 Posts]

Parameters to judge Query Performance [Thu, 02 May - One Post]

Parsercpu time very high [Mon, 22 Jul - 8 Posts]

Partitioning expression from dbc [Thu, 01 Aug - One Post]

Pass input param as a string value in procedure [Wed, 03 Apr - 5 Posts]

Performance of deleting records with date range in PPI [Tue, 05 Mar - 2 Posts]

Performance of MERGE vs UPSERT [Wed, 27 Feb - 4 Posts]

Performance testing [Wed, 11 Sep - 2 Posts]

PIVOT function [Wed, 02 Jan - 2 Posts]

PPI Revaildation [Thu, 17 Oct - 4 Posts]

Practice of granting role [Mon, 13 May - 3 Posts]

Problem in MULTILOAD UPSERT [Fri, 22 Mar - 2 Posts]

Problems with conenction SQL Assistant [Wed, 02 Oct - 2 Posts]

Problems With Default Value For Timestamp [Wed, 04 Sep - 4 Posts]

Procedure behaviour [Wed, 21 Aug - 2 Posts]

Profiles & Spool Space [Fri, 12 Apr - 5 Posts]



Query Execute time [Fri, 01 Feb - 7 Posts]

Query in the 'RESPONSE' state [Thu, 21 Mar - 5 Posts]

Query Logging for all users [Tue, 03 Dec - 6 Posts]

Query on performance degradation [Tue, 03 Sep - 4 Posts]

Query to find users not logged in since long days [Wed, 19 Jun - 8 Posts]

Question regarding CLOB/BLOB Deferred Mode and Locator Mode [Fri, 30 Aug - 2 Posts]

Questions about SQL Assistant [Tue, 01 Oct - 5 Posts]

Queue Tables [Wed, 18 Dec - 9 Posts]



Record count mismatch [Tue, 08 Oct - 9 Posts]

Recover DBC Password For Dev [Mon, 14 Jan - 7 Posts]

Rename a database [Wed, 16 Jan - 3 Posts]

Replace Characters within String [Wed, 23 Jan - 2 Posts]

Restore Failure : Duplicate storage objects found [Mon, 01 Apr - One Post]

Restricted Query Monitor Portlet in Viewpoint [Mon, 28 Jan - 5 Posts]

Resusage and Network Traffic [Wed, 10 Jul - 2 Posts]

Rowhash Blocking [Mon, 01 Jul - 9 Posts]

RSS settings for V14 [Fri, 19 Jul - 2 Posts]



Selecting single quotes within dynamic SQL [Mon, 10 Jun - 4 Posts]

Serialize on multiple instance TPT [Tue, 08 Oct - 2 Posts]

Session mode & 2971: The AMP Lock table has overflowed [Fri, 22 Mar - 5 Posts]

SET SESSION CHARSET "UTF8" [Thu, 09 May - 3 Posts]

Setting up TVI Window for TD 14 [Fri, 20 Sep - One Post]

Slow Loads from DataStage [Wed, 07 Aug - 2 Posts]

Space occupied in varchar columns [Tue, 13 Aug - 5 Posts]

Spool Usage of a user [Thu, 10 Jan - 5 Posts]

SQL Assistant Hangs- losing query [Wed, 29 May - 3 Posts]

SQL Asst - Query Scheduler Startup Error [Wed, 02 Oct - 2 Posts]

SQL running longer with Between function [Tue, 26 Feb - 9 Posts]

SQLCODE & SQLSTATES [Wed, 22 May - One Post]

Statistics on multi column UPI [Fri, 08 Nov - 10 Posts]

Strange Optimization Problem with PPI [Wed, 13 Feb - 2 Posts]



Tables: How small is small for TD to dynamically [Tue, 19 Feb - 4 Posts]

TD 13.10 TPT fails with error- Data Schema [Tue, 28 May - One Post]

TD database Upgrade from Windows TD 13 [Wed, 30 Jan - One Post]

TD versions [Tue, 12 Mar - 2 Posts]

TD14 on SLES11 [Wed, 24 Apr - 3 Posts]

TDP Connection Lost [Tue, 22 Jan - 2 Posts]

Teradata 13 Time series expansion practical use? [Sat, 05 Oct - One Post]

Teradata 14 upgrade [Mon, 03 Jun - 3 Posts]

Teradata code repository [Thu, 13 Jun - One Post]

Teradata Data Mover [Thu, 18 Apr - One Post]

Teradata decimal roundoff issue [Wed, 16 Jan - 3 Posts]

Teradata OBC Driver Error [Tue, 24 Sep - 3 Posts]

Teradata ODBC connection string with integrated security (perl DBI, Windows 7) [Mon, 04 Nov - 3 Posts]

Teradata ODBC driver on Solaris and SAP Business [Wed, 16 Jan - 4 Posts]

Teradata Query scheduler Administrator Error [Mon, 07 Jan - 6 Posts]

Teradata Query Scheduler [Fri, 16 Aug - One Post]

Teradata SQL Assistant Setup [Tue, 27 Aug - 4 Posts]

Time addition issue [Thu, 11 Apr - 11 Posts]

Time field getting incorrectly populated [Fri, 01 Feb - 6 Posts]

To capture network outages in the Teradata logs [Tue, 30 Apr - 3 Posts]

To restore a database from Journal [Tue, 12 Mar - 2 Posts]

Total available CPU seconds [Sun, 24 Mar - 3 Posts]

TPT - Data Connector producer [Fri, 21 Jun - 4 Posts]

TPT API LOAD - Error: XXXXX is not a table [Thu, 27 Jun - One Post]

TPT error: TPT19350 I/O error on file [Tue, 29 Jan - 4 Posts]

TPT Error: Unable to create config file [Tue, 22 Jan - One Post]

TPT Load - Read Password [Mon, 12 Aug - 3 Posts]

TPT stream operator/Tpump - Duplicate records. [Tue, 17 Sep - 2 Posts]

TPT Without Schema defination [Tue, 18 Jun - 3 Posts]

TPT04049: Error: Unmatched function parenthesis [Mon, 10 Jun - One Post]

Tpump and load slots [Mon, 01 Jul - 2 Posts]

Trial version for Teradata [Fri, 03 May - 2 Posts]

Triming special charecters in data [Mon, 04 Nov - 3 Posts]

Tuning the Query to Better Performance [Wed, 24 Apr - 6 Posts]



UDT based on clob [Fri, 13 Dec - 2 Posts]

Unable to log on minimum number of FastLoad [Tue, 29 Jan - One Post]

Untranslable character issue [Thu, 25 Jul - 3 Posts]

Update the blanks/ spaces to NULL? [Wed, 27 Mar - 5 Posts]

Using fastload to load data with hexadecimal [Thu, 11 Apr - 2 Posts]



Validate CPU Usage query [Mon, 18 Feb - 5 Posts]

VARCHAR and Multi-Value Compression (MVC) [Tue, 01 Jan - 14 Posts]

Version of NPAM [Fri, 28 Jun - One Post]

Viewpoint : Alert for node down [Wed, 13 Feb - 5 Posts]

Viewpoint data collection rate confirmation [Tue, 09 Jul - 2 Posts]

Viewpoint High IMPACT CPU [Fri, 26 Apr - 3 Posts]

Viewpoint notifications [Fri, 28 Jun - 3 Posts]

Viewpoint Server Login [Wed, 08 May - 2 Posts]

VM Hangs when Viewpoint services enabled [Fri, 12 Apr - 9 Posts]



What is a PDN Node [Mon, 26 Aug - 3 Posts]

What is Teradata Control Framework (TCF) [Fri, 01 Mar - One Post]

Who aborted user!! [Thu, 06 Jun - 12 Posts]

Why BT-ET not working on large volume of data? [Thu, 28 Mar - 6 Posts]






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