66 | 03 May 2016 @ 01:52 PDT | Teradata Studio | Reply | JDBC Connection properties | Hi Tom,
That's brilliant, tnaks very much.
Dave
|
65 | 30 Apr 2016 @ 02:43 PDT | Teradata Studio | Topic | JDBC Connection properties | Hi,
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... |
64 | 30 Apr 2016 @ 02:23 PDT | Database | Reply | Diff between CTE and Volatile tables in Teradata | Hi,
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... |
63 | 06 Mar 2016 @ 03:57 PST | Cloud Computing | Reply | Teradata Express VMWare 15.10.0.7 with Viewpoint | Ho 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... |
62 | 06 Mar 2016 @ 02:44 PST | Cloud Computing | Reply | Teradata Express VMWare 15.10.0.7 with Viewpoint | Hi,
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... |
61 | 19 Dec 2015 @ 05:43 PST | Private Forum |
60 | 05 Dec 2015 @ 02:15 PST | Teradata Studio | Reply | Unable 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... |
59 | 20 Aug 2015 @ 09:09 PDT | Teradata Studio | Reply | Simple SQL failing to parse | Hi 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... |
58 | 20 Aug 2015 @ 09:04 PDT | Private Forum |
57 | 17 Aug 2015 @ 02:22 PDT | Teradata Studio | Topic | Simple SQL failing to parse | Hi,
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 ... |
56 | 16 Aug 2015 @ 08:07 PDT | Teradata Studio | Reply | CREATE TYPE shows 'failed' but no details are available and the UDT is created | Hi Francine,
Many thanks for the info. Any idea when that resolution may be available to use?
Cheers,
Dave
|
55 | 12 Aug 2015 @ 12:48 PDT | Teradata Studio | Reply | CREATE TYPE shows 'failed' but no details are available and the UDT is created | I 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... |
54 | 12 Aug 2015 @ 12:47 PDT | Teradata Studio | Topic | CREATE TYPE shows 'failed' but no details are available and the UDT is created | Hi,
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... |
53 | 10 Aug 2015 @ 11:47 PDT | Teradata Studio | Reply | v15.10.3 - commit processing | Hi 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
|
52 | 07 Aug 2015 @ 10:53 PDT | Teradata Studio | Reply | v15.10.3 - commit processing | Hi 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... |
51 | 06 Aug 2015 @ 09:00 PDT | Private Forum |
50 | 06 Aug 2015 @ 08:47 PDT | Teradata Studio | Reply | v15.10.3 - commit processing | Hi 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'... |
49 | 26 Jul 2015 @ 09:35 PDT | Teradata Studio | Reply | v15.10.3 - commit processing | Hi Tom,
Ah! That'll be why I couldn't find it with the other TD manuals, thanks for the links.
Cheers,
Dave
|
48 | 23 Jul 2015 @ 01:33 PDT | Teradata Studio | Topic | Displaying text data on a single line in result viewer | Hi,
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... |
47 | 23 Jul 2015 @ 12:16 PDT | Teradata Studio | Reply | v15.10.3 - commit processing | Hi 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'... |
46 | 16 Jul 2015 @ 05:32 PDT | Teradata Studio | Reply | v15.10.3 - commit processing | Hi 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 ... |
45 | 15 Jul 2015 @ 02:27 PDT | Teradata Studio | Reply | v15.10.3 - commit processing | I 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... |
44 | 13 Jul 2015 @ 09:09 PDT | Teradata Studio | Reply | v15.10.3 - syntax highlighting appears case sensitive | Hi Francine, thanks for the update. Dave
|
43 | 12 Jul 2015 @ 12:38 PDT | Teradata Studio | Topic | v15.10.3 - commit processing | Hi,
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... |
42 | 12 Jul 2015 @ 12:23 PDT | Teradata Studio | Topic | v15.10.3 - syntax highlighting appears case sensitive | Hi,
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... |