#DateForumTypeThreadPost
1218 Sep 2013 @ 12:21 PDTDatabaseReplyINSERT query of view column data typesThanks for the suggestions.  The decision to not use MDS was made way over my pay-grade many years ago. Nolan
1126 Aug 2013 @ 03:43 PDTDatabaseTopicINSERT query of view column data typesI know that Dieter and others talked about how to identify the data type of a view in the thread http://forums.teradata.com/forum/database/query-to-find-out-the-table-name-and-the-columns-of-that-t...
1028 Jun 2013 @ 07:56 PDTDatabaseTopicSQL Assistant inserts double quotesI've created a process in Excel/ VBA to generate TD SQL INSERT statements.  The process primarily performs string handling functions including dealing with handling text with double and si...
928 Jun 2013 @ 07:48 PDTDatabaseReplyReplace with carriage return/ line feedDieter, No, I'm on TD 13.10.   The oReplace function works. Thanks, Nolan
828 Jun 2013 @ 07:46 PDTDatabaseReplyCHR function failsMy apologies to those who responded to my query.  I was relying on the forum's email notification funtion to tell me someone had responded to my question.  I didn't receive an ema...
730 May 2013 @ 06:40 PDTDatabaseTopicCHR function failsI'm trying to use the CHR function.  Using the syntax:   SELECT CHR(66);   I get an error message "SELECT Failed 3706: Syntax error: expected something between '(...
630 May 2013 @ 06:32 PDTDatabaseTopicReplace with carriage return/ line feedI'm trying to replace a string (" | ") with a carriage return/ line feed.  The SQL I'm using is:   UPDATE AML_META_COLUMN_MASTER SET TRANSFORM_RULE = REGEXP_REPLACE(T...
513 Sep 2009 @ 02:01 PDTDatabaseTopicOLAP function for rolling twelve month revenueI know this should be a relatively simple application of an OLAP function, but I've been working on this problem so long (and am facing a Tuesday deadline) my brain is mush. The only way I can see...
408 Jan 2009 @ 03:51 PSTUDAReplyAdvantage of Java stored proceduresI still can't find reference to such a document. Can you provide a URL?Nolan
322 Dec 2008 @ 02:58 PSTUDATopicAdvantage of Java stored proceduresI read that Teradata 12.0 will allow developers to create stored procedures using Java. What are the advantages of that approach over writing stored procedures in "native" Tetadata SQL?What kind o...
217 Nov 2008 @ 03:38 PSTAnalyticsReplyquery that provides hierarchyThe only example I find on p 61 lists all subordinates of a given manager at all levels by employee number, without regard to the managers in between. An employee number 100250 doesn't necessarily...
110 Nov 2008 @ 08:44 PSTAnalyticsTopicquery that provides hierarchyCan someone give me a pointer how to write a query that provides a sorted, indented organization hierarchy given a table with child org id and parent org id. Example of sorting below; I tried to s...