#DateForumTypeThreadPost
1630 Nov 2011 @ 01:34 PSTDatabaseReplyFEXP,FLOAD: problems Hi,  I did not run this but you need to harmonize the extract and load for the extract change to   SELECT       ID_CLNT, ID_ENT_SGNLN,CD_SPRT...
1529 Nov 2011 @ 06:51 PSTDatabaseReplyFEXP,FLOAD: problems The problem seems to be the record mode and your attempt to create a CSV file. If you use fastload mode you should not concat the fields to a csv string. But in this case you need to change ...
1429 Nov 2011 @ 06:46 PSTDatabaseTopicRecommended update strategy for block level compressed (BLC) tables Hi, what is the recommended update strategy for BLC tables? Scenario is to insert new rows - no deletes, no updates. Ulrich
1329 Nov 2011 @ 12:06 PSTDatabaseReplyFEXP,FLOAD: problems I didn't check the scripts here. Question is what do you want to achive? Do you really want to export CSV files? You might need to take care of null handling as well etc. On the ...
1228 Nov 2011 @ 11:55 PSTGeneralReplyMany left joins in a query Check RECURSIVE queries. But how do you know which record is the root (first) one in your list?
1128 Nov 2011 @ 11:51 PSTGeneralReplyHow to get entire database DDL structure in TeraData Can you explain in a bit more detail what you want? All DDLs of a database?
1017 Nov 2011 @ 04:51 PSTPrivate Forum
915 Nov 2011 @ 08:38 PSTAnalyticsReplygroup data by ranges check http://forums.teradata.com/forum/analytics/date-gap-analysis-0 I think its the same problem  
815 Nov 2011 @ 08:31 PSTAnalyticsReplyDate gap analysis Depends on your DB release in 13.1 the following might give what you need convert start_dt and end_dt into a single period data type use EXPAND ON to generate one row per ...
715 Nov 2011 @ 07:58 PSTPrivate Forum
615 Nov 2011 @ 07:55 PSTPrivate Forum
514 Nov 2011 @ 11:52 PSTPrivate Forum
414 Nov 2011 @ 11:45 PSTPrivate Forum
330 Jul 2011 @ 12:35 PDTViewpointReplyMyQuery portlet and SkewDBQL does provide normed CPU information. Main reason is that otherwise skew is a regular pattern in coexsisting systems and skew reporting becomes very difficult to read. So question remain. Is Vi...
226 Jul 2011 @ 09:04 PDTDatabaseReplyComplex Date Logictry select calendar_date, case when cast(extract(year from current_date) !! '-10-01' as date)-calendar_date > 0 then cast((extract(year from current_date)-1) !! '-10-01' as date) e...
126 Jan 2011 @ 05:17 PSTViewpointTopicMyQuery portlet and SkewHi all, we run TD 13 on a coexisting system. I observe that many queries of in viewpoint show high skew values but the data has good distributions. Does Viewpoint calculate the skew on the nor...

Pages