#DateForumTypeThreadPost
829 Oct 2009 @ 03:38 PDTAnalyticsReplyValidate column dataThat's interesting as far as alpha-numeric data, but these strings also include various non-alpha characters. However, I solved the problem through direct analysis of each character column by group...
727 Oct 2009 @ 06:23 PDTAnalyticsReplyValidate column dataI'm a downstream user with few permissions and I see no UDFs in the meta-data. My work is pretty much limited to pure SQL.
627 Oct 2009 @ 05:31 PDTAnalyticsTopicValidate column dataHi,I'm trying to validate that each character in a varchar(100) row is between 0 and 9 on a 250M row table. Any rows that are not valid will be ignored in an insert statement into a base table. How...
517 Jul 2009 @ 04:02 PDTDatabaseReplyJoined table updateThanks for the help Fred. Wow, this is more painful than I expected!
417 Jul 2009 @ 02:10 PDTDatabaseTopicJoined table updateHi, I've just arrived to the Teradata world from SQL Server and learning the new syntax. How do you update a table using a join? The first approach I used was what I have been doing: create alia...
317 Jul 2009 @ 02:01 PDTGeneralReplySuggestion for a new Forum?As a newbie to Teradata, I would add a forum for newbie questions.
217 Jul 2009 @ 12:42 PDTDatabaseReplyUseful system viewsGot it, thanks!
116 Jul 2009 @ 01:29 PDTDatabaseTopicUseful system viewsHi all,I'm new to Teradata and trying to learn my way around. I started out by trying to expand all the views in my test database, but the list is so long the expansion takes forever. So, now I'm t...