#DateForumTypeThreadPost
1026 Mar 2014 @ 04:24 PDTToolsReplyRetrieve password from SQL AssistantThe password hasn't expired - i can still connect to Teradata from SQLAssistant. thanks.
925 Mar 2014 @ 04:31 PDTToolsTopicRetrieve password from SQL AssistantI use SQL assistant to connect to Teradata. However, I forgot my password now and cannot connect to Teradata using BTEQ. Can someone help me with retrieving my password from SQL Assistant.   ...
803 Mar 2014 @ 04:26 PSTDatabaseTopicRoles and Implicit SELECT AccessFor a user or a role to get READ access, does it have to be explicltly granted SELECT access? Or, will any other access level give implicit SELECT access? I am posting all access levels here - seem...
706 May 2013 @ 11:25 PDTDatabaseTopicStarting DBS on amazon ec2I have an instance of Teradata 14 running on amazon ec2. It is refusing connections to query the database. Perhaps because DBS is not running as per the output of pdestate   pdestate -a PDE...
625 Apr 2013 @ 10:21 PDTDatabaseReplySampling implementationthanks. -venky
523 Apr 2013 @ 02:59 PDTDatabaseTopicSampling implementationDoes a query sampling a certain number of rows from a table, such as the following, really scan all rows? The information from Explain below seems to indicate that all rows are scanned. Or, does t...
414 Mar 2013 @ 06:34 PDTTeradata ApplicationsReplyselect * works but not "select count(*)" via JDBCIt works if I prepareStatement and then execute it. Not clear why - I thought preparation is only required for parameterized queries - select count(*) isn't a parameterized query.
314 Mar 2013 @ 11:21 PDTTeradata ApplicationsTopicselect * works but not "select count(*)" via JDBCI am running queries through a JDBC driver. I am able to execute select * from DBC.AccessRights with no issue. However, when I execute "SELECT COUNT(*) FROM DBC.AccessRights" I get the fo...
212 Mar 2013 @ 12:46 PDTConnectivityTopicTeradata Express on amazon ec2I launched a Teradata 14 express on Amazon ec2 following instructions here: http://developer.teradata.com/database/articles/teradata-express-14-0-for-ec2-config-guide When I try to connect th...
101 Mar 2013 @ 05:52 PSTCloud ComputingTopicConnection string to the amazon ec2 instanceUsing the URI, teradata://ec2-23-22-91-158.compute-1.amazonaws.com:1025/dbc, , I am unable to connect to the Teradata express instance on amazon ec2. The error message is as shown below. Looks like...