#DateForumTypeThreadPost
1827 May 2016 @ 02:52 PDTToolsReplySQL Assistant key not found errorGot a similar error. I solved deleting the .config files ( DBTree.config or DockMgr.config) under the C:/Users/<user>/AppData/Roaming/Teradata/SQLAssistant. Before the delete make sure you ...
1727 May 2016 @ 02:28 PDTToolsReplyTeradata SQL Assistant - Database Explorer Windowi got the same issue on the SQLAssistant vs. 15.00.0.9 and solved deleting the .config files under the AppData/Roaming/SQLAssistant folder. Thanks for the info!
1612 Jan 2016 @ 01:18 PSTViewpointReplyPortlet Lock Viewer no show datajjudge, before activating the lock collection functionality the Lock Viewer portlet in Viewpoint did not display anything. For activate the lock tracking you have to set the logging functionality...
1524 Nov 2015 @ 06:31 PSTViewpointReplyPortlet Lock Viewer no show dataGuys, since i got the same issue i want to share that for the Lock Info collector to run against Teradata Database 14.10 and later, DBQL query logging must be enabled with the WITH LOCK option. So...
1428 Oct 2015 @ 02:30 PDTDatabaseReplyproc call in bteq ansi mode errorThanks dnoeth, as usual!
1316 Jul 2015 @ 03:56 PDTDatabaseReplyDatabase HierarchiesThanks padhia.. that's a good with recursive query.. ;)
1218 Feb 2015 @ 06:56 PSTToolsReplyBTEQ logon problemusing BTEQ: .logon <DB>(name or IP)/<user> [press enter] Password: <your password>  [press enter] Bye
1130 Jan 2015 @ 06:21 PSTDatabaseReplyDate data type explanationHi all, Data is stored as INTEGER (4Bytes) The right formula is this one: ((YYYY-1900))*10000 +(MM*100)+DD Bye
1017 Oct 2014 @ 08:33 PDTDatabaseReplyqualify rank() over (partition) - questionHei man, let's try something similar.. sel * from ppi qualify  row_number()  over(order by a asc,  d desc)=1 union sel * from ppi qualify  row_number()  over(order...
915 Oct 2014 @ 12:58 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingactually i have the same issue on DROP STATS with SQLAssistant 15.0. I'm going to install the lastest version 15.03, hopefully that issue has been patched.    
806 Aug 2014 @ 03:46 PDTGeneralReplyHow to know AMPs and Nodes list from teradata database from working applicationThanks to all.
706 Aug 2014 @ 12:24 PDTUDAReplyGet version numberThanks for the info! ;)
623 Jul 2014 @ 06:06 PDTDatabaseReplyLength of Integer Integer, represents a 32-bit (4-byte) signed integer. Range:  -2,147,483,648 to 2,147,483,647.  
523 Jul 2014 @ 05:52 PDTDatabaseReplyVOLATILE TABLE - Where is it located?thanks!
421 Jul 2014 @ 01:25 PDTDatabaseReplyError 3706 while creating TRANSACTIONTIME Temporal TableGot the same error. The temporal "feature" must be activated on TD by the TD DBA, probably.
316 Jul 2014 @ 07:59 PDTGeneralReplyQuery Banding Useful infos from Stackoverflow: (http://stackoverflow.com/questions/13973948/explain-query-bands-in-teradata) " QUERY BANDING IN TERADATA: QUERY BANDING PROVIDES CIRCUMSTANTIAL WORKFLOW ...
203 Jul 2014 @ 04:10 PDTAnalyticsReplyFor AMP Number HASHMAP()+1thanks for the infos.  
112 Mar 2014 @ 02:20 PDTUDAReplyWHAT DOES DBC MEANS IN TERADATA?thanks!