#DateForumTypeThreadPost
1417 May 2016 @ 11:39 PDTPrivate Forum
1322 Oct 2015 @ 11:41 PDTData ModelingReplyMax column length in ERWin for Teradata 14.10 columnsERWIN 9.6.1 supports 128 character object names 64 in Latin 128 for UNICODE, a 2-byte character set)
1206 Apr 2015 @ 05:23 PDTDatabaseReplyPerformance with pertitioned tableOne solution is to consider adding a derived start_year column to the table and partition that column.  Queries using that column as a predicate qualifier should leverage the start_year column.
1119 May 2014 @ 05:25 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlI found that disconnecting all connections helps speed things up as far as saving SQL editor files.  Terminating Teradata Studio after that and starting back up brings back good performance.&n...
1006 Sep 2013 @ 06:56 PDTCloud ComputingReplyConnection issues from ALL applications to TD Express 13.10 and 14.00 through VMWareWhat I did to get the target ip address type ifconfig from the LINUX prompt.  You should see the ip address as in (bold):    ifconfig eth0      Link encap:Et...
928 Jul 2013 @ 05:16 PDTExtensibilityReplyXML Services on Express 14.0 -- trouble in installI used ip addresses instead of hostnames and got around the .so library issue.
805 Jul 2013 @ 04:44 PDTCloud ComputingReplyHow do I access a VMWare hosted Teradata Express from a local TD Mapping ManagerThe ip address you use to access the Teradata Database on a VMPlayer Guest LINUX OS (Host was Win 7 in my case) can be obtained through executing the ifconfig command from the LINUX (guest OS where...
719 Jun 2013 @ 12:49 PDTDatabaseReplyMissing XSD for Teradata 13.10 DBQL XMLPLANI ujst learned the location is http://schemas.teradata.com/queryplan/queryplan.xsd   Also.. a quote "Note that xsi:schemaLocation attribute value contained with logged documents&...
617 Jun 2013 @ 12:39 PDTExtensibilityReplyXML Services on Express 14.0 -- trouble in installI ran the XML 14.0 install on Teradata Express 14.0  Using the above workarounds the install went to completion.  With one exception, that is.  The ./lib directory did not contain th...
504 Jun 2013 @ 09:53 PDTDatabaseReplySQL to find Row CountThe column queryid can be used to join those DSBQL tables/views as well as the DBQLOBJTBL together.  Queryid is a system wide unique value.  
407 Dec 2012 @ 07:34 PSTToolsReplyTeradata PT 12.0 error output schema does not matchBased on an install script I looked at earlier this week.  Isn't the tradtional utilities FastExport/FastLoad/MultiLoad 32 bit and the TPT utilities 64-bit?  It appears to me the erro...
302 Aug 2012 @ 06:32 PDTPrivate Forum
212 Jan 2012 @ 11:15 PSTGeneralReplyRegarding Using TERADATA as website backend A Financial Services Client is doing so with both .NET and JAVA applications, supporting thousands of users.  As with any development it depends on the amount of processing each query will ...
102 Feb 2011 @ 03:41 PSTDatabaseReplyRestricting users from updating columnsI suggest considering using a Stored Procedure with a built in update of an audit table so that you can keep track of who did what update when.