#DateForumTypeThreadPost
1204 May 2009 @ 10:01 PDTViewpointTopicNew Portlet Project fails ant deploy (Host not found?)Hi all,I just set up the Viewpoint PDK 13.0.0.1 on a Linux box. Went through all the steps and got things working (mostly), much to my chagrin...However I ran into issues when trying to follow the...
1124 Mar 2007 @ 02:00 PDTConnectivityTopicTTU (odbc, cli) on GENTOO linux?I was just wondering if anyone has tried this? I am a fan of the Gentoo distribution of linux so I wanted to see if anyone managed to get the odbc/cli packages installed on this distribution.-Peter
1028 Feb 2007 @ 01:07 PSTDatabaseReplynew nodes increase skewHere is one thing to consider.New nodes mean, more vprocs. If you have some tables which have a very low degree of cardinality on a primary index value, this condition could arise.Think about it l...
928 Feb 2007 @ 01:03 PSTToolsReplySPOOL SPACE ISUUEDid you run both queries in the same interval of time? Was there possibly some change to the underlying data?-pt
821 Feb 2007 @ 12:59 PSTUDAReplyLinking ServersWhat about a table function?-pt
709 Feb 2007 @ 01:08 PSTDatabaseReplyAccessing Row Hash of a recordThe rowhash function is awesome! In fact, using it is one of the best ways to understand data distribution in TD.SELECT count(*), hashamp(hashbucket(hashrow([primary_index_val]))), [primary_index_...
607 Feb 2007 @ 02:39 PSTDatabaseReplyReducing colum lengthYou can alter the table, add a new column, update the new column to be equal to the value of the old column, then alter the column again dropping the original column.This is not a recommended appro...
506 Feb 2007 @ 03:00 PSTDatabaseReplyCasting SMALLINT to CHAROh I got it. The default character witdth for smallint is 6. That's 5 characters for the numeric portion, then 1 character for the sign. The data values are also right-aligned by default.=======...
406 Feb 2007 @ 02:32 PSTDatabaseReplyCasting SMALLINT to CHARI can only confirm that I experience the same....================================================================select 1(smallint);select 1(smallint); *** Query completed. One row found. One colum...
306 Feb 2007 @ 02:28 PSTDatabaseReplyRecords vs Speed!Luke,"Run faster" is a subjective measure. The number you really need to be looking at is CPU and I/O cycles as other workload running on the system at the same time will impact your query perform...
205 Feb 2007 @ 03:12 PSTTrainingReplyDifference Between CURRENT_DATE() and DATEBe careful that you do not try to use these expressions on PPI tables. If so, the optimizer will not invoke partition eliminiation (at least in the current release.)-pt
105 Feb 2007 @ 03:10 PSTUDAReplyNeed A Career Switch to Data WireHousingTeradata Professional Services has so many openings it's ridiculous.. and many of them are now entry level. That's another option.-pt