#DateForumTypeThreadPost
722 Dec 2009 @ 04:04 PSTAnalyticsReplyString Search and Replace.how would this be done using functions for 'n' occurances of the string?
622 Dec 2009 @ 03:39 PSTAnalyticsReplyString Search and Replace.how come teradata doesn't improve it's function set. We're moving brands and this is one reason I support it. 30 years, and it still doesn't have decent string capability
519 Jun 2009 @ 02:46 PDTDatabaseTopicvarchar length performance implicationsHello,I have 2 tables populated with the same data (2.7m rows), the only difference being the max length of the varchar columns and decimal columns.given the data is the same, seems to me that aggr...
412 Sep 2008 @ 12:36 PDTConnectivityTopicODBC load performanceHi, I'm trying to load a td table via odbc based tool (MS access, SQL Server, etc).and experiencing load times of 20-30rows/sec on my dev and prod boxes. Dev is 1node 4480, prod is 8 node 5400I ...
310 Jun 2008 @ 05:09 PDTUDAReplyHow to update audit columns in a table using triggers?I've been working on a similar trigger to manage my user managed dimensions.What I really want is an 'Instead of' trigger which was depreciated in v2.5?so I've had to use an AFTER UPDATE instead. ...
213 Mar 2008 @ 04:07 PDTDatabaseTopichow do I query "SHOW xxx"I'd like to process the results of a show command in a stored proc. Can I create a query on 'SHOW xxx' somehow?Thanks
117 Aug 2006 @ 03:46 PDTDatabaseTopicMVS(Z/OS) TDP access to TD Server via TCP/IPHi,Because of a history of company mergers, our production mainframe is 600 miles away from our newer teradata that's only on the IP network. Is it possible to configure the Z/OS TDP to use IP net...