#DateForumTypeThreadPost
26624 Mar 2012 @ 12:56 PDTToolsReplyImporting fixed length records with BTEQ in Windows environment There is a different - a varchar field need to tell how long it is and is information is expect in front of each varchar column. And this was not found in your file as it was fix length char...
26522 Mar 2012 @ 12:30 PDTDatabaseReplyFiscal vs. Calendar Issue - Adjusting SYS_CALENDAR to Begin Monday The question is if this change would be already sufficient for you? How is the fiscal week definition in your company for the week which contains the 01.01. of a year? Many customers hav...
26422 Mar 2012 @ 12:25 PDTDatabaseReplyCalculate business days hours between two Timestamp(6) fields What you can do is   Cast((sum (extract(hour from hhmmss)) +  sum (extract(minutes from hhmmss))  / 60. +   sum (extract(seconds from hhmmss)) / 3600.)  as...
26321 Mar 2012 @ 06:01 PDTToolsReplyperformance of two columns Test your self by checking the explain So run explain SELECT A.alpha FROM A WHERE A.alpha = B.beta and Explain SELECT A.alpha FROM A WHERE B.beta = A.alpha if the...
26221 Mar 2012 @ 12:17 PDTDatabaseReplyPermissions to a view The database XYZ need select and inserts rights on either PQR or PQR.aaa with grant options.
26120 Mar 2012 @ 11:32 PDTToolsReplyImporting fixed length records with BTEQ in Windows environment You are mentioning fixed length records but you are deining variable length records with USING (col1 VARCHAR(10), col2 VARCHAR(5), col3 VARCHAR(8), col4 VARCHAR(37)). Fixed length would requ...
26019 Mar 2012 @ 11:29 PDTDatabaseReplyCalculate business days hours between two Timestamp(6) fields The meesage is indicating that at least for one row (end(i) - begin(i)) is bigger as 9999:xx:xx Do you have any high/low values in your data? Can you run select min(Policy_Enter_time...
25919 Mar 2012 @ 03:12 PDTGeneralReplyNEED HELP !! - Merging Consecutive and OVERLAPPING date spans Thanks Dieter, these had been on my list to explore for some time. I am impressed. Run this on a 1.3 mio row table. The normed cpu is 1/3 of the solution I outlined. And the ellapsed...
25819 Mar 2012 @ 12:50 PDTAnalyticsReplyHow to use Fastexport exit codes in UNIX Shell Script Hi, I think you will find in unix / linux forums more valuable answers. But you need to do something like   #!/usr/bin/ksh LOG=./thisDBSetupRun.log bteq < your_code.btq ...
25718 Mar 2012 @ 01:26 PDTDatabaseReplyConversion: Seconds to MM:SS It is OK as TD use only the integer part if you cast to int and does not round. The other formular is independent from this rule and should be valid in all DB systems as id - id mod 60 is a na...
25617 Mar 2012 @ 01:28 PDTDatabaseReplyConversion: Seconds to MM:SS So you mean that your result would be a string as it can not be expressed as Interval? You need to calculate the seconds via the MOD function and can either substract these secs fr...
25516 Mar 2012 @ 01:49 PDTGeneralReplyNEED HELP !! - Merging Consecutive and OVERLAPPING date spans to give you an idea - there might be more efficient way do do it... generate some test data create table date_range _test as (select calendar_Date from_dt , day_of _week + calendar_date t...
25416 Mar 2012 @ 01:13 PDTGeneralReplyNEED HELP !! - Merging Consecutive and OVERLAPPING date spans can you share a ddl on which your problem is based?  
25316 Mar 2012 @ 01:10 PDTAnalyticsReplyDate gap analysis on which realease are you?
25216 Mar 2012 @ 04:05 PDTPrivate Forum
25116 Mar 2012 @ 03:43 PDTPrivate Forum
25016 Mar 2012 @ 02:37 PDTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Hi, please don't get it personal but you need to spend a bit more time on the SQL basics before heading into a bit more advanced SQL calculations. You need to propagate the folder_id up ...
24916 Mar 2012 @ 12:26 PDTDatabaseReplycopying sequences based in timestamp Gern geschehen!
24815 Mar 2012 @ 11:27 PDTDatabaseReplycopying sequences based in timestamp Srividhya, below query should do select max(logon_session) over (order by activity_date, activity_time rows between unbounded preceding and current row) as logon_session activity_...
24715 Mar 2012 @ 12:47 PDTDatabaseReplyCASE Statement with multiple columns/variables if you use in you need to enclose the list - even if it is one with () WHEN WX-LON-SUB-STA in ('Deferment') or use  WHEN WX-LON-SUB-STA = 'Deferment'
24614 Mar 2012 @ 08:10 PDTToolsReplyRowhash deadlock during BTEQ insert And just saw that this ids are 15 and the table is 12 :-)... Here an set of ids with length 12
24514 Mar 2012 @ 07:56 PDTToolsReplyRowhash deadlock during BTEQ insert At least I can't reproduce this.  I created a some 12000 ids and loaded them with bteq - see attached data, script and log. Load was quite fast. Can you run this in your environ...
24414 Mar 2012 @ 06:31 PDTToolsReplyRowhash deadlock during BTEQ insert in the bteq you defined acc_id_no as varchar(15) in the table as varch(12). Which length has the acc_id_no? If 15 - only the frist 12 would be used and can result in many equal values. ...
24314 Mar 2012 @ 02:20 PDTGeneralReplyError 3149 So the select you shared above was not fully what you did. Adding columns to a distinct would clearly mean longer time to calculate... 
24214 Mar 2012 @ 12:55 PDTGeneralReplyError 3149 no idea what might be the root caus for that. Could be that optimizer internal thresholds are responcible for that. But thats only a guess.  Maybe someone from Teradata can ans...

Pages