Home Page for the TeradataForum
 

 

Subject Index for 2011


 

The threads below were posted in the year 2011.


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.

 
<< 2010 2012 >>
 
 
 

2631 Transaction ABORTed due to %VSTR [Mon, 10 Oct - One Post]



5547 error compiling Stored Procedure [Mon, 31 Jan - 2 Posts]

5603: Errors encountered in compiling UDF [Thu, 10 Nov - 4 Posts]



A user can't logon [Tue, 15 Mar - 6 Posts]

ABU : Appliance Backup Utlity [Wed, 29 Jun - 3 Posts]

Access Right on own Database [Mon, 18 Jul - 3 Posts]

Access Rights through Roles [Tue, 15 Mar - 4 Posts]

Account String - difference between $M and $H [Thu, 17 Feb - 3 Posts]

Add a COMMENT on a Join Index [Fri, 15 Apr - 3 Posts]

Admin Comment: Moving to a new server [Mon, 07 Nov - One Post]

Admin Comment: TeradataForum outage [Sat, 12 Nov - 2 Posts]

Aggregate previous four weeks of data [Mon, 24 Oct - 3 Posts]

ALTER TABLE and Blocking [Wed, 12 Jan - 2 Posts]

Alter the column without dropping the table and column [Wed, 05 Jan - 7 Posts]

Alternative for dayofweek function [Thu, 03 Nov - 4 Posts]

AmpCPUTime [Mon, 05 Dec - 4 Posts]

Analysis from DBQLogTble [Mon, 05 Sep - One Post]

Apostrophe(') as parameter value in a Macro [Fri, 04 Mar - 3 Posts]

ARCMAIN 0805 Problem [Sat, 24 Dec - 2 Posts]

ARCMAIN COPY + PARTITIONS WHERE [Mon, 18 Jul - 13 Posts]

ASE variables [Thu, 14 Apr - 2 Posts]

Avoid distinct [Thu, 03 Feb - 6 Posts]



BACKUP and ARCHIVE [Thu, 07 Apr - 3 Posts]

Basic teradata questions [Tue, 04 Jan - 3 Posts]

Batch Workload Management - TD 13.10 [Thu, 11 Feb - One Post]

BEGIN QUERY LOGGING [Tue, 05 Jul - 4 Posts]

Beta testers wanted for Query/Explain Analysis [Mon, 07 Feb - One Post]

BODS/Teradata mload issues [Mon, 30 May - One Post]

Breaking fast export output [Fri, 08 Apr - 2 Posts]

BTEQ - csv file [Thu, 20 Jan - 5 Posts]

Bteq and Mload script errors [Fri, 04 Feb - 6 Posts]

BTEQ and Stored Procedures [Fri, 25 Feb - 3 Posts]

BTEQ error - maximum byte count [Tue, 15 Nov - 3 Posts]

BTEQ ERROR print [Thu, 27 Oct - 2 Posts]

BTEQ Restart Logic [Thu, 06 Jan - 8 Posts]

BTEQWIN [Wed, 27 Jul - 2 Posts]



Calculating uncompressed Size [Wed, 21 Dec - 5 Posts]

Can any one explain mlppi in simple words? [Sat, 15 Jan - 3 Posts]

Can not change default database [Mon, 26 Sep - 11 Posts]

Can you manipulate the AppID / LogonSource? [Thu, 29 Sep - 2 Posts]

Can you take a look at SQL & Subquery [Thu, 17 Mar - 2 Posts]

Capture output from "show select *" into a table [Fri, 09 Dec - 8 Posts]

Cascading Master Detail Deletes [Tue, 25 Jan - One Post]

Cast date to timestamp [Mon, 11 Jul - 6 Posts]

CAST INTERVAL to time gives 5407 error [Mon, 11 Apr - 2 Posts]

Change in execution plan [Tue, 23 Aug - 2 Posts]

Change of Admin password [Thu, 27 Jan - One Post]

Changing Passwords with SQL Assistant 13.0.0.12 [Wed, 02 Mar - 2 Posts]

Changing Timezones [Fri, 20 May - One Post]

Char column stores data with spaces [Mon, 08 Aug - 3 Posts]

Clearing a Comment from an object [Thu, 26 May - 7 Posts]

CLIv2 Programming help [Wed, 20 Apr - 4 Posts]

Cloning all profiles and all user from one sever [Mon, 26 Sep - 3 Posts]

Code of hashamp,hashbucket,hashrow [Fri, 27 May - One Post]

Collect Stats for INSERT/SELECT (no joins) [Mon, 21 Feb - 5 Posts]

Collecting Statistics for NULLS [Thu, 03 Mar - 2 Posts]

Column match in WHERE clause [Thu, 14 Apr - 2 Posts]

Comma in Macro Parameter [Thu, 14 Apr - 3 Posts]

Command to make this title bold [Wed, 19 Jan - One Post]

Compress a column and why? [Mon, 28 Mar - 3 Posts]

Compressing infrequent values [Wed, 26 Jan - 6 Posts]

Compression on decimal fields [Mon, 31 Jan - 3 Posts]

Connect to multiple servers [Wed, 10 Aug - 8 Posts]

Connection close not returning [Wed, 04 May - One Post]

Convert hard coded values in view [Thu, 14 Apr - One Post]

Converting Scalar subqeries from Oracle to [Mon, 26 Sep - One Post]

Converting string to a number: help needed [Tue, 11 Jan - 6 Posts]

Converting TIMESTAMP to DATE [Tue, 08 Feb - 12 Posts]

Copying Statistics from one table to another [Wed, 05 Jan - 6 Posts]

CPU and IO usage per user per day for a given [Mon, 14 Mar - 3 Posts]

Cpu Skew and Query Skew [Fri, 28 Oct - 4 Posts]

Create procedure and CALL DBC.SysExecSQL [Tue, 07 Jun - 5 Posts]

Creating flat files with TPT [Tue, 18 Jan - One Post]

Custom installation of Teradata client [Fri, 14 Oct - 3 Posts]



Data about how an Index was used and the [Wed, 16 Nov - 2 Posts]

Data encryption using TPT [Mon, 18 Jul - 3 Posts]

Database View Limits [Fri, 14 Jan - 5 Posts]

Date format in ML [Fri, 28 Jan - 2 Posts]

Daylight Saving Time (DST) Change [Tue, 08 Mar - 3 Posts]

Deadlock error received [Thu, 22 Dec - One Post]

Decimal display problem [Fri, 25 Feb - 6 Posts]

Defining SI on columns that are part of PI [Fri, 20 May - 3 Posts]

Determine how long a query is in parsing state [Wed, 30 Mar - 2 Posts]

Determining Secondary Index Use [Thu, 07 Jul - 3 Posts]

Diff between Export and SQL selector operator [Thu, 21 Apr - 3 Posts]

Diff bt V2R6 and TD12 [Tue, 11 Jan - 5 Posts]

Difference between collect stats on a column vs. a table [Wed, 03 Aug - 11 Posts]

Difference between Column-level vs Table-level [Mon, 24 Jan - One Post]

Difference between types of join strategies [Mon, 12 Sep - One Post]

Different accesses: same table, same query [Mon, 07 Feb - 2 Posts]

Different EXPLAIN on identical systems [Wed, 22 Jun - 5 Posts]

Diffrence between dbc.accesslog and dbc.logonoff [Wed, 02 Feb - 6 Posts]

Digits before first colon [Mon, 14 Feb - 5 Posts]

Disconnecting idle sessions [Thu, 29 Dec - 2 Posts]

Discrepancies in IO operation counts in DBC [Thu, 16 Jun - One Post]

Distinct vs. group by in TD 13 onwards [Mon, 20 Jun - 12 Posts]

Do We need to Restart DBS to Reset time on system [Fri, 04 Nov - 6 Posts]

Does Count(*) and count(1) has any difference? [Thu, 09 Jun - 8 Posts]

Does JDBC Driver Questionc ache the results of [Tue, 23 Aug - One Post]

Does SET Table with NUPI allow duplicates? [Wed, 28 Dec - 5 Posts]

Download of EASYMVC12T [Thu, 14 Apr - One Post]

Drop ji and then recreate it to avoid overhead? [Wed, 20 Apr - 3 Posts]

Dropping Ix: Impact on performance [Mon, 21 Nov - 4 Posts]

Dropping User and user created objects [Mon, 04 Apr - 12 Posts]

Duplicates appearing even with UPI [Thu, 10 Mar - 2 Posts]

Dynamic Partition Elimination [Mon, 07 Feb - One Post]

Dynamic SQL question about rights [Thu, 20 Jan - 5 Posts]



END TRANSACTION step - long when deleting [Mon, 28 Feb - 8 Posts]

Equivalent command for Fast Load [Thu, 09 Jun - 4 Posts]

Error Codes in TD vs. Oracle [Mon, 24 Jan - 2 Posts]

Error during load of data through Datastage [Fri, 07 Jan - One Post]

Error encountered with multi-line comments in SQL [Mon, 07 Nov - One Post]

Error expected something between QUALIFY keyword and ';' [Wed, 23 Feb - 8 Posts]

Error FEXPORT: UTY4014 - fwrite byte count error [Tue, 18 Oct - 2 Posts]

Error Handling & Stored Procedure [Mon, 18 Apr - One Post]

Error in multiload reading from multiple files [Thu, 14 Apr - One Post]

Error on FastExport Query Execution [Tue, 15 Mar - 3 Posts]

Error with Group By [Wed, 23 Nov - One Post]

Error: 10040 WSA E MsgSize: Message too long [Mon, 20 Jun - 2 Posts]

Excluding the LAST three chareacteres [Tue, 11 Jan - 9 Posts]

Execute macro vs Select [Mon, 19 Dec - One Post]

Extracting the databasename and tablename from errortext in DBC.DBQLOGTBL [Mon, 14 Feb - 3 Posts]



Failed Transactions to Rollback [Fri, 28 Jan - 3 Posts]

Failure while a job was trying to call a [Wed, 25 May - 2 Posts]

Fallback rows [Wed, 05 Jan - 3 Posts]

Fast export with | delimited [Thu, 30 Jun - 5 Posts]

Fast load in application phase [Fri, 08 Jul - 11 Posts]

FastExport - Additonal bytes is appended [Wed, 25 May - 2 Posts]

FastExport script failure - No more spool space [Tue, 25 Oct - 3 Posts]

FastExport Sessions vs performance [Tue, 15 Nov - 2 Posts]

Fastexport: Unexpected Parcel kind received: 144 [Thu, 14 Jul - One Post]

Fastload error 3710: Insufficient memory to parse [Sat, 24 Dec - One Post]

Fastload Error: pmUnxDskOpen: fopen error [Wed, 28 Dec - 2 Posts]

Fastload has no worktable and logtable? [Tue, 05 Jul - 12 Posts]

Fastload options [Thu, 06 Oct - 8 Posts]

FastLoad Restart [Fri, 10 Jun - 5 Posts]

FastLoad/Multiload/Fastexport in DBQL [Mon, 14 Feb - 2 Posts]

Find Last Update date for a table [Wed, 28 Dec - 5 Posts]

Find Modified Objects if ACCESS LOGGING IS [Thu, 29 Sep - 2 Posts]

Find the number of rows of all tables in a database? [Fri, 20 May - 12 Posts]

Find the number of rows of all tables in a [Thu, 23 Jun - 4 Posts]

FLOAD Query Syntax Error [Tue, 15 Mar - 4 Posts]

Format of output [Mon, 23 May - 3 Posts]

Formats in FLOAD, MLOAD [Thu, 07 Jul - 4 Posts]

Formula for best PI candidate [Thu, 22 Dec - 6 Posts]

Functions usage on columns with partitioning [Fri, 27 May - 2 Posts]



Generating report through Bteq Export Dif command [Fri, 04 Mar - 2 Posts]

GeoServer and Teradata Global Temporary Table [Fri, 16 Dec - 3 Posts]

GetTimeZoneDisplacement [Thu, 17 Nov - One Post]

Gettting all Inputs for a particular output [Tue, 10 May - One Post]

Grants to DBC [Wed, 01 Jun - 2 Posts]

Grouping sets and query performance [Tue, 14 Jun - One Post]



Handling of duplicate records in Fast load [Mon, 07 Mar - 5 Posts]

Having clause [Mon, 24 Oct - 3 Posts]

Header and footer requirement details [Thu, 17 Nov - 2 Posts]

High I/O Wait [Wed, 19 Jan - 2 Posts]

Hours Subtraction [Tue, 06 Sep - 6 Posts]

How far behind am I? [Wed, 22 Jun - One Post]

How to abort a session from a batch program ? [Mon, 21 Nov - 3 Posts]

How to assign the value od dynamic sql ? [Fri, 12 Aug - 6 Posts]

How to calculate the time elapsed [Tue, 19 Apr - 3 Posts]

How to Change INTEGER to DATE [Tue, 18 Jan - 2 Posts]

How to decide Teradata Configuration [Sat, 15 Oct - 8 Posts]

How to enable RSG (Relay Service Gateway) [Mon, 19 Sep - 3 Posts]

How to Fetch tables from Database with different suffixes [Wed, 28 Sep - 7 Posts]

How to find list of database objects in teradata. [Tue, 12 Apr - 3 Posts]

How to find the associated tables or view in teradata? [Fri, 18 Nov - 4 Posts]

How to find the name of all database in teradata [Tue, 27 Dec - 2 Posts]

How to identify a Bad Primary Index? [Fri, 09 Dec - 4 Posts]

How to implement array in teradata [Wed, 30 Mar - 2 Posts]

How to list a common column amount tables [Tue, 29 Mar - 6 Posts]

How to synchronization time? [Thu, 20 Oct - 2 Posts]

How to test if tables are in sync [Tue, 27 Sep - 2 Posts]



If a node in the clique fails [Tue, 11 Jan - 2 Posts]

Impact cpu and olap functions [Tue, 29 Nov - 6 Posts]

Implement Basic part of TASM [Fri, 22 Jul - 2 Posts]

Improving performance on big table [Thu, 24 Mar - 2 Posts]

Incorrect Mload script generation [Fri, 27 May - One Post]

Indented Bill of Material Query? [Wed, 27 Jul - 9 Posts]

Insert CHAR to TIMESTAMP [Wed, 19 Oct - 7 Posts]

Insert load half of my data [Wed, 14 Dec - 10 Posts]

Installing Teradata XML Services [Fri, 16 Dec - One Post]

Insufficient memory to parse during Query Rewrite [Thu, 03 Nov - 6 Posts]

Interactive or batch level interface? [Tue, 25 Jan - 3 Posts]

Interpreting session and AMP states in PMON / [Wed, 23 Nov - One Post]

Invalid timestamp [Thu, 17 Feb - 9 Posts]

Irresponsible SQLA [Tue, 13 Sep - 9 Posts]



Joining on inequality involving a fact table [Thu, 01 Dec - One Post]



Last logon for each user [Wed, 20 Jul - 8 Posts]

Learning Teradata UDF [Wed, 27 Jul - 2 Posts]

Length Function [Fri, 03 Jun - 12 Posts]

Loading Data from Oracle to Teradata through TPT [Tue, 07 Jun - 5 Posts]

Lock-out of DBC User [Fri, 15 Apr - 6 Posts]

Locking Logger Impact on System [Fri, 19 Aug - One Post]

Logging on to TD Administrator [Thu, 03 Nov - 2 Posts]

Logon Session time [Mon, 27 Jun - One Post]

Logon/Log off details [Thu, 23 Jun - 2 Posts]

Loopin through a string of Text [Fri, 01 Jul - 3 Posts]



Max Row Size and Data Block Size [Fri, 19 Aug - 3 Posts]

Max value for decimal(10,0) [Wed, 23 Mar - 7 Posts]

Maximum number of Volatile tables in a session [Thu, 10 Mar - 2 Posts]

Mdiff on Date field [Wed, 14 Sep - 5 Posts]

Merge & Upsert in Teradata. [Fri, 21 Jan - 3 Posts]

MERGE options [Tue, 11 Jan - 5 Posts]

Metasurf component of Teradata MDS [Wed, 07 Dec - One Post]

Mixed Case Table Names [Fri, 18 Feb - 6 Posts]

Mload error: UTY0005 Bad data in the FIELD [Tue, 24 May - 2 Posts]

Mload failing: Access out of range input data [Wed, 15 Jun - 5 Posts]

Mload Layout consideration [Tue, 21 Jun - 3 Posts]

Mload running with zero records [Thu, 20 Jan - 4 Posts]

Mload script error: UTY2403 An invalid statement [Tue, 24 May - 5 Posts]

Mload-vartext file [Thu, 02 Jun - 7 Posts]

MLPPI on date field [Fri, 24 Jun - 11 Posts]

MLPPI stats [Sat, 10 Dec - One Post]

Moving history out of SQL Assistant [Sat, 07 May - 2 Posts]

Moving space between databases [Fri, 03 Jun - 2 Posts]

Multi value compression and presence bits [Mon, 23 May - 7 Posts]

Multiset with a UPI [Wed, 01 Jun - 13 Posts]

MVC, VARCHAR, v13.10, error 9471 [Wed, 03 Aug - 11 Posts]

MyBatis etc. - spatial Teradata [Sun, 18 Dec - One Post]

Mysterious "no more spool" errors [Tue, 15 Feb - 4 Posts]

Mysterious access rights [Fri, 20 May - 3 Posts]



Need a help in the logic of query [Sat, 01 Oct - 4 Posts]

Need Help on Connecting to Gateway using CLIV2. [Tue, 18 Oct - 4 Posts]

Need help on explain plan [Wed, 20 Apr - 4 Posts]

Need help on LEFT JOIN - count more than left [Mon, 03 Jan - 6 Posts]

Need help on Teradata Parallel Transporter [Wed, 20 Apr - One Post]

Need help with Dynamic Pivoting [Thu, 27 Jan - 3 Posts]

Need help with Teradata sql query [Mon, 14 Mar - One Post]

Need help writing a function [Mon, 30 May - One Post]

Need performance help with update [Mon, 05 Sep - 6 Posts]

Net Retry% in ResNode Macros [Mon, 11 Jul - One Post]

Network connectivity [Fri, 14 Jan - 8 Posts]

New stats query - 2616: Numeric overflow [Mon, 29 Aug - 5 Posts]

New version of 'isdate' UDF [Mon, 06 Jun - One Post]

New version of stats query [Tue, 27 Dec - One Post]

NOT ( columnname is NULL) condition in a LOJ [Wed, 16 Nov - 2 Posts]

Number of rows in an unknown partition [Tue, 19 Apr - 6 Posts]

Numbers with higher precision [Fri, 06 May - 3 Posts]

NUPI a performance killer in MLoad? [Thu, 28 Apr - One Post]



ODBC disconnect [Wed, 09 Mar - One Post]

ODBC from Access to Teradata failed [Tue, 10 May - 2 Posts]

ODBC versus .NET with SQLA [Mon, 26 Sep - 4 Posts]

Re: Odd case with Dates [Mon, 03 Jan - 4 Posts]

OLAP function and tracking data changes [Wed, 25 May - 11 Posts]

One node fail due to UMB card burn-in [Tue, 01 Mar - 4 Posts]

Optimser behaviour question from TD virgin! [Wed, 23 Feb - 2 Posts]

Ora2TD : Oracle to Teradata Migration [Tue, 02 Aug - 3 Posts]

ORD_HEALTH_STAT_DTL_SECND - SHPTO_CO_NM [Mon, 29 Aug - 3 Posts]

Override and Inapply while releasing locks [Tue, 05 Jul - 7 Posts]



Parameter for input file in multiload [Mon, 24 Jan - 3 Posts]

Partitioned Primary Indexes (PPI) -- Altering [Sun, 06 Mar - One Post]

Partitions and Statistics [Wed, 04 May - 3 Posts]

Performance impact of VARCHAR size [Mon, 07 Feb - 4 Posts]

Performance issue after splitting the big table [Thu, 24 Nov - 12 Posts]

Performance issue due to compression? [Fri, 25 Nov - 2 Posts]

Performance issue due to too many partitions [Thu, 24 Nov - 4 Posts]

Perl script results in a blank output file [Wed, 25 May - One Post]

PI on multicolumns? [Wed, 14 Dec - 5 Posts]

PMPC/Time bug [Tue, 11 Jan - 6 Posts]

PPI not working with Dimension Join [Fri, 22 Jul - 7 Posts]

Primary Index Column [Thu, 21 Jul - 9 Posts]

Problem connecting SQL Assistant V13 [Thu, 30 Jun - 2 Posts]

Problems Installing Teradata query Assistant - 13.0.0.5 [Wed, 04 May - 3 Posts]

Procedure name [Tue, 05 Jul - One Post]

Procedure parameter [Wed, 19 Oct - 2 Posts]

Procedure/Function Overloading in Teradata [Mon, 31 Jan - One Post]

Product Join: Duplicating large table [Fri, 03 Jun - 3 Posts]

Pseudo table and deadlock for BATCHUSER [Mon, 13 Jun - 5 Posts]



QRYLOG issue [Wed, 23 Nov - 7 Posts]

Query ends within a string or common block [Thu, 20 Jan - 4 Posts]

Query level statistics [Tue, 15 Feb - 2 Posts]

Query Performance with Filter [Wed, 26 Jan - 2 Posts]

Questions including Performace tuning [Thu, 06 Jan - 4 Posts]



Read a file inside BTEQ [Wed, 11 May - 5 Posts]

Recurisve query - Minimum Bookmarks [Thu, 24 Feb - 3 Posts]

Recursive Queries and Stored Procedures [Thu, 14 Apr - 9 Posts]

Recursive SELECT from the same table [Fri, 27 May - 2 Posts]

References within Views [Wed, 28 Sep - 4 Posts]

Regarding compression [Tue, 18 Jan - 2 Posts]

Regarding data type compression [Mon, 11 Jul - 5 Posts]

Release mload in apply not working giving error [Thu, 06 Jan - 5 Posts]

Release mload is taking long time [Mon, 12 Sep - 7 Posts]

RELEASE MLOAD taking abnormally long [Thu, 03 Feb - 8 Posts]

Replacement of NULL value with previous NOT NULL value in the same column [Thu, 04 Aug - 3 Posts]

Report from dbc.qrylog by MONTH using SQL [Thu, 17 Feb - 4 Posts]

Report with yesterday's date [Thu, 14 Apr - 5 Posts]

Reporting Question [Mon, 28 Mar - 5 Posts]

Restore User Account Permissions [Thu, 21 Apr - 3 Posts]

Role access [Mon, 31 Jan - 3 Posts]

Role of vdisk in td architecture [Wed, 22 Jun - 2 Posts]

Running a Perl script [Fri, 20 May - 3 Posts]

Running Checktable utility [Wed, 10 Aug - 2 Posts]

Running scandisk [Fri, 19 Aug - 4 Posts]



Script returning wrong return code [Mon, 21 Feb - 3 Posts]

Selected non aggregate values must be part of associated group [Fri, 10 Jun - 3 Posts]

Sessions and AMP interaction [Tue, 29 Nov - 2 Posts]

Set processing VS row processing in Teradata [Tue, 12 Apr - 2 Posts]

Shared wisdom for Teradata v13 upgrade [Fri, 11 Mar - 2 Posts]

Should multiple cliques have same number of nodes [Fri, 07 Jan - 2 Posts]

SHOW TABLE command in SQLA [Tue, 10 May - 5 Posts]

Show table has its large DDL result cut [Mon, 19 Dec - 8 Posts]

Simple way Group by All Columns [Sat, 25 Jun - 2 Posts]

Single User access rights restore [Mon, 15 Aug - 2 Posts]

Slowness with SQL Assistant V13 [Wed, 28 Sep - 3 Posts]

Small Table on One AMP [Thu, 13 Jan - 4 Posts]

Spool being used in upi-pi join [Fri, 01 Jul - 3 Posts]

SQL ASSISTANT --- Why we cannot see TABLES [Tue, 27 Sep - 3 Posts]

SQL Assistant trimming stored procedure [Tue, 19 Apr - 7 Posts]

SQL keeps on generating a title [Wed, 19 Jan - 4 Posts]

SQL Server NVARCHAR replication to Teradata using GoldenGate [Mon, 20 Jun - 3 Posts]

SQLA 13.0 on Windows 7 using ODBC connection [Thu, 15 Dec - 4 Posts]

SQLA sometimes gives CLOB and other times [Fri, 18 Nov - One Post]

Stats collection on Partition vs partitioned [Wed, 04 May - One Post]

Stats on fields in where condition [Fri, 25 Nov - 4 Posts]

Stats Refresh Post Expansion [Tue, 06 Sep - 22 Posts]

Stored procedure error 7968: Result set does not support [Thu, 04 Aug - 4 Posts]

Stored Procedures - Cursor Processing [Tue, 04 Oct - 14 Posts]

Stored Procedures - Proc within a Proc [Mon, 24 Oct - 2 Posts]

Strictly Increasing Identity [Wed, 12 Jan - 3 Posts]

Subqueries inside Scalar subqueries [Wed, 05 Oct - 2 Posts]

SUBSTR function and logonsource [Fri, 08 Apr - 5 Posts]

Suggestions for Performance tuning? [Wed, 23 Mar - 4 Posts]

Sum of distinct counts from three different tables [Thu, 24 Nov - 3 Posts]

Surrogate key usage [Thu, 01 Dec - 4 Posts]

SYSDBA password [Mon, 19 Sep - 2 Posts]



Table design for performance - Query [Tue, 19 Apr - One Post]

Table usage info for housekeeping [Sat, 02 Jul - 3 Posts]

Tables which don't have stats [Mon, 12 Dec - 10 Posts]

TD manager (Demo) - Vproc Utilization [Tue, 31 May - 4 Posts]

TD13: Value compression on Timestamp columns [Tue, 29 Mar - 8 Posts]

TDGeoImport [Mon, 27 Jun - 3 Posts]

TDWM : Logging of DBCMNGR.LogWDSummary [Thu, 16 Jun - 3 Posts]

TDWM Settings in V13 [Wed, 26 Jan - One Post]

Teradata architecture questions? [Tue, 04 Jan - 3 Posts]

Teradata Configuration [Tue, 15 Nov - 5 Posts]

Re: Teradata connection through REXX. [Sun, 02 Jan - 2 Posts]

Teradata Connections Through .Net and SQL String [Wed, 16 Mar - One Post]

Teradata Create object implicit privileges [Wed, 03 Aug - 3 Posts]

Teradata Disaster Recovery setup [Thu, 07 Jul - 9 Posts]

Teradata Error 3706: expected something between [Thu, 03 Nov - 3 Posts]

Teradata Load Utilities [Tue, 11 Oct - 6 Posts]

Teradata locks - How to know if a table is locked [Tue, 11 Jan - 2 Posts]

Teradata Maximums for TD12 & TD13 [Tue, 25 Jan - 2 Posts]

Teradata ODBC client install on SUSE LINUX [Wed, 24 Aug - 7 Posts]

Teradata Parallel Transporter (TPT) NULLIF [Tue, 27 Sep - 3 Posts]

Teradata Parallel transporter- Regarding schema [Wed, 27 Jul - 2 Posts]

Teradata performance Stabilization [Mon, 31 Oct - 4 Posts]

Teradata Query Banding [Thu, 03 Nov - 2 Posts]

Teradata query Vs Oracle query [Fri, 11 Mar - 2 Posts]

Teradata Service not starting [Fri, 20 May - 4 Posts]

Teradata software installation problem [Thu, 25 Aug - 10 Posts]

Teradata SQL Assistant--Query Band [Fri, 19 Aug - 2 Posts]

Teradata testing [Mon, 09 May - 3 Posts]

Teradata upgrade to 13 from V2R6 [Wed, 23 Nov - 7 Posts]

Teradata Viewpoint setup [Thu, 27 Oct - 3 Posts]

Teradata XML Services - what about spatial? [Fri, 16 Dec - One Post]

Testing Large Teradata tables [Tue, 31 May - 2 Posts]

Testing the data on two different servers [Tue, 04 Oct - 2 Posts]

The "Group By" slows down the result in a query [Thu, 01 Dec - 7 Posts]

The schedule for Teradata Studio? [Fri, 16 Dec - 4 Posts]

Timestamp conversion to GMT [Thu, 08 Dec - 2 Posts]

TPT API Java interface? [Tue, 06 Sep - One Post]

TPT Error: syntax error at "cast" missing [Fri, 25 Feb - One Post]

TPT Launch date [Mon, 19 Sep - 2 Posts]

TPUMP script error: UTY1419 The field type is not allowed [Tue, 08 Feb - 7 Posts]

Trailing Spaces and BI tool [Fri, 04 Feb - 4 Posts]

Trailing spaces Issue [Tue, 25 Jan - 3 Posts]

TTU13 ODBC Issues RTRIM and LTIRM. [Fri, 21 Jan - 6 Posts]

Tune the query - giving spool space error [Fri, 07 Jan - 7 Posts]

Two Partitions in a table [Mon, 14 Feb - 2 Posts]



UDF for comparing CLOBs [Fri, 08 Apr - 3 Posts]

UDF-User defined Function [Tue, 12 Apr - 4 Posts]

Unable to logon with Authentication Mechanism [Tue, 12 Apr - 2 Posts]

Unable to store history in SQl assistant [Mon, 05 Dec - 4 Posts]

Unicode or Latin [Tue, 22 Mar - 4 Posts]

Unique syntax in sql {oj...} [Thu, 22 Dec - 2 Posts]

Unlocking a table in Teradata [Wed, 08 Jun - 3 Posts]

Update and commit [Tue, 26 Jul - 3 Posts]

UPDATE through a JOIN syntax [Thu, 15 Dec - 2 Posts]

Update, insert and upsert command in Fexport [Mon, 09 May - One Post]

Upgrading Veritas Netbackup by Symantec [Mon, 14 Nov - One Post]

UPI - Why it will not check for duplicates? [Mon, 17 Jan - 3 Posts]

Use case statement to select the desired table [Thu, 12 May - 9 Posts]

Use of Delete All on partitions [Fri, 04 Feb - One Post]

User Lockdown [Mon, 10 Jan - 2 Posts]

Using Array [Wed, 30 Mar - One Post]

Using FALLBACK when creating a table [Tue, 27 Sep - 2 Posts]

Using ODBC connection from informatica to load [Wed, 23 Feb - One Post]

Utility Info [Thu, 06 Jan - 12 Posts]

UTY4014 mload error: Invalid positioning data [Wed, 01 Jun - One Post]



Values input to a Macro [Mon, 17 Jan - 5 Posts]

Varying AMPCPUTime and TotalIOCount in DBQL [Tue, 22 Nov - 7 Posts]

Version 5 to 13: String contains untranslatable character [Mon, 28 Mar - 5 Posts]

View accesing while loading table process [Thu, 13 Jan - One Post]

Volatile Table and ON COMMIT DELETE ROWS [Mon, 18 Apr - 3 Posts]



What are the restrictions of a delete mload task [Fri, 18 Nov - 3 Posts]

What could improve response time but could also decrease throughput? [Tue, 27 Dec - 2 Posts]

What does it mean by open system? [Thu, 06 Jan - 2 Posts]

What is 2-phase commit? [Wed, 19 Jan - 3 Posts]

What is BIGDATA ? [Thu, 03 Nov - 2 Posts]

What is checksum=default [Mon, 17 Jan - One Post]

What is dataparcel? [Fri, 15 Jul - 9 Posts]

What is OCES-3? [Thu, 06 Jan - 2 Posts]

Where in syntax for tuples [Fri, 20 May - 4 Posts]

Which condition you have to use which API [Tue, 01 Feb - One Post]

Which query will be faster ? [Mon, 07 Feb - 4 Posts]

Why fastload doesn't allow duplicates [Mon, 10 Jan - 6 Posts]

Re: Why PI can not be unique if partition by column is not included in PI [Sun, 02 Jan - 2 Posts]

Work table during Multi load update and delete [Wed, 22 Jun - 4 Posts]

Wrong output [Tue, 12 Apr - One Post]






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