Home Page for the TeradataForum
 

 

Subject Index for 2012


 

The threads below were posted in the year 2012.


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.

 
<< 2011 2013 >>
 
 
 

3706: Syntax error [Wed, 12 Sep - 13 Posts]



A TPT with Load operator [Wed, 14 Nov - 5 Posts]

A user with 2 roles [Thu, 06 Sep - 3 Posts]

Access Logging - Impact on performance [Mon, 26 Nov - 6 Posts]

Actual size of CLOB fields [Thu, 15 Mar - 2 Posts]

Add a carriage return character in a string? [Thu, 22 Mar - 2 Posts]

add_months for integer-type dates [Thu, 20 Sep - 4 Posts]

Adding Compression - Redistributing data [Tue, 06 Nov - 2 Posts]

Adding intervals dynamically. [Sat, 11 Feb - 3 Posts]

Admin Comment: Apparent DOS Attack [Thu, 13 Sep - One Post]

AMP & DISK skewness during fastload [Thu, 31 May - One Post]

AMP CPU Skew Failures [Sat, 17 Nov - 3 Posts]

Announce: Teradata::SQL 0.10 [Sun, 01 Jan - One Post]

ARCMAIN warning with PPI tables [Fri, 18 May - 4 Posts]

Automatic Script to collect stats on index and defined columns [Wed, 18 Jul - 6 Posts]

Automation of Stats collection through Viewpoint [Fri, 13 Jan - One Post]

Avoiding Multiple Views [Thu, 06 Sep - 8 Posts]

AWT Run Out [Tue, 14 Aug - 8 Posts]



Backing up table before dropping [Mon, 02 Apr - 4 Posts]

Backup failure - ARC0805 [Thu, 06 Sep - 5 Posts]

BLC at table creation [Tue, 29 May - 5 Posts]

BTEQ EXPORT FILES [Tue, 14 Aug - 2 Posts]

BTEQ history [Thu, 01 Mar - 3 Posts]



Calling stored procedures and macros from Eclipse [Thu, 03 May - 3 Posts]

Can I activate a new TASM rule via SQL? [Wed, 05 Dec - 3 Posts]

Can we CALL more than one procedure in within macro...? [Tue, 28 Aug - 4 Posts]

Can we do partion by in timestamp(6) columns ? [Fri, 20 Jul - One Post]

Can't drop a range of rows [Fri, 07 Dec - 4 Posts]

Can't find AMP CPU, Delta CPU, Delta I/O, AMP I/O in TD Manager [Mon, 27 Feb - 2 Posts]

Carriage return character in a string [Sat, 29 Dec - 3 Posts]

Changing priority of a running query [Tue, 31 Jul - 4 Posts]

Changing table columns varchar (20) to varcahr [Fri, 20 Jul - One Post]

Changing Table Protection From No Fallback to [Tue, 06 Nov - 5 Posts]

Cnsrun with dumplocklog [Tue, 30 Oct - 8 Posts]

Codd's rules in teradata [Fri, 27 Jul - 4 Posts]

Collect stats inside a macro [Mon, 10 Dec - 3 Posts]

Collect stats on tables rather than columns [Mon, 23 Jul - 3 Posts]

Collect stats on VT in TD13.10 [Wed, 20 Jun - 4 Posts]

Collecting statistics on volatile table in [Thu, 19 Jul - 2 Posts]

Command to Check AMP condition [Mon, 26 Mar - 3 Posts]

Comparing Data between db2 and Teradata [Wed, 12 Dec - One Post]

Compress column with 2 values [Fri, 23 Mar - 3 Posts]

Compress Null value [Mon, 16 Jan - 12 Posts]

Compress Primary Key Columns [Tue, 24 Apr - 3 Posts]

Compress special characters - single quote [Thu, 08 Nov - 4 Posts]

Compression and the Optimizer [Wed, 10 Oct - 2 Posts]

Compression in Arcmain 13.1 [Tue, 06 Mar - 6 Posts]

Compression Process on Teradata 13.10 [Tue, 02 Oct - 21 Posts]

Computing 3rd Saturday of the month [Wed, 25 Jan - 8 Posts]

Concept of Index Only Scans in Teradata? [Tue, 07 Aug - 4 Posts]

Configuring Alerts on Manager Version 13.0 [Wed, 11 Apr - 7 Posts]

Connect R to Teradata [Wed, 05 Sep - 4 Posts]

Connect to Teradata from Visual Basic [Wed, 15 Aug - 2 Posts]

Connecting to new port [Sat, 25 Feb - 2 Posts]

Connection errors from host to TD Express 13.10 VMWare [Wed, 05 Dec - 9 Posts]

Connection problem [Thu, 18 Oct - 3 Posts]

Converting TIMEZONE data to Specific Region Time Value [Fri, 17 Feb - 6 Posts]

Converting to date format [Fri, 14 Dec - 5 Posts]

Copy data from backup [Wed, 29 Aug - 12 Posts]

Copy table across dev. and prod [Thu, 14 Jun - 2 Posts]

CPU skew processing a query [Sat, 29 Dec - One Post]

Create table and insert data within Stored [Wed, 29 Aug - 2 Posts]

Creating a new table by copying other table with a portion of data [Fri, 07 Dec - 8 Posts]

Creating a script with TPT Wizard [Mon, 19 Mar - One Post]

Creating Sequence Number In Table To Fix Amp Skew [Wed, 05 Dec - 8 Posts]

Cube, Rollup and Grouping sets [Tue, 11 Dec - 3 Posts]

Cursor In a Procedure - Compilation error [Wed, 20 Jun - One Post]

Cursor Inside a trigger [Fri, 15 Jun - 2 Posts]



Data collector Down Alert [Thu, 18 Oct - 3 Posts]

Data Migration From DB2 [Tue, 18 Sep - 3 Posts]

Data migrator blocking prod tables [Thu, 12 Apr - One Post]

Data movement using Data Mover [Fri, 23 Mar - One Post]

Data PULL when Teradata is the EDW [Fri, 16 Nov - 3 Posts]

Database performance daily reports [Thu, 31 May - One Post]

Database recovery [Mon, 24 Sep - 3 Posts]

Database space usage Alerts [Wed, 17 Oct - 9 Posts]

Datamodeling Teradata table definitions [Mon, 30 Apr - One Post]

Date conversion not working [Tue, 30 Oct - 9 Posts]

DATE Format 'YYDDD'? [Tue, 29 May - 5 Posts]

DB2 to Teradata [Wed, 18 Apr - 2 Posts]

Dbaseid and unknown creator [Wed, 04 Apr - 4 Posts]

DBC Tree View [Wed, 24 Oct - 10 Posts]

DBQL - CPUTIME and CPUTIMENORM [Mon, 02 Jul - 3 Posts]

DBQLSTEPTBL Logging [Fri, 14 Dec - 2 Posts]

DDL inside macro definition [Tue, 11 Dec - 4 Posts]

Debugging a procedure [Fri, 24 Feb - 7 Posts]

Debugging a Stored Procedure [Sat, 29 Dec - One Post]

Define stats on multiple columns on a GTT [Wed, 01 Aug - 2 Posts]

Delete and Insert based on Load flag [Tue, 03 Jan - 3 Posts]

Delete query based on target table date [Thu, 13 Dec - 5 Posts]

Delete/load or mload insert for missing update [Wed, 26 Sep - One Post]

Deleting records from DBC.TransientJournal table [Thu, 07 Jun - 6 Posts]

Deleting rows from a table which EXIST in another table [Tue, 18 Dec - 3 Posts]

Diff between Date in hours [Fri, 06 Apr - 2 Posts]

Difference between 3523 and 5315 [Sun, 09 Sep - 9 Posts]

Difference between BYNET and YNET? [Mon, 02 Apr - 2 Posts]

Difference between GROUP BY and DISTINCT in TD 14. [Fri, 20 Jul - 4 Posts]

Difference between TD 13.10 and TD 12? [Wed, 06 Jun - 3 Posts]

Difference in table creation. [Fri, 06 Apr - 4 Posts]

Different AMP CPU time on same query [Tue, 31 Jan - 4 Posts]

Dirty Read in teradata [Tue, 04 Dec - 4 Posts]

Display settings of DBS Control and xctl [Thu, 25 Oct - 2 Posts]

Distinct count in select & insert [Mon, 23 Jul - One Post]

Documentation on Teradata Optimizer [Tue, 24 Jan - 5 Posts]

Doubt with indexes [Mon, 26 Nov - 7 Posts]

DPE dosen't work when using EXTRACT function [Thu, 22 Mar - One Post]

Drop Table versus Delete All [Tue, 03 Apr - 3 Posts]

Dropping and creating secondary index in Mload [Tue, 17 Jan - One Post]

Dropping stats and collecting PI stats [Tue, 24 Jan - 2 Posts]

Dropping stats on indexes [Thu, 03 May - 4 Posts]

Duplicate to all amps [Tue, 21 Feb - 5 Posts]

Dynamic Result Sets [Tue, 24 Jul - 3 Posts]



Enable users: temporary password? [Fri, 17 Feb - 6 Posts]

Errlimit doesn't work with FASTLOAD... [Fri, 05 Oct - One Post]

Error - 3149:TDWM Filter violation for Query Request [Mon, 23 Jul - 6 Posts]

Error - 3504 :- Selected non-aggregate values must be part of the associated group. [Wed, 12 Sep - 8 Posts]

Error 2825: No record of the last request was [Thu, 19 Apr - One Post]

Error 3278: No Monitor Session available [Wed, 19 Sep - 6 Posts]

Error 5505 - Column data types cannot be specified [Fri, 14 Sep - 2 Posts]

Error 6706 [Wed, 11 Apr - 9 Posts]

Error in Modify the history data [Tue, 26 Jun - One Post]

Error in running a macro: INSERT Failed. [Tue, 31 Jan - 3 Posts]

Error in TPT Stream script [Wed, 04 Apr - 2 Posts]

Error loading data from DB2 through TPT using [Tue, 25 Sep - 2 Posts]

Error messages while launching TD SQL Assistant [Tue, 11 Sep - 2 Posts]

Error starting Teradata Express 14 on VMWare [Fri, 12 Oct - 3 Posts]

Error while accessing TERADATA using SAS [Mon, 02 Apr - 2 Posts]

Error while loading table using fastlaod [Thu, 19 Jan - 7 Posts]

Errors in Backup - BAM1206: Tivoli server aborted transaction [Mon, 16 Jan - 7 Posts]

ETL tool cannot update/insert data [Fri, 18 May - 4 Posts]

Excessive Stats [Wed, 21 Nov - One Post]

Executing query stored in a table through BTEQ [Tue, 21 Feb - 2 Posts]

Explain Plan differences between Static and Dynamic SQL [Mon, 25 Jun - 6 Posts]

Explanation for this blocked session: Artificial session [Sat, 21 Jan - 2 Posts]

Extracting a String From End [Mon, 30 Apr - 10 Posts]



Fast Export 2GB file Limit [Wed, 05 Sep - 11 Posts]

FastExport: Conversion issues with exported [Thu, 21 Jun - One Post]

Feedback for SQL Assistant Ver 13 [Tue, 14 Aug - 3 Posts]

Find record position for Fastload/Multiload error [Mon, 20 Feb - 4 Posts]

Find tables to run collect statistics [Thu, 15 Mar - 5 Posts]

Find the SQL running in the system [Tue, 13 Mar - 3 Posts]

Finding a dropped user [Thu, 12 Jul - 3 Posts]

Finding day of the week. [Sat, 10 Mar - 5 Posts]

FLOAD Locks [Thu, 15 Mar - 3 Posts]



Generate collect statistics statement [Thu, 12 Jan - 33 Posts]

Geoserver - servers enabling [Fri, 10 Feb - 2 Posts]

Geoserver and Monitor extension [Fri, 10 Feb - 3 Posts]

Grant & Role Issue [Fri, 19 Oct - 8 Posts]

Grant Abort Session [Thu, 25 Oct - 12 Posts]

Grouping the data and pulling the max value when different windows exist [Tue, 11 Sep - 3 Posts]



Help needed in writing SQL [Wed, 29 Aug - 3 Posts]

Help needed with Lead and Lag functions [Thu, 20 Dec - 3 Posts]

Help required in casting the date [Wed, 18 Apr - 6 Posts]

HELP TABLE output. [Wed, 18 Jul - 2 Posts]

Help with changed password [Mon, 23 Apr - 10 Posts]

Help with compression analysis [Wed, 25 Jul - 2 Posts]

HELP: SELECT failed. 3706: Syntax error [Thu, 22 Mar - 5 Posts]

History data Modification [Wed, 13 Jun - One Post]

How data in SPOOL distributed? [Mon, 04 Jun - 2 Posts]

How DISTINCT and GROUP BY have same performance in TD 14 [Tue, 06 Nov - 3 Posts]

How does Teradata work when merge join on MVC [Thu, 21 Jun - 4 Posts]

How Hashing algorithm works? [Thu, 05 Apr - 5 Posts]

How many parameters can be passeed in stored [Fri, 24 Aug - 2 Posts]

How records get hashed if PI value is NULL? [Wed, 21 Mar - 11 Posts]

How to ALTER GTT table from LOG to NO LOG [Wed, 14 Nov - 2 Posts]

How to calculate average endtime irrespective to run date [Mon, 22 Oct - 4 Posts]

How to call Stored procedures using Triggers [Thu, 19 Jul - 3 Posts]

How to CAST a number without getting a decimal point. [Tue, 17 Jan - 9 Posts]

How to change read source sequence limit in Multi Load [Thu, 06 Dec - 2 Posts]

How to clear the Orphan Access rights [Fri, 10 Feb - 8 Posts]

How to compress timestamp type [Wed, 09 May - 10 Posts]

How to Convert a VARCHAR date into TIMESTAMP(0) format [Fri, 26 Oct - 9 Posts]

How to copy database tables [Mon, 21 May - 3 Posts]

How to copy table containing identity column? [Mon, 10 Dec - 5 Posts]

How to delete special characters in a string [Thu, 12 Jul - 7 Posts]

How to deploy sdk portlet on to production viewpoint [Mon, 23 Jul - One Post]

How to Deploy UDF in Teradata [Sun, 03 Jun - 6 Posts]

How to disable retry in Fast Export [Thu, 06 Dec - One Post]

How to do an collect stats on more than one [Mon, 01 Oct - 4 Posts]

How to Do NsLookup [Tue, 20 Mar - 7 Posts]

How to Enable Resusage tables? [Tue, 20 Nov - 6 Posts]

How to Exit SQL-A? [Thu, 13 Sep - 2 Posts]

How to find Chinese character in string? [Fri, 09 Nov - 2 Posts]

How to find column is nullable or not nullable [Wed, 24 Oct - 2 Posts]

How to find data type and nullability [Fri, 19 Oct - 5 Posts]

How to find duplicate record [Wed, 28 Mar - 11 Posts]

How to generate Surrogate Key using CSUM? [Wed, 07 Nov - 12 Posts]

How to get the IP address of the TD machine [Mon, 05 Mar - 9 Posts]

How to Identify UNUSED STATS on a table? [Tue, 06 Nov - 16 Posts]

How to install DBD:Teradata on Perl64 [Sun, 07 Oct - One Post]

How to install ODBC driver on Solaris not in [Thu, 30 Aug - One Post]

How to know the Aborted Session Details [Mon, 04 Jun - 4 Posts]

How to load Hexadecimal data [Tue, 27 Nov - 4 Posts]

How to look-up a table locked by Fastload [Mon, 31 Dec - One Post]

How to map WDID with Workload Description [Sat, 02 Jun - 7 Posts]

How to move a session from Delayed state to [Tue, 16 Oct - 4 Posts]

How to remove dot (decimal) from exported file [Tue, 06 Nov - 5 Posts]

How to replace with null if date is invalid [Tue, 21 Aug - 10 Posts]

How to restart Fload and Mload [Fri, 06 Jul - 5 Posts]

How to ROLLBACK a successful transaction [Tue, 27 Nov - 5 Posts]

How to run Update statement faster [Tue, 26 Jun - 4 Posts]

How to shell variable inside a bteq script? [Fri, 27 Jan - 4 Posts]

How to split full name to first,middle & last [Mon, 16 Jul - 8 Posts]

How to uniquely access a row? [Thu, 02 Aug - 2 Posts]

How to write ERWin macro to support compress? [Wed, 19 Sep - 6 Posts]



I/O, CPU and AMP SKEW [Sat, 29 Dec - 7 Posts]

Icons in Teradata PMON [Thu, 03 May - 3 Posts]

Ideal TPUMP Sessions [Thu, 29 Nov - 6 Posts]

Identifying empty views, or conditions, that make the query fruitless [Thu, 26 Jan - One Post]

Impact on spool between SELECT TOP and with ORDER BY [Thu, 07 Jun - 3 Posts]

Improving the performance of a minus query [Fri, 06 Jan - 4 Posts]

IN Vs = [Equality] [Tue, 22 May - 3 Posts]

In where condition 'not' and 'and is not working together [Mon, 24 Sep - 7 Posts]

Inactive sessions aborted via TASM [Fri, 07 Dec - 3 Posts]

Increase a column length [Wed, 14 Nov - 2 Posts]

Increase/decrease packet size in TPUMP [Thu, 15 Mar - 2 Posts]

Index Best Practices for Dimension Model Data? [Thu, 14 Jun - 3 Posts]

Indexes on Timestamp Columns [Mon, 20 Feb - 2 Posts]

Informatica and Mload Errors [Wed, 24 Oct - 2 Posts]

Insert a large varchar field into a clob or st_geometry field [Fri, 11 May - 3 Posts]

Insert Char values in column defined as Integer [Wed, 12 Sep - 4 Posts]

Insert into table with same select is too slow [Mon, 16 Jul - 10 Posts]

Insert statement starts OK but then slows down [Wed, 18 Jul - 18 Posts]

Insert When [Wed, 07 Mar - 4 Posts]

Installation of TD Express for VMware Player [Fri, 04 May - 11 Posts]

Intermittent - Numeric value out of range: Teradata ODBC problem [Sat, 21 Jul - One Post]

Is there a difference between these CT's [Sat, 21 Jul - 2 Posts]

Is there a way to find the number of a table [Thu, 28 Jun - 4 Posts]

Issue getting a rank [Thu, 12 Jan - 2 Posts]



JDBC Parameterized Query -- Cache hit Ratio [Thu, 08 Nov - One Post]

Joining TIMESTAMP vs DATE [Wed, 04 Apr - 2 Posts]



Last Access Timestamp and Archive [Tue, 03 Apr - One Post]

Last operation on a database object [Wed, 30 May - 3 Posts]

Lenth of String without using Lengh functions [Fri, 16 Mar - 5 Posts]

Libpm.dll is missing [Mon, 12 Mar - 5 Posts]

Like keyword issues with % [Wed, 07 Mar - 7 Posts]

Limitations of WHILE loop in Stored Procedures [Mon, 06 Aug - One Post]

LIST ROLLBACK TABLES; [Wed, 11 Jan - 11 Posts]

Load Balancing on report query [Tue, 08 May - 5 Posts]

Load Oracle EXPORTS binary output to Teradata [Thu, 19 Jul - One Post]

Loading Special Characters [Tue, 05 Jun - 4 Posts]

Locking within views [Fri, 16 Mar - 2 Posts]

LOG / NO LOG in GTT and VT [Mon, 12 Nov - 2 Posts]

Login with several nodes [Fri, 03 Feb - 3 Posts]

Logon time interpretation [Thu, 15 Mar - 5 Posts]



Macro - String Parsing [Thu, 09 Feb - 2 Posts]

Macros vs Stored Procedures for DML statements only [Wed, 30 May - 2 Posts]

Materialized view and view [Fri, 27 Jul - 3 Posts]

Max Vdisk size in TD 14 [Fri, 02 Nov - One Post]

Maximum columns in TPT [Fri, 24 Aug - 2 Posts]

Maximum number of foreign key in a table in Teradata? [Thu, 27 Dec - 6 Posts]

MDS and Automatic DIM Updates [Mon, 13 Aug - One Post]

Meaning of Translate word in Explain plan [Thu, 19 Jul - One Post]

Memory settings in TPT script [Thu, 11 Oct - One Post]

Migrating from 13.0 to 13.10 [Mon, 24 Sep - One Post]

Migration of Oracle to Teradtaa [Sat, 21 Apr - 3 Posts]

Minimum number of sessions [Tue, 22 May - 3 Posts]

Missing a setting here ..can't recollect what [Mon, 09 Jan - 9 Posts]

Missing space in the Database [Fri, 16 Mar - 6 Posts]

Mload layout in unix [Tue, 21 Aug - 5 Posts]

Mload loading junk value [Wed, 15 Feb - One Post]

Mload sessions are going into IDLE [Fri, 13 Jan - One Post]

More than one User Profile [Thu, 16 Aug - 8 Posts]

Moving data from Oracle and SQL Server to [Wed, 04 Jan - 2 Posts]

MQ Websphere connection to Teradata [Mon, 24 Sep - 2 Posts]

Multi-column statistics and truncation [Thu, 31 May - One Post]

Mutli-Column Stats [Tue, 24 Apr - 6 Posts]

MVC and Presence bits [Fri, 03 Feb - 2 Posts]



Name of Hashing algorithm [Thu, 05 Apr - One Post]

Need best practise information [Thu, 27 Dec - One Post]

Need Help with Perfomace Issue [Thu, 11 Oct - 3 Posts]

Need help with Stored Procedure: SELECT INTO clause [Tue, 09 Oct - 2 Posts]

Need to transpose a column to Row [Tue, 09 Oct - 4 Posts]

Netbackup Email set up [Wed, 12 Dec - One Post]

New reserved keywords in Teradata Version 13.0? [Thu, 12 Apr - 5 Posts]

New Users not in DBC.LOGONRULES table [Fri, 16 Mar - 4 Posts]

No more room in the Journal table [Thu, 30 Aug - 8 Posts]

No. of AMPs in a NODE [Thu, 22 Nov - 6 Posts]

NODE Downsizing Tasks [Tue, 28 Aug - 2 Posts]

Not getting email notification [Fri, 27 Jan - 2 Posts]

Number of times a string appears in a sentence [Wed, 22 Aug - 4 Posts]

Numeric overflow while doing UNION [Fri, 26 Oct - 5 Posts]



OLEDB_AXSMOD error on FastLoad script [Fri, 20 Jan - 2 Posts]

OLELOAD and XML [Tue, 10 Jul - One Post]

OLELOAD: 2008 SQL Server to Teradata [Mon, 02 Jul - 2 Posts]

Order by Hash? [Thu, 17 May - 3 Posts]

OREPLACE : Special Characters [Fri, 06 Jul - 3 Posts]

OS in which TD work [Thu, 11 Oct - 5 Posts]

OVERLAPS question [Mon, 29 Oct - 6 Posts]



Parallel Efficiency [Thu, 11 Oct - 12 Posts]

Parameter name missing [Fri, 11 May - 4 Posts]

Partitioning on different column to PI [Thu, 08 Mar - 10 Posts]

Partitioning startegy for 1.2 Terabytes [Wed, 25 Apr - One Post]

PDCRDATA Clean up [Thu, 27 Dec - One Post]

PE plan for join [Fri, 27 Jul - 3 Posts]

Perf Issues in Empty partition Scan [Tue, 18 Dec - 3 Posts]

Performance between development and production systems [Thu, 17 May - 11 Posts]

Performance difference between IN and NOT IN [Tue, 26 Jun - One Post]

Performance Metrics: What explains this kind of observation? [Wed, 25 Jan - 4 Posts]

Performance Queries [Tue, 03 Apr - One Post]

Perl with TD 14 on Linux [Tue, 21 Feb - 2 Posts]

Permanent Jounal questions [Tue, 28 Feb - One Post]

Permanent journal [Mon, 27 Aug - 3 Posts]

Permissions at line level [Mon, 09 Jan - One Post]

Point in time Recovery [Tue, 13 Mar - 2 Posts]

Possible range of data skew [Tue, 10 Apr - 3 Posts]

Preparing for Suse Linux [Mon, 09 Jan - 3 Posts]

Primary and HSN [Sat, 30 Sep - 9 Posts]

Problem with Alias in Teradata 14 [Thu, 06 Sep - 2 Posts]

Procedure for updating the part of the string [Mon, 02 Jul - 2 Posts]

Pseudo table lock? [Wed, 16 May - 4 Posts]

Purpose of TRANSLATE command? [Sat, 21 Jul - 3 Posts]



Query consuming high spool [Thu, 12 Jul - One Post]

Query Count & Resource usage data collectors not working. [Tue, 10 Jul - 2 Posts]

Query is slower in SQL Assistant compared to batch? [Tue, 26 Jun - 2 Posts]

Query on NUSI [Fri, 02 Nov - 5 Posts]

Query on Teradata Amp and PE [Fri, 14 Dec - 5 Posts]

Query performance issue - running long [Wed, 19 Sep - 6 Posts]

Query related Fastload [Thu, 05 Jul - 2 Posts]

Query to compare columns [Fri, 30 Mar - 5 Posts]

Query to pull users last login date [Mon, 01 Oct - 5 Posts]

Question on IO traffic origin from/to [Mon, 05 Nov - One Post]

Question on Permanant Journals [Wed, 26 Dec - 3 Posts]

Question on soft "RI" in Teradata [Wed, 31 Oct - 5 Posts]



R Functions & Teradata [Mon, 10 Sep - One Post]

Recommendation on Table Lock [Mon, 02 Jul - 3 Posts]

Record position for error record in Fastload [Sat, 04 Feb - 2 Posts]

RedHat Linux 5 Teradata ODBC 13 connectivity [Tue, 21 Feb - 4 Posts]

Redistribution when doing RANK() OVER on PI [Thu, 03 May - 4 Posts]

Reduce the likelihood of a Full Table Scan [Thu, 03 May - 4 Posts]

Referential Integrity in Teradata [Fri, 13 Jan - 4 Posts]

Regarding Residual condition [Thu, 29 Mar - 5 Posts]

Regarding stale stats [Wed, 29 Feb - 2 Posts]

Regarding Table creation with PPI [Mon, 23 Jul - 2 Posts]

Regular Maintainence Utilities [Fri, 30 Mar - One Post]

Releasing mload pending from a table [Tue, 17 Jul - 3 Posts]

Removing duplicates in Multiset table [Thu, 02 Aug - 8 Posts]

Removing Junk characters [Mon, 19 Mar - 2 Posts]

Rename Role name [Tue, 28 Aug - 2 Posts]

Replace UDF failing with syntax error. [Thu, 19 Jul - 3 Posts]

Resolving AMP CPU Skew Error [Fri, 21 Dec - 7 Posts]

Restart Netvault backup [Fri, 06 Apr - 4 Posts]

Restoring deleted rows [Tue, 29 May - 4 Posts]

Restrcting the Access to PMON or TD Manager [Fri, 13 Jan - 6 Posts]

Restricting concurrent sessions using throttles in TASM [Sat, 08 Dec - 6 Posts]

Restriction on Space Movement [Tue, 27 Nov - 5 Posts]

Retrieve next 50 rows after reference value [Fri, 24 Feb - 3 Posts]

Rolforward to checkpoint from a Journal [Fri, 21 Sep - 11 Posts]

Rollforward and Rollback using Permanent Journal [Thu, 21 Jun - One Post]

Row Hash Lock [Tue, 27 Nov - 2 Posts]

Running-out of DBC Space [Thu, 26 Jan - 12 Posts]



SAP-BW Cubes to Teradata [Wed, 05 Sep - One Post]

Script stops after OREPLACE function [Fri, 29 Jun - 4 Posts]

Second minimum date [Wed, 28 Mar - 5 Posts]

Security features at Teradata [Fri, 07 Sep - One Post]

Select 'col1'N [Thu, 13 Sep - 3 Posts]

Select records with valid values except the key field [Mon, 16 Jul - 9 Posts]

Select statement not throwing error [Mon, 20 Aug - 4 Posts]

Selecting a part of a table [Wed, 05 Dec - 7 Posts]

Sending Teradata Manager Alerts using Lotus Notes [Thu, 08 Mar - One Post]

Separation of duties between DBA and Developer [Fri, 16 Mar - 8 Posts]

Separator in Mload [Mon, 20 Aug - 4 Posts]

Serialize CLOB [Tue, 03 Jan - 2 Posts]

Session in responding state [Thu, 13 Dec - 2 Posts]

Sessions in PMON [Tue, 02 Oct - 2 Posts]

SET ERRORLEVEL 3803 SEVERITY 0 - not working with GTT [Wed, 27 Jun - One Post]

SET table with UPI [Fri, 30 Nov - 9 Posts]

Shared nothing architecture for SMP and MPP [Wed, 18 Apr - 3 Posts]

SHOW previlege [Fri, 06 Jul - 2 Posts]

Slow changing dimension [Tue, 20 Mar - 3 Posts]

Solutions to Data Skewing [Sat, 14 Jan - 4 Posts]

Space occupied by blanks [Wed, 23 May - 4 Posts]

Space Utilization report on a tabular format [Mon, 03 Dec - 2 Posts]

Spaces in Varchar [Wed, 09 May - 2 Posts]

Split the time into regular intervals [Fri, 30 Mar - 2 Posts]

Spool Out when not using order by clause [Tue, 05 Jun - One Post]

SPOOL Space for each logon id [Thu, 07 Jun - 3 Posts]

SQL Assistant history file questions [Tue, 29 May - 3 Posts]

SQL Assistant v 13.10.0.05 taking minutes to open [Thu, 25 Oct - 2 Posts]

SQL Assistant Version 13 - Error 3932 [Thu, 30 Aug - 7 Posts]

Start of Responding state [Thu, 05 Apr - 3 Posts]

Starting view point through browser [Fri, 14 Dec - 9 Posts]

Stop Ferret from supvr in Database Window [Fri, 28 Dec - 3 Posts]

Store procedure update [Fri, 30 Mar - One Post]

Stored Procedure: SELECT INTO clause [Fri, 05 Oct - 2 Posts]

Re: Stored Procedures - Cursor Processing [Thu, 23 Feb - 14 Posts]

Stress testing [Tue, 02 Oct - 4 Posts]

String extraction in teradata [Thu, 12 Apr - 6 Posts]

Substr from right on decimal number [Fri, 06 Apr - 3 Posts]

Subtables for FLOAD [Thu, 15 Mar - 2 Posts]

Subtraction between dates [Fri, 02 Nov - 8 Posts]

Support for Windows 7 [Mon, 16 Apr - 5 Posts]

Surrogate key is defined on the index column [Thu, 03 May - 2 Posts]

SYSDBA password reset [Mon, 24 Sep - 6 Posts]

System clock change [Tue, 25 Sep - One Post]

SYSUDTLIB Access to Users [Wed, 26 Dec - 2 Posts]



Table Locking [Fri, 14 Sep - 2 Posts]

Table skewed on load [Tue, 10 Jan - 2 Posts]

Tables Data comparison [Wed, 06 Jun - 4 Posts]

Tables left in load status [Fri, 24 Feb - 4 Posts]

Tables not access/updated in past 90+ days [Wed, 04 Jul - 6 Posts]

TASM Throttle [Fri, 01 Jun - 4 Posts]

TBIO-OLAP cube issues [Fri, 23 Mar - One Post]

TD 14: Metaphone [Thu, 06 Dec - One Post]

TDWM Database version does not match the Teradata version for the system [Thu, 06 Dec - 6 Posts]

Temp Space in Bteq [Thu, 02 Aug - 2 Posts]

Tenacity and Fastload/Multiload [Thu, 07 Jun - 7 Posts]

Teradata 12 Basic Certification help [Fri, 27 Jul - One Post]

Teradata 13 certification [Fri, 11 May - 4 Posts]

Teradata Alert for Database space [Tue, 02 Oct - 4 Posts]

Teradata and Cloud computing [Wed, 28 Nov - One Post]

Teradata Database hash fuction [Fri, 01 Jun - 2 Posts]

Teradata Hashing and MD5 hashing for CDC [Tue, 10 Jul - 2 Posts]

Teradata macro or sp to create the mload scripts [Tue, 07 Aug - 3 Posts]

Teradata Manager Alert Setup questions [Fri, 23 Mar - One Post]

Teradata Manager Setup email Alerts [Wed, 08 Aug - 4 Posts]

Teradata Parallel Transporter Installation [Tue, 11 Dec - 13 Posts]

Teradata Provided Scheduling Tools [Mon, 17 Dec - 6 Posts]

Teradata reserved words by release [Tue, 01 May - 3 Posts]

Teradata Resource Planning Guidlines [Wed, 19 Dec - 2 Posts]

Teradata Security with Active Directory [Tue, 15 May - 2 Posts]

Teradata Server Logs [Thu, 08 Nov - 4 Posts]

Teradata Server Migration Without BAR [Fri, 12 Oct - 8 Posts]

Teradata View point - Demo version [Fri, 11 May - 7 Posts]

Teradata Viewpoint Portlets [Wed, 04 Apr - 10 Posts]

Teradata Warehouse Builder [Fri, 07 Dec - 3 Posts]

The string contains an untranslatable character. [Sun, 10 Jun - 3 Posts]

Time out error with PPI [Wed, 30 May - 2 Posts]

To create a journal table [Thu, 06 Sep - 2 Posts]

To extract certain DATE-TIMESTAMP [Wed, 29 Feb - 4 Posts]

To find the CPU Usage of the system [Mon, 13 Mar - 7 Posts]

TPT - Filter condition. [Sun, 09 Dec - 2 Posts]

TPT error: TPT 19404 pmopen failed [Sat, 21 Jul - One Post]

TPT Exporter operator usage for pipe delimeter file. [Tue, 22 May - 3 Posts]

TPT script: Query ends within a string or comment block [Mon, 09 Apr - 5 Posts]

Tpump and Date Format [Sun, 18 Nov - 2 Posts]

TPUMP DBS Wait Time [Tue, 20 Nov - One Post]

Tpump jobs not getting logged in TPUMPSTATUS [Mon, 03 Dec - One Post]

TPUMP running very very slow [Fri, 16 Nov - 4 Posts]

Tracking DML operations in Teradata [Thu, 21 Jun - 5 Posts]

Trail versions of Mload and FastLoad [Thu, 14 Jun - 2 Posts]

Troubleshooting AMP CPU SKEW [Thu, 12 Apr - 8 Posts]

Truncation of character string while insert [Sun, 16 Dec - 3 Posts]

Trusted sessions setup help [Thu, 07 Jun - 2 Posts]

TTU 13.1 & TTU14 on same server [Wed, 01 Aug - 3 Posts]

TTU14 Assessment with TD13.10 [Mon, 05 Mar - 2 Posts]

Two logon variables [Fri, 20 Jan - 6 Posts]



UDF to extract Varbyte to various formats [Fri, 06 Apr - 2 Posts]

Unable to Login to TD Manager [Thu, 26 Jan - 5 Posts]

Unblock a table [Mon, 27 Feb - 2 Posts]

Unique index vs. primary index [Tue, 24 Jan - 5 Posts]

Update fails but select works with same [Tue, 18 Sep - 3 Posts]

Upgrade to sqla14 express [Mon, 12 Mar - 3 Posts]

UPI with some columns combination and PI with 1 or 2 column [Tue, 17 Jul - 3 Posts]

Use of Negative Values Instead of NULL [Thu, 19 Apr - 6 Posts]

Use of Union with literals [Fri, 03 Feb - 9 Posts]

User Information in Teradata [Fri, 24 Aug - 7 Posts]

Users access not getting revoked! [Thu, 25 Oct - 2 Posts]

Users Session limit change settings [Tue, 15 May - 2 Posts]

Using a date variable in BTEQ [Tue, 19 Jun - 4 Posts]

Using COPY command to copy tables [Thu, 02 Aug - 9 Posts]

Using ErrorCode and ActivityCount within Bteq [Wed, 16 May - 9 Posts]

Using Partition backup for multiple specific [Wed, 25 Jul - 3 Posts]

Using QCD? [Fri, 20 Apr - 2 Posts]

Using results returned from a Stored Procedure [Fri, 14 Dec - 3 Posts]



Valid trailing spaces in key values [Thu, 23 Feb - 3 Posts]

VALUE IN a QUERY IS NOT valid [Thu, 01 Mar - 5 Posts]

Varchar (255) VS varchar (256) in Teradata [Fri, 13 Apr - 2 Posts]

Variable name for a new or existing table? [Tue, 24 Apr - 2 Posts]

View point issue [Mon, 30 Jan - 11 Posts]

View Point Server Root Password not working! [Tue, 28 Nov - 3 Posts]

Viewpoint - TASM State matrix [Fri, 30 Nov - 5 Posts]

Viewpoint Alert - Data collector Down [Sun, 26 Nov - 2 Posts]

Viewpoint smtp test failed [Wed, 08 Feb - 4 Posts]

ViewPoint Vs Teradata Multi Sytem Manger [Thu, 12 Jan - 2 Posts]

VM player for Teradata express 13.10 VM [Thu, 29 Nov - 5 Posts]

Volatile table in TD 13.10 [Mon, 10 Dec - One Post]

Volatile tables within Stored Procedures [Tue, 03 Apr - 2 Posts]



What does COMMIT option and TRANSACTION flag [Wed, 18 Jul - 2 Posts]

What does COMPRESS NULL actually do? [Fri, 27 Jan - 2 Posts]

What does TOP actually mean? [Fri, 20 Jul - 8 Posts]

What exactly a SESSION means? [Wed, 22 Aug - 7 Posts]

What happens when a new node is added [Fri, 02 Nov - 7 Posts]

What is a Change data capture (CDC) concept [Wed, 01 Aug - 2 Posts]

What is column fieldstatistics in [Wed, 30 May - 4 Posts]

What is difference between Sample 10 and Top 10? [Tue, 29 May - 7 Posts]

What is Logon Source [Thu, 31 May - 5 Posts]

What is Patition Ellimination [Mon, 19 Nov - 3 Posts]

What is the difference between start/snowflake schema and Fsldm? [Fri, 27 Jul - 3 Posts]

What is the purpose of PARTITION BY CASE_N [Mon, 09 Jan - 2 Posts]

What is the use of LIKE operator for char fields [Wed, 14 Nov - 6 Posts]

What is TPT [Mon, 19 Mar - 5 Posts]

What makes an AMP go Down [Mon, 20 Aug - 5 Posts]

What type of lock will apply for Collect stats [Mon, 01 Oct - One Post]

What will happen is a vdisk is FULL [Thu, 01 Nov - 4 Posts]

When to recollect stats? [Fri, 13 Jan - 3 Posts]

Where NULL values will store while joining [Fri, 01 Jun - 3 Posts]

Which has better performance? [Wed, 11 Jul - 2 Posts]

Why a Query with Huge IN List Fails [Wed, 30 May - 4 Posts]

Why does size of table increase in multiples of 512 bytes [Tue, 24 Jan - 11 Posts]

Why IBM Mainframe giving MAx RC 4095 [Wed, 13 Jun - 2 Posts]

Why incorrect stats are worse than not collecting stats? [Thu, 31 May - 7 Posts]

Why would GROUP BY decrease spool [Tue, 01 May - One Post]






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