#DateWhereItemComment
719 Apr 2016 @ 04:31 PDTRaja_KT's blogText Search pattern in Teradata with Java , SQLJHi Raja, Thanks for the Informative article above. I am trying to Create a Java UDF by first installing the JAR file using the command below : CALL SQLJ.INSTALL_JAR(‘CJ!?C:/JAR/test.j...
604 May 2014 @ 12:59 PDTDatabaseExploring Teradata 13's PERIOD Data TypeYes, its very good.
528 Jan 2014 @ 01:00 PSTr.sagner's blogColumn compress values from statisticsThanks roland for the nice info. Just wanted to confirm one thing that once we compress the first compress value, the nulls are also covered through that like statement 1: ALTER TABLE <TAB_N...
424 Jan 2014 @ 10:04 PSTr.sagner's blogColumn compress values from statisticsHi Roland, I was following the above approach during finding the candidates for MVC. Just noticed that the nulls were not coming up as  in the biased values, frequency. Can you pls  su...
325 Dec 2013 @ 08:16 PSTr.sagner's blogColumn compress values from statisticsYes, got it Roland.. Thanks for the great explanation.. these steps really combine the Compression and the stats tasks together. cheers! Nishant
225 Dec 2013 @ 03:15 PSTr.sagner's blogColumn compress values from statisticsHi  , I m bit unclear abt dropping the statistics after getting the OP of Show statistics . Once we get the compression list  through Show statistics , can we directly go with alter sta...
108 Dec 2013 @ 07:03 PSTÜber SQLWhy don't you use ALTER TABLE to alter a table?Thanks a lot dieter & rob  for such a nice information. Just want to clear one doubt in the steps mentioned by rob above--> In case , we miss to perform the step 2  & simple ...