#DateWhereItemComment
36009 Jan 2014 @ 05:08 PSTToolsTeradata Studio Express@Gopal, In the Teradata Datatools Preferences, open (click) the Data Source Explorer Load Preferences and you will see the option Show Databases and Users in Hierarchical Display. You can uncheck t...
35909 Jan 2014 @ 10:00 PSTToolsTeradata Studio Express@sk73, We used to get the actual row count from the result set but this can cause long delays when the rows returned is very large. So this was removed. You can manually get the row count via a Sel...
35807 Jan 2014 @ 09:38 PSTToolsTeradata Studio 14.10 now availableWe are looking into the problem with the drag and drop for Aster.  As each SQL statement execution completes, the results are displayed and the status is posted to the SQL History. Statements...
35706 Jan 2014 @ 11:21 PSTToolsTeradata Studio ExpressYes. Connect to both database servers, open the Compare View and drag and drop the table to open the Copy Compare Dialog. 
35605 Jan 2014 @ 01:32 PSTToolsTeradata Studio ExpressGopal, the default preference is to show databases and users in hierarchy display with child databases and users nested within the parent. To change to flat display, change the preference. Go to Wi...
35524 Dec 2013 @ 08:35 PSTToolsTeradata Studio Express 14.10 now available@paroul, What is the Teradata Database that you are trying to connect to? Teradata Studio Express is a client tool that allows you to connect to your Teradata Database and run queries. If you do no...
35423 Dec 2013 @ 01:45 PSTToolsTeradata Studio Express 14.10 now available@paroul, The example in the article is just an example. You would replace 'testServer' with the name of your Teradata Database server. If you are testing with Teradata Express, that you dow...
35322 Dec 2013 @ 11:52 PSTToolsTeradata Studio Express@hammadmn, I don't know what the credentials are for you to connect to your Teradata Database. If this is a TD Express VM system, you can try using the IP address of the VM and the username dbc...
35220 Dec 2013 @ 01:53 PSTToolsTeradata Studio Express 14.10 now availableCan you try with the current release of JRE 7. Follow this link and grab JRE 7 Download: http://www.oracle.com/technetwork/java/javase/downloads/server-jre7-downloads-1931105.html  and give th...
35120 Dec 2013 @ 01:23 PSTToolsTeradata Studio Express 14.10 now available@paroul, Please send me the output from running the java -version command in a DOS window so I can see what version your system will run with. It should look something like this: C:\Windows\Syste...
35020 Dec 2013 @ 09:18 PSTToolsTeradata Studio Express@hammadmn, The error message means that the host testServer is unknown to the client. Can you ping the system testServer? It is in your host file. Can you try the IP address to connect to the Terad...
34919 Dec 2013 @ 02:04 PSTToolsTeradata Studio Express 14.10 now availableIs it 64 bit version or 32-bit?
34819 Dec 2013 @ 01:15 PSTToolsTeradata Studio Express 14.10 now available@paroul, What is the version of Java when you run the java -version command from a DOS window?
34719 Dec 2013 @ 09:05 PSTToolsTeradata Studio Express 14.10 now availableMake sure you are running the 64 bit JRE. Look in your TeradataStudioExpress.ini file to see what JRE was chosen during install.
34618 Dec 2013 @ 02:37 PSTToolsTeradata Studio Express 14.10 now availableMy first thought is that there is a bitness issues. Can you verify that you are running either the 32-bit JRE and 32-bit Studio or 64-bit JRE and 64-bit Studio. There may also be a log file in the ...
34518 Dec 2013 @ 09:19 PSTToolsTeradata StudioWhat happens if you run the SQL from Studio? I was able to recreate your problem by entering a bad port number. The default port number is 2406. Are you able to obtain the connection successfully?
34417 Dec 2013 @ 10:11 PSTToolsTeradata Studio Express@Darcy, I have seen this issue reported within Eclipse. It seems to be that something has become corrupted running Teradata Studio Express within the VM.  Can you try to remove the following d...
34317 Dec 2013 @ 08:51 PSTToolsTeradata Studio@Anubeig, If you connecting to Aster from Teradata Studio, you would use the Connection Wizard and we will create the connection string for you. In the last screen of the connection wizard we displ...
34216 Dec 2013 @ 01:56 PSTToolsSmart Loader for HadoopYou would download the ConfigureOozie script to your HDP system and run it as root. It is creating the scripts so probably run in a subdirectory so you can see what it created.
34116 Dec 2013 @ 08:47 PSTToolsSmart Loader for Hadoop@Qionglinnewbie, As mentioned above, the procedure has changed for Studio 14.10.01. You must download a new version of TDCH (1.0.9a or greater), as well as run the ConfigureOozie script. Please ref...
34011 Dec 2013 @ 09:00 PSTToolsTeradata Studio's Copy Objects via Drag and DropThe copy is intended as a direct copy of the table, including any indexes. Your steps look correct.
33906 Dec 2013 @ 09:47 PSTToolsTeradata Studio Express 14.10 now available@RFM099, Connecting to the database has not changed so not sure why the performance would be slower. A change was made in the loading of databases, using a hierarchy display. We have fixed an issue...
33806 Dec 2013 @ 09:40 PSTToolsTeradata Studio@tsalonia, Current valid TMODE values are either ANSI, TERA, or DEFAULT.  You can set the value to DEFAULT and save your JDBC properties and share with other users to be their default. In the ...
33704 Dec 2013 @ 03:33 PSTToolsTeradata Studio products - choosing the right client tool@anhngo56, The problem is that we don't have a parser for Aster and so the question mark is mistaken for a parameterized query. When I tried the same query on my 14.10.01 Studio, I got a differ...
33604 Dec 2013 @ 03:05 PSTToolsTeradata Studio products - choosing the right client tool@anhngo56, What is the error you are getting when running the query?

Pages