All forum activity

#DateUserForumTypeThreadPost
81929 Apr 2006 @ 10:11 PDTDGiabbaiToolsReplyBTEQBTEQ is part of the Teradata Tools and Utilities. Depending on the version of the RDBMS, ask for TTU 7.x (for TD V2R5.x) or TTU 8.x (for TDv2R6.x)
81829 Apr 2006 @ 10:03 PDTDGiabbaiDatabaseReplyextract text string from text field in columnIn the first statement you misplaced "-1"Wrong : select trim(substr(C2T_EMAIL_ADDR_TXT,1,index(C2T_EMAIL_ADDR_TXT, '@'))-1) from dvu_111.t_c2t_empCorrect: select trim(substr(C2T_EMAIL_ADDR_TXT,1,i...
81728 Apr 2006 @ 03:59 PDTsheridanyDatabaseTopicextract text string from text field in columnI have a table with email addresses and I need to extract out the name before the @ in the address. Data looks likes this in the column.joenoname@noname.com?jillnoname@noname.combob.k.noname@nonam...
81628 Apr 2006 @ 12:55 PDTTDUser-781UDAReplyconfidence showned in explain planGreat!I've always supposed that index join confidence was not so good, due to my direct experience; but this was probably due to having poor statistics...Thank you for you explanation, have a nice ...
81528 Apr 2006 @ 11:21 PDTdixonUDAReplyconfidence showned in explain planHi TDUseri researched that an index join confidence occurs(in an EXPLAIN PLAN) when the join happenning between primary index column of one table with the primary or secondary index column of the o...
81428 Apr 2006 @ 09:40 PDTNytewyndDatabaseReplyCalculate hours(date_1 - date_2) * 24
81328 Apr 2006 @ 09:34 PDTNytewyndDatabaseReplyPopulating column with constant day-of-week value?select calendar_datefrom sys_calendar.calendarwhere day_of_week = 6 and calendar_date between date -6 and date
81228 Apr 2006 @ 09:21 PDTNytewyndToolsReplyPivot a table with SQLThe only way to do what you are asking about is with dynamic SQL. If you wanted a pivot showing sales by department by year, you might not know how many departments or years there are. You would ...
81128 Apr 2006 @ 09:15 PDTNytewyndToolsTopicBTEQI am an Oracle developer that recently starting using Teradata. I would like to use BTEQ but the only tool I have installed is Queryman (an old version at that).What product do I need to install t...
81027 Apr 2006 @ 05:14 PDTMikeDatabaseTopicPopulating column with constant day-of-week value?Hello,Here's something I've been wrestling with: I need a column of data that will indicate that the data was refreshed on a particular day of the week. Most likely it was be the past Friday's da...
80927 Apr 2006 @ 03:17 PDTterauser1DatabaseTopicCalculate hoursNeed to find the number of hours between two dates to use in a where condition. Any quick solution/syntax?
80827 Apr 2006 @ 02:48 PDTdcasadyDatabaseReplyNegative spool while monitoring SessionJim,I am seeing negative spoolspace numbers as well. I am using Teradata Manager 7.0 with V2R5.1.2.
80727 Apr 2006 @ 12:06 PDTFredDatabaseReplyTD olap func need helpYou specified an ORDER BY for purposes of calculating the windowed OLAP function, but if you want the result set ordered you need an ORDER BY clause at the end.It's "Remaining" sum because you said...
80627 Apr 2006 @ 10:20 PDTc9jadToolsReplyPivot a table with SQLIt seems if I need to know the number of columns that I will need in these solutions. I would potentially need 100 columns convert from rows. Do you have any other thoughts?
80527 Apr 2006 @ 09:13 PDTMNagatDatabaseReplyInsert-SelectYou are correct! Thanks very much.Shouldn't TD return an error message like "Insert failed due to dup row on set table"?
80427 Apr 2006 @ 05:50 PDTfloppyToolsTopicHow to display all columns with betq commandHi,i know the bteq command: .set width n (n=20~254) but if there a table has many columns and exceed the 254 character limit, how can i output all columns to the screen.any help is appreciated.thanks.
80327 Apr 2006 @ 01:55 PDTragugctDatabaseTopicRelationship between Node and Database sizeHi,Is there a any relationship between number of nodes and size of the database...In case i need to load 20TB of data into staging and 2Tb of data into edw . what would be the minimum requirement o...
80226 Apr 2006 @ 10:04 PDTBBR2DatabaseReplyInsert-SelectIf you are inserting into a set table all duplicates will be discarded.I assume this is what might have happened.Vinay
80126 Apr 2006 @ 05:20 PDTrlaskarUDATopicSQL syntax to check values in a groupHi All,I am trying to verify a table group by say ss_id, and say it returns 10 rows (same ss_id). Now I am trying to verify whether 10th row value > 9th row, 9th row > 8th row ...I need some feedba...
80026 Apr 2006 @ 05:11 PDTMNagatDatabaseReplyInsert-SelectHi all,I have witnessed a strange behaviour today after running an insert-select. Even though the select statement returns aproximately 50K rows, none was inserted and SQL Assistant completed it wi...
79925 Apr 2006 @ 04:30 PDTcgardAnalyticsTopiccollaboration managerDoes anyone have any knowledge regarding Teradata's Collaboration Manager application. It appears to be a Web based application that is integrated with CRM Version 5.x and allows you to customize...
79825 Apr 2006 @ 09:18 PDTyoungDatabaseTopicquestion about TD data distributionas we all know TD store data based on row hash value, data from the same table will be stored together and within the same table data sorted by row hash or different table data rows will merge by t...
79724 Apr 2006 @ 02:52 PDTsamit_9999DatabaseTopicSubstr causing problem-killing query performanceHi,I need to use Substr as part of my join condition.However its killing the performance of the query significantly.Is there any way i can improve performance of the query?SELECT s.col1FROM ABC s...
79622 Apr 2006 @ 10:38 PDTBBR2DatabaseReplyCollect Stats ReportSathish,Thanks for sharing the information.I also wanted the stats date.I actually used the base View definition of MultiColumnStats to come up with this SQL. I can capture the last refresh time h...
79522 Apr 2006 @ 08:55 PDTSathishDatabaseReplyCollect Stats ReportTry :select * from dbc.multicolumnstats where tablename='XX' and databasename='XX'Thanks.

Pages