#DateForumTypeThreadPost
4410 Jun 2013 @ 10:31 PDTConnectivityReplyReverse Engineering VISIO 2010 in TeradataWhen I got that message, I clicked OK, NEXT, Select ALL, Finish.
4326 Sep 2012 @ 02:19 PDTDatabaseTopicJARO_WINKLER_SIMILARITY Function for Teradata?Is there a Teradata way of doing the JARO_WINKLER_SIMILARITY Function that Oracle has? http://docs.oracle.com/cd/E14072_01/appdev.112/e10577/u_match.htm JARO_WINKLER_SIMILARITY Function This fu...
4202 Aug 2012 @ 04:05 PDTDatabaseReplyHow do I get Dense Ranking instead of Modified competition ranking? Thanks Dieter, For limiting the results to only the Top 3 for each Sale_Month and Item_Type, is there a more efficient way than my SQL here for Wikipedia's #3: Dense ranking "1223&q...
4130 Jul 2012 @ 10:28 PDTDatabaseTopicHow do I get Dense Ranking instead of Modified competition ranking? For every Sale_Month, I would like to get the top 3 Item_Types for each Employee_Name dense ranked based on the on the Num_Sales. Currently I am getting "Modified competition ranking" ...
4024 Jul 2012 @ 03:55 PDTDatabaseReplyIs it possible to refresh a view every 15 minutes using a trigger? Thanks!
3924 Jul 2012 @ 02:43 PDTDatabaseTopicIs it possible to refresh a view every 15 minutes using a trigger? Is it possible to refresh a view every 15 minutes using a trigger?   Does anyone have an example of how you can refresh a view every so many minutes via a trigger?
3820 Jun 2012 @ 11:07 PDTDatabaseReplyusing "case when" statement inside stored procedure It would be nice if Teradata SQL supported LENGTH, it's pretty standard with other databases.
3725 Apr 2012 @ 10:25 PDTDatabaseReplyConverting a date to the Terdata date format Is this the best way or is there a different way that is more efficient? select cast(current_date as INTEGER) myTest
3625 Apr 2012 @ 10:13 PDTDatabaseTopicConverting a date to the Terdata date format What is the best way to convert 'yyyy-mm-dd' to the Teradata interger storage of a date? (yyyy-1900)mmdd   For example: If my date was April 1, 2012 and it was stored in...
3517 Jan 2012 @ 01:44 PSTToolsReplyBteq - How can I write stuff to my output file besides what is returned from the DB? Thanks!
3417 Jan 2012 @ 11:12 PSTToolsTopicBteq - How can I write stuff to my output file besides what is returned from the DB? I am trying to create a Bteq job that writes the SQL results to an output file with a seperator between each set of results. I need help with making the seperator in the output file. Is it s...
3313 Jan 2012 @ 08:16 PSTDatabaseTopicTeradata JDBC trace log location? If I use the following connection for JDBC Trace Logging: jdbc:teradata://<DatabaseServerName>/LOG=DEBUG   What is the log file location?   I am using the con...
3209 Jan 2012 @ 09:29 PSTToolsReplyWindows 7 & SQL Assistant/Teradata Administrator Was a version 12 ever released that works for Windows 7?
3103 Nov 2011 @ 07:26 PDTDatabaseTopicIs "eq" a reserved word? I am unable to make "eq" a table alias:      SELECT   column1 , column2 , column4 FROM myTable eq Is "eq" a reserved word or Teradata ...
3001 Nov 2011 @ 11:08 PDTDatabaseReplyBest practice for backing up Teradata Table Structures (DLLs)? With a Netezza database I run one job and all the tables structures are backup to a file. Does Teradata have anything similar?
2928 Oct 2011 @ 03:54 PDTDatabaseTopicBest practice for backing up Teradata Table Structures (DLLs)? What is the best practice for backing up all Teradata table structures and view structures? Can it be done without using a stored procedure or UDF?   Is there an simplier way th...
2819 Oct 2011 @ 09:29 PDTConnectivityReplyTeradata ODBC driver with Apache/PHP Any suggestions for this error I am getting?   PHP Warning:  odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib '/opt/teradata/client/ODBC_32/lib/tdata...
2711 Oct 2011 @ 12:45 PDTDatabaseTopicTeradata Driver Questions Is it possible to have multiple Teradata Drivers installed on a single computer and specify different connections to use different drivers? Which Windows System environment variable determin...
2611 Oct 2011 @ 10:34 PDTDatabaseReply8028 The LAN message Authentication is invalid Uninstalling everything Teradata on my computer and then reinstalling didn't help.
2507 Oct 2011 @ 04:23 PDTDatabaseTopic8028 The LAN message Authentication is invalid I use to be able to connect via Teradata .Net in Sql Assistant but now I am getting the message "8028 The LAN message Authentication is invalid".   I am still able to conn...
2403 Oct 2011 @ 01:59 PDTDatabaseReplyWhere are system reboots tracked? I don't have permissions to access SystemFe and DBC.Software_Event_LogV has zero rows.
2303 Oct 2011 @ 12:58 PDTDatabaseTopicPHP example for connecting to Teradata? What steps need to be done to connect Teradata using PHP? Is it necessary to install the Teradata driver on the same server that the PHP files are located on? Can someone please share an...
2219 Sep 2011 @ 04:46 PDTDatabaseTopicWhere are system reboots tracked? Is there a DBC table that I can look at to see when system reboots occurred?   Our system is TD Version 12 and it hasn't been patched yet, and when I get this message: Warn...
2124 Aug 2011 @ 10:16 PDTDatabaseReplyFinding next change in valueYou could use my solution to fill a new table and then use what other databases call Dense Rank, look at the post by dnoeth for the Teradata work around: http://forums.teradata.com/forum/database/...
2023 Aug 2011 @ 06:12 PDTDatabaseReplyTable or view that contains the NumberOfRows & NumberOfColumns?Thanks mnylin! That is disappointing, auto tracking of NumberOfRows seems to be pretty standard with other databases. Another example in MySQL, SHOW TABLE STATUS returns “Rows” .

Pages