#DateForumTypeThreadPost
6603 May 2016 @ 01:52 PDTTeradata StudioReplyJDBC Connection propertiesHi Tom, That's brilliant, tnaks very much. Dave
6530 Apr 2016 @ 02:43 PDTTeradata StudioTopicJDBC Connection propertiesHi, Are the various 'JDBC Connection Properties' options and allowed values listed anywhere? I have searched here, on the Teradata manuals page and through the 'Teradata jdbc reference...
6430 Apr 2016 @ 02:23 PDTDatabaseReplyDiff between CTE and Volatile tables in TeradataHi, Obvious differences first: - you have to issue a 'create volatile table' command for a vt: a cte is created automatically by the dbms - the table and content last until you logoff or...
6306 Mar 2016 @ 03:57 PSTCloud ComputingReplyTeradata Express VMWare 15.10.0.7 with ViewpointHo hum... When in doubt logoff and logon again... (sound familair?) Starting at the above stage, I logged off from VP and then logged on again. I went into 'Viewpoint Administration / Monitor...
6206 Mar 2016 @ 02:44 PSTCloud ComputingReplyTeradata Express VMWare 15.10.0.7 with ViewpointHi, I'm having what looks to be the same problem (or at least very similar). Trying to define the TD system to viewpoint, after filling out all the fields I click 'apply' and I get on...
6119 Dec 2015 @ 05:43 PSTPrivate Forum
6005 Dec 2015 @ 02:15 PSTTeradata StudioReplyUnable to connect to the database using Teradata Studio Express.Hi Sakthi, First, make sure that the dbms is running. From a Gnome terminal window try the following command: pdestate -a This will give you the status of both pde and the dbms. I don't hav...
5920 Aug 2015 @ 09:09 PDTTeradata StudioReplySimple SQL failing to parseHi Chuckbert, Thanks for pointing out the 'execute all' option, I had missed that it didn't use the parser. I think you may be correct in having 'non printing' characters as I...
5820 Aug 2015 @ 09:04 PDTPrivate Forum
5717 Aug 2015 @ 02:22 PDTTeradata StudioTopicSimple SQL failing to parseHi, I'm using 15.10.0.3 and whilst most SQL requests run fine the following generates a message "Parse error splitting statement" and will not run. It runs fine using SQLA through a ...
5616 Aug 2015 @ 08:07 PDTTeradata StudioReplyCREATE TYPE shows 'failed' but no details are available and the UDT is createdHi Francine, Many thanks for the info. Any idea when that resolution may be available to use? Cheers, Dave
5512 Aug 2015 @ 12:48 PDTTeradata StudioReplyCREATE TYPE shows 'failed' but no details are available and the UDT is createdI think I tried to be too clever with my post above. What looks like a blank whit eline was meant to be 'code'. the SQL command that caused this issue is: CREATE TYPE phonenumbers_ary AS C...
5412 Aug 2015 @ 12:47 PDTTeradata StudioTopicCREATE TYPE shows 'failed' but no details are available and the UDT is createdHi, I'm doing some testing with the ARRAY type and have come across the following: If I execute a CREATE TYPE request such as the following the history window shows that the 'statement fa...
5310 Aug 2015 @ 11:47 PDTTeradata StudioReplyv15.10.3 - commit processingHi Tom, Many thanks for that, now I undertsnad what is happening we can work out how to adjust the exercises when using Studio. Cheers, Dave
5207 Aug 2015 @ 10:53 PDTTeradata StudioReplyv15.10.3 - commit processingHi Tom, Ok, thanks for the confirmation, I guess we'll have to look at the exercises we use if we're moving to using Studio as our 'standard' - or t least if more students are like...
5106 Aug 2015 @ 09:00 PDTPrivate Forum
5006 Aug 2015 @ 08:47 PDTTeradata StudioReplyv15.10.3 - commit processingHi Tom, Sorry, only just saw your last post. Here is one exercise that we run as part of one of the Teradata Education courses. This works fine with a CLI application (such as BTEQ) but doesn'...
4926 Jul 2015 @ 09:35 PDTTeradata StudioReplyv15.10.3 - commit processingHi Tom, Ah! That'll be why I couldn't find it with the other TD manuals, thanks for the links. Cheers, Dave
4823 Jul 2015 @ 01:33 PDTTeradata StudioTopicDisplaying text data on a single line in result viewerHi, Is there a preference available that will display text data on a single line instead of with any embedded line breaks? This is particularly useful when the column in the result set is SQL tex...
4723 Jul 2015 @ 12:16 PDTTeradata StudioReplyv15.10.3 - commit processingHi Tom, Many thanks for that explanation, at least I now understand what is happening. Obvious question, is there any way to turn off the 'always execute a BT if no transaction is running'...
4616 Jul 2015 @ 05:32 PDTTeradata StudioReplyv15.10.3 - commit processingHi Francine, Thanks. I understand your point, but as far as I was aware this feature ONLY controls functionality in TDStudio - or maybe in the JDBC driver. As far as I'm aware, it doesn't ...
4515 Jul 2015 @ 02:27 PDTTeradata StudioReplyv15.10.3 - commit processingI don't understand why I should do that. I have defined the connection as TMODE=TERA - which I understood to be 'Teradata mode'. In 'Teradata mode' each request (let's sta...
4413 Jul 2015 @ 09:09 PDTTeradata StudioReplyv15.10.3 - syntax highlighting appears case sensitiveHi Francine, thanks for the update. Dave
4312 Jul 2015 @ 12:38 PDTTeradata StudioTopicv15.10.3 - commit processingHi, Using the 'create user' dialog boxes you have to go all the way to the final screen to execute the command in the event of an error. here is an example of what I mean: Work through th...
4212 Jul 2015 @ 12:23 PDTTeradata StudioTopicv15.10.3 - syntax highlighting appears case sensitiveHi, When typing code into the sql editor, the syntax highlighting only seems to work if you type keywords in lowercase.   For example, if I type in where it gets recognised as a keyword a...

Pages