#DateForumTypeThreadPost
2705 Sep 2016 @ 09:18 PDTAsterTopiclog file after shutdownHi, i need to have a complete log for the system and users activities on ASTER. i need it because after a shutdown in the weekend, i think for too many sessions or too many work space used, ...
2602 Sep 2016 @ 03:42 PDTDatabaseReplybetween condition make bad execution planthe result is 5041, the exclusion is irrelevant. for the outer questions, i don't know the reply, i have to talk with the development enviroment. "The product join result of all the comb...
2501 Sep 2016 @ 10:36 PDTDatabaseReplybetween condition make bad execution plan sel * from tbla a inner join tblb b on a.TheDay between b.SDay and b.EDay;   Hi Todd, there are no outer conditions to apply on the tbla, 450000000 rows, or...
2401 Sep 2016 @ 08:08 PDTDatabaseReplybetween condition make bad execution plan Hi Dieter,   for every row in table b i have to check if the values of the field TheDay, this field have the dates continuous, is content between the fields SDay (Start Day) and EDa...
2301 Sep 2016 @ 12:09 PDTDatabaseTopicbetween condition make bad execution plan Hi,   i have a query like this:   sel * from tbla a inner join tblb b on a.TheDay between b.SDay and b.EDay;   this is the execution plan:   2...
2204 Apr 2013 @ 04:59 PDTDatabaseTopicNo More Spool Space.... on which AMP?Hi, there is a view that is made from 6 views joined and so on... the result is the error No More Spool Space (Spool limit is 200 GB) and the Peak Spool is 30 GB for 800000 rows there are 42 AMP (...
2120 Mar 2013 @ 06:46 PDTThird Party SoftwareReplyCompatibility: TD12 - Datastage 8.7I reply at myself: Teradata side, the versions of Datastage 8.0.1/8.5/8.10 (InfoSphere Information Server) are declared compatible with Teradata V12 but not the version 8.7. I hope this will help...
2015 Mar 2013 @ 03:41 PDTThird Party SoftwareReplyCompatibility: TD12 - Datastage 8.7No one know it???
1914 Mar 2013 @ 04:10 PDTThird Party SoftwareTopicCompatibility: TD12 - Datastage 8.7Hi to all, i need to know if the version 8.7 of IBM Datastage is declared compatible with Teradata V12, from side Teradata. Where i can find a document that say me this?   Thanks
1814 Feb 2013 @ 11:02 PSTDatabaseReplyrename USI/NUSIThank you very much for the reply Dieter. When i having to rename the PI or to create a name for the PI without name, i found the solution but when i wanted to do the same for the SI of a tables n...
1714 Feb 2013 @ 09:02 PSTDatabaseReplyrename USI/NUSIno one have 1 minute for to reply me? it's possible to rename the USI or NUSI? THX
1608 Feb 2013 @ 08:17 PSTDatabaseTopicrename USI/NUSIHi, the UPI (NUPI) can be renamed but for the USI (NUSI) i have only to drop it and recreate it with the new name? Thanks
1520 Dec 2012 @ 01:45 PSTToolsReplyError to convert text data in Fastload TD12 Hi Sergio, for to cast the data correctly from char type file into the target type you have to add this line after "begin loading TDDB.TDTB..." and before "...
1423 May 2012 @ 09:21 PDTDatabaseReplyTIME() issue hi Dieter and Daniele, i'm very happy of your lesson, i have learned a lot and i changed this row: ,LogoffTimeStamp-LogonTimeStamp HOUR(4) TO SECOND AS TotTime to: ,LogoffTim...
1321 May 2012 @ 01:11 PDTDatabaseReplyTIME() issue hi Dieter, i'm sorry for my confusion and inattention regard the TIME/TIMESTAMP... what you did it's perfect! thx a lot. knowledge
1220 May 2012 @ 01:35 PDTDatabaseReplyTIME() issue i tryed this, it's correct???   sel    A.SessionNo,sum(case    when A.Event= 'Logon' then (-(cast( cast(A.TimeFld as integer)/3600 as int...
1120 May 2012 @ 01:31 PDTDatabaseReplyTIME() issue Hi dnoeth i need to calculate the time between the LogOn and LogOff about one SessionNo in the dbc.EventLog. I think to use the difference with (TIME 'hh:mi:ss.ss' - TIME 'h...
1019 May 2012 @ 10:17 PDTDatabaseTopicTIME() issue Hi, i have a field float type "TimeFld"  and i have to calculate the difference between the "Logoff" and "Logon" time for every session, see the dbc.EventLog t...
902 Jan 2012 @ 06:12 PSTDatabaseReplyFastload constraints Hi Bobby890 This is true even for MULTISET tables. If you want to load duplicate rows in a MULTISET table, use MultiLoad. bye
807 Dec 2011 @ 03:37 PSTDatabaseReplyFEXP,FLOAD: problems yes balachandra.k, now it's all clear. TNX at all for the help.  
707 Dec 2011 @ 02:11 PSTDatabaseReplyFEXP,FLOAD: problems Hi anjanpaul it work how i want! make me understand why with this added "AS CHAR(63)" it work.   TNX a lot!
603 Dec 2011 @ 01:23 PSTDatabaseReplyFEXP,FLOAD: problems i know normally it works. i want to use the separator ",".   TNX
529 Nov 2011 @ 07:58 PSTDatabaseReplyFEXP,FLOAD: problems i tried to change in the fexp the FORMAT VARCHAR in FORMAT TEXT and the exported file is now :  123,456,aaa,   123,456,ccc,  123,456,bbb, the strange symbol the...
429 Nov 2011 @ 05:32 PSTDatabaseReplyFEXP,FLOAD: problems the exported file:  123,456,aaa,  123,456,ccc,  123,456,bbb, i tried to delete the strange symbol at the begin of the rows and the fload is ok! for 3 rows i can delete ...
329 Nov 2011 @ 03:46 PSTDatabaseReplyFEXP,FLOAD: problems hi ulrich, i have ceated a simple tables: CREATE SET TABLE Dan.LAB2 ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,  &nbs...

Pages