Home Page for the TeradataForum
 

 

Subject Index for 2014


 

The threads below were posted in the year 2014.


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.

 
<< 2013 2015 >>
 
 
 

1:1 Views - Sel * from Table OR SELECT all columns from table [Mon, 03 Feb - 13 Posts]



Abnormal behavior of query in TD14.10 after upgrade from TD14 [Fri, 02 May - 7 Posts]

ABORT sessions in ABORTING PHASE for more than 2hrs [Fri, 04 Apr - 5 Posts]

Accessrights reporting macros - updated for Teradata 15.00 [Thu, 22 May - 4 Posts]

Activity count of select statement in Stored procedure [Fri, 24 Jan - 6 Posts]

Add new columns in a existing table after [Tue, 25 Mar - 6 Posts]

Admin Comment: Migrating TeradataForum Server [Wed, 05 Feb - 4 Posts]

Admin Comment: Migration of the TeradataForum [Thu, 05 Jun - One Post]

ALTER PROCEDURE COMPILE [Tue, 13 May - 2 Posts]

An error in SQL to find top bad queries [Fri, 11 Apr - 7 Posts]

Arabic data and session character set [Mon, 17 Mar - 14 Posts]

Array Privileges [Tue, 22 Apr - One Post]

ARRAY reference in a Stored Procedure [Wed, 09 Apr - 3 Posts]

At what times the DBS control settings turn default [Thu, 17 Apr - 3 Posts]

AutoStats feature of TD 14 [Sun, 23 Nov - 2 Posts]



BACKUP Session blocking in ONLINE MODE [Tue, 28 Jan - 6 Posts]

BAR server, TARA and NetBackup GUI [Fri, 18 Apr - 2 Posts]

Best way to move data between systems blocked by firewall [Tue, 16 Sep - 5 Posts]



Call failed when changing the Charset [Thu, 27 Feb - One Post]

Can virtual IP be used instead hardcoded IP? [Tue, 28 Oct - 4 Posts]

Can we include the new database which was not in [Thu, 20 Mar - One Post]

Can't connect PDCR to ODBC [Fri, 14 Mar - One Post]

Checktable commands [Mon, 24 Feb - 4 Posts]

Collecting LogonSource information [Fri, 07 Mar - 5 Posts]

Column length overflow error [Wed, 10 Sep - One Post]

Columnar - real world example [Sat, 17 May - 2 Posts]

Comment on SQL Assistant [Thu, 10 Apr - 5 Posts]

Configure alert rule only if the network busy [Thu, 08 May - One Post]

Creating a new event in ViewPoint [Mon, 31 Mar - 2 Posts]

Creating Archive and Copy job using TARA [Mon, 03 Mar - 6 Posts]

Croning the backup script [Thu, 16 Jan - One Post]



Databackup Encryption [Tue, 19 Aug - 4 Posts]

Database access rights macros: AllDatabaseRights & AllUserRights [Tue, 17 Jun - 4 Posts]

DBQL queryband column population for individual stored procedure DML statements [Fri, 28 Feb - 3 Posts]

Default role [Wed, 23 Apr - 5 Posts]

Dictionay archive and Restore [Thu, 30 Oct - 3 Posts]

Disable a cron job [Tue, 22 Apr - 2 Posts]

Divison issue when using 64 bit datatype int64_t for signed values [Tue, 04 Mar - 7 Posts]

Do FASTEXPORT work with datatypes data and number? [Wed, 03 Dec - 2 Posts]

Does TERADATA support Fact and Dimensional Modeling [Thu, 30 Oct - 5 Posts]

Duplicate unique prime key error encountered for ODBC Teradata Session Mode [Thu, 05 Jun - 2 Posts]



Efficient Delete in Teradata [Fri, 05 Sep - 3 Posts]

Encryption Techniques in Teradata 13.10 [Mon, 14 Jul - 6 Posts]

Error 3798 while executing SP using CLOB variable [Fri, 21 Feb - One Post]

Error for procedure with character UTF8 [Wed, 26 Feb - One Post]



FastExport error while using BTEQ .IMPORT command [Fri, 17 Oct - 4 Posts]

Fastexport Question (Mainframes) [Wed, 16 Apr - 2 Posts]

Find users not logged since > 3 months [Wed, 10 Sep - 5 Posts]

Find who inserted records to a table [Tue, 25 Feb - 2 Posts]

FSLDM - Event [Mon, 11 Aug - 7 Posts]



Getting a warning before Merge Sql [Wed, 25 Jun - 2 Posts]



Hard Disks space capacity [Thu, 21 Aug - 6 Posts]

History table of table change [Wed, 29 Jan - 7 Posts]

Hot stand by node? [Sun, 03 Aug - One Post]

How many physical disks make one virtual disk? [Wed, 16 Apr - 2 Posts]

How to calculate the space consumed by Secondary index [Thu, 26 Jun - 7 Posts]

How to configure/receive VIEWPOINT ALERTS ON our MOBILE SMS. [Wed, 17 Sep - 2 Posts]

How to delete Duplicate Rows from Multiset tables [Sat, 12 Jul - 6 Posts]

How to do Data Encrytion [Tue, 05 Aug - One Post]

How to get complete SQL by Combining DBQLSQLTBL and DBQLOGTBL [Wed, 04 Jun - 7 Posts]

How to get lost access on Object level [Wed, 11 Jun - 2 Posts]

How to Identify Partitioned Columns [Wed, 14 May - 3 Posts]

How to load Clob Field Type into Teradata13.1 by BTEQ [Tue, 04 Nov - 3 Posts]

How to modify DDL when UPI is on IDENTITY COLUMN & RI imposed [Thu, 26 Jun - 4 Posts]

How to monitor packdisk [Mon, 26 May - One Post]

How to populate Row values to column wise [Sat, 12 Jul - 4 Posts]

How to sync the time lag between java application time and node OS time [Sat, 08 Nov - 2 Posts]



Inefficient LEFT JOIN execution plan [Tue, 28 Jan - 5 Posts]

Informatica 9.5.1 and TTU 14.10 [Wed, 18 Jun - 2 Posts]

Inputs in 'IN' Clause [Fri, 11 Jul - 5 Posts]

Inserts Locks and Queue Tables [Wed, 23 Apr - 8 Posts]

Is cron job better or a script that runs in background having sleep [Sat, 25 Oct - 3 Posts]

Is MVC and PI analysis on small tables matters? [Thu, 06 Mar - 2 Posts]

Is OREPLACE always case sensitive [Tue, 04 Feb - 3 Posts]



Join Index created with ROWID is not used [Wed, 29 Jan - 2 Posts]

Junk characters in TSQL query output [Thu, 08 May - One Post]



Left Join leading to product Join [Tue, 26 Aug - 8 Posts]

Limitations while running upsert [Fri, 21 Mar - 2 Posts]

Locking particular Columns from table [Tue, 05 Aug - 5 Posts]

Logging of user creation/deletion [Thu, 09 Oct - 4 Posts]



Macro/Formulae to get DDL's and counts of all [Fri, 21 Nov - 2 Posts]

Max. Table and Column length in Teradata [Tue, 12 Aug - 4 Posts]

Maximum limit for Teradata identity column in [Tue, 19 Aug - 3 Posts]

Missing/Required Access Rights [Wed, 04 Jun - 3 Posts]

MLoad Error: "6996: Invalid conversion or assignment operation on a Period" [Wed, 29 Jan - 8 Posts]

MVC Query [Tue, 01 Apr - 4 Posts]



Need help on SQL Logic [Fri, 24 Jan - One Post]

Not enough Information to log in [Sat, 08 Mar - 6 Posts]

NULL values in the ObjectColumnName field of DBC's DBQLObjH [Wed, 05 Feb - 4 Posts]

Number of roles per user [Wed, 14 May - 3 Posts]

Number of sessions for Archive job granted by TASM [Mon, 27 Oct - 4 Posts]



ODBC Teradata Driver - Memory management [Wed, 09 Apr - One Post]

ONLY Direct access rights assigned to users in Teradata [Thu, 06 Nov - 2 Posts]



Perl DBI - Use of uninitialized value in concatenation (.) or string [Tue, 09 Dec - One Post]

Prism field trial users wanted [Tue, 17 Jun - One Post]

Problem while deploying set of views [Thu, 18 Sep - 12 Posts]

Problem with IDENTITY Column [Mon, 07 Apr - 7 Posts]

Procedure to set up PACKDISK utility on database node [Wed, 16 Apr - 12 Posts]



Queries on DBQL tables running into Parsing State [Mon, 17 Nov - 8 Posts]

Query to find Backup tables [Tue, 30 Dec - 3 Posts]

Query to find unused stats in TD 14.00 [Thu, 27 Mar - 2 Posts]

Query tuning - How to handle casting in Joins [Wed, 12 Nov - 2 Posts]

Query which runs in SQLA but not working at BTEQ [Mon, 01 Sep - 4 Posts]

Question on joining UPI with non unique SI [Fri, 31 Jan - 4 Posts]

Question on Trigger. [Mon, 28 Jul - 3 Posts]

Re: Queue Tables [Thu, 02 Jan - 9 Posts]



Recommended MaxParseTreeSegs parameter value [Fri, 31 Jan - 7 Posts]

Regarding Block Level Compression [Mon, 22 Sep - 2 Posts]

Replace string in teradata [Tue, 02 Sep - 7 Posts]

Restore / Copy DDL across systems but not data [Thu, 26 Jun - 5 Posts]

Restoring data between two systems with different patch levels. [Wed, 12 Mar - 4 Posts]

Restrict updates during backup run [Tue, 10 Jun - 18 Posts]

Restrict user logons from sql assistant [Wed, 30 Apr - 4 Posts]

Retrieving table DDL [Fri, 23 May - 2 Posts]

Revoke Access on a particular object [Mon, 01 Sep - 4 Posts]

Roles and Collect Stats in Teradata [Wed, 12 Mar - 5 Posts]

Rounding off decimals to nearest integer [Fri, 16 May - 6 Posts]

Running packdisk using crontab [Tue, 22 Apr - 5 Posts]

Running Statistics [Fri, 11 Apr - 3 Posts]



Same query - Different Explains [Thu, 25 Sep - 11 Posts]

Secondary Index usage (with Sub-select) [Tue, 05 Aug - 4 Posts]

SessionID duplicates in DBQLogTBL for 2 different dates 8 months apart!! [Sun, 05 Oct - 6 Posts]

Set up alert using BTEQ with ViewPoint [Mon, 28 Apr - 3 Posts]

Single Amp de-duplication [Tue, 25 Feb - 6 Posts]

Slow multiload [Wed, 09 Jul - 2 Posts]

SQL Assistant crashing [Sat, 19 Jul - 4 Posts]

SQL Assistant History Conversion [Fri, 05 Dec - 2 Posts]

SQL with product join [Wed, 18 Jun - 10 Posts]

Start SQL Assistant with history window [Fri, 10 Oct - 2 Posts]

System defined join index [Tue, 23 Sep - 6 Posts]



TABLE Function [Tue, 11 Nov - 6 Posts]

Teradata 14 Architecture [Wed, 29 Jan - 4 Posts]

Teradata Backup user blocking [Mon, 11 Aug - 4 Posts]

Teradata Columnar distribution and retrieval [Fri, 01 Aug - 3 Posts]

Teradata Data Stream Architecture (DSA) [Mon, 18 Aug - 4 Posts]

Teradata Incremental Backup [Tue, 01 Apr - 2 Posts]

Teradata JDBC connection issue [Wed, 09 Jul - 8 Posts]

Teradata limit on reusing same password [Tue, 20 May - 9 Posts]

Teradata migration from UNIX MP-RAS to Linux [Fri, 01 Aug - 2 Posts]

Teradata ODBC Error : Could not load security library [Thu, 03 Apr - 6 Posts]

Teradata password as case specific [Sat, 17 May - 2 Posts]

Teradata Service Control for Teradata 15 [Thu, 18 Sep - 3 Posts]

Teradata Stored Procedure variable unable to [Fri, 31 Jan - One Post]

The Parcel Stream is Invalid (ODBC Teradata Driver Error) [Mon, 14 Jul - 3 Posts]

To change the backup storage volume in Netbackup [Fri, 25 Jul - 5 Posts]



UDF using DECIMAL8 OR DECIMAL16 VALUES to pass decimal(18, 2) values [Tue, 25 Feb - 2 Posts]

Understanding JOINS [Fri, 21 Nov - 2 Posts]

Unique violation error on INSERT INTO a SET table [Mon, 19 May - 4 Posts]

Unmatched data type in Join [Tue, 23 Sep - 2 Posts]

Untranslatable characters [Thu, 23 Oct - 5 Posts]

Upg to SQLa 14.10.0.04 and with teradata.net - cant change passwd when prompted [Mon, 08 Dec - 3 Posts]

Utility session logging in DBQL [Fri, 28 Feb - 3 Posts]



V14.10 -- Optimizer statistics usage [Fri, 31 Jan - One Post]

Varchar Partition in Teradata 14 [Thu, 07 Aug - One Post]

Varchar variable having size more than 32K in SP [Tue, 28 Jan - 2 Posts]

ViewPoint alert message [Tue, 06 May - 5 Posts]

Viewpoint Explain TBId [Tue, 13 May - 3 Posts]

Viewpoint showing negative spool space [Fri, 13 Jun - One Post]

Volatile Tables are not dropped after terminating the session [Mon, 23 Jun - 3 Posts]



What is maximum row size in TD? [Thu, 17 Apr - 4 Posts]






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