12 | 18 Sep 2013 @ 12:21 PDT | Database | Reply | INSERT query of view column data types | Thanks for the suggestions.
The decision to not use MDS was made way over my pay-grade many years ago.
Nolan
|
11 | 26 Aug 2013 @ 03:43 PDT | Database | Topic | INSERT query of view column data types | I 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... |
10 | 28 Jun 2013 @ 07:56 PDT | Database | Topic | SQL Assistant inserts double quotes | I'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... |
9 | 28 Jun 2013 @ 07:48 PDT | Database | Reply | Replace with carriage return/ line feed | Dieter,
No, I'm on TD 13.10.
The oReplace function works.
Thanks,
Nolan
|
8 | 28 Jun 2013 @ 07:46 PDT | Database | Reply | CHR function fails | My 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... |
7 | 30 May 2013 @ 06:40 PDT | Database | Topic | CHR function fails | I'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 '(... |
6 | 30 May 2013 @ 06:32 PDT | Database | Topic | Replace with carriage return/ line feed | I'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... |
5 | 13 Sep 2009 @ 02:01 PDT | Database | Topic | OLAP function for rolling twelve month revenue | I 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... |
4 | 08 Jan 2009 @ 03:51 PST | UDA | Reply | Advantage of Java stored procedures | I still can't find reference to such a document. Can you provide a URL?Nolan |
3 | 22 Dec 2008 @ 02:58 PST | UDA | Topic | Advantage of Java stored procedures | I 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... |
2 | 17 Nov 2008 @ 03:38 PST | Analytics | Reply | query that provides hierarchy | The 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... |
1 | 10 Nov 2008 @ 08:44 PST | Analytics | Topic | query that provides hierarchy | Can 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... |