All Forums

Topics cover the Teradata Studio product family. This includes Teradata Studio, Teradata Studio Express, and Teradata Plug-in for Eclipse. For articles, blogs and more, see the Tools section of the site.

You must login to post to the forums.
Comment above REPLACE PROCEDURE causes error Topic by kmiesse 20 Aug 2015 #teradata, #studio, #replace, #procedure, #comment

In Teradata Studio, when executing a REPLACE PROCEDURE statement with a comment (block /* */or single-line --) above the statement, I receive the error "REPLACE  failed.  Failed [3706 : 42000] Syntax error: Invalid  SQL Statement." Below is an example that fails but if you remove the "-- comment" line it is successful.

891 views
3 replies, 3 years ago
Teradata Studio Bug Topic by ZackHowe 22 Oct 2015 bug row limits

Using Studio 15.10.4
if I issue select * from very_big_table it will think a while and then return no rows.  with a success code.
if I select * from very_big_table sample 2147483646 I get the records.  If I go one more, up to the max 4 byte int limit...no rows, no error message. 
Using old-school sql assistanct the query works too.

444 views
5 replies, 3 years ago
Teradata Studio 15.10 - Fresh Install on Windows 7, Won't Run, Config Error Topic by wbouzek 16 Oct 2015

Hi guys,

New to this forum.  I just installed Teradata 15.10 on my Windows 7 64bit machine and it gives an error when it tries to launch.  The log file referenced in the error is below.  Can anyone assist?
 

!SESSION 2015-10-16 10:41:11.328 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.6.0_37

375 views
2 replies, 3 years ago
Unable to find older versions of terdata studio express Topic by Mahesh_4_Data 16 Sep 2015 download teradata studio

Hi All,
 
Unable to down load older versions of teradata studio express 
 
Please help me to gettign that ..
Thanks,
Mahesh 

494 views
1 reply, 3 years ago
Teradata Load Errors Topic by pyite 15 Oct 2014 teradata load, parameters, varchar, parentheses

Hello,
I am attempting to load a tab delimited file into a table, and I am receiving the following errors:
 
Row number 6,812 had an error.
Cause = Unexpected number of parameters

Row number 26,237 had an error.
Cause = Unexpected number of parameters

2802 views
19 replies, 3 years ago
Teradata Studio 15.10.00.04 defect Topic by rmtonkin 03 Sep 2015 Defect

Every time one switches between a connection eg Dev and prod whilst having a piece of code open in the editor, the cursor position jumps back all the way to the top.  If you have 1000s of lines of code open, this is very very frustrating and time wasting. 

486 views
1 reply, 3 years ago
Teradata Studio v15.10.00.04.201508101601 - Defect Topic by rmtonkin 03 Sep 2015 Defect
After Teradata Studio has been open for a while, it starts lagging excessively when typing. 
There is approximately a half-second delay between each character that is typed into the editor. 
If I close the application and restart it, the problem is resolved for a short while until it starts again. 
568 views
2 replies, 3 years ago
Does TD Studio 15.10 supports tdwallet? Topic by s_reddy 25 Aug 2015 TD Studio, tdwallet

Does TD Studio 15.10 supports tdwallet?

626 views
1 reply, 3 years ago
SQL History Import Error Topic by logc 21 Aug 2015 Teradata Studio 15.10, DSN error, odbc, SQL History

I'm trying to import my SQL Assistant (.mdb) history and am receiving an error immediately after choosing the file:
[Microsoft].[ODBC Driver Manager] Data source name not found and no default driver specified

742 views
1 reply, 3 years ago
Simple SQL failing to parse Topic by DaveWellman 17 Aug 2015

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 dot net connection.
SELECT eid, ename, jobdur (FORMAT  'YYYY-MM-DD')
FROM emp22
WHERE eid = 1001
ORDER BY jobdur;
 

1033 views
2 replies, 3 years ago
Parentheses matching only works partially Topic by MikeBellhouse 19 Aug 2015 match, parenthesis, parentheses

Hello,
I was working with the following Aster Express query in Studio:
SELECT DISTINCT path, count(*) cnt
FROM nPath (
ON bank_web_clicks
PARTITION BY customer_id, session_id
ORDER BY datestamp
MODE(NONOVERLAPPING)
PATTERN ('PAGE+.BME')
SYMBOLS
(
TRUE AS PAGE,
page = 'BILL MANAGER ENROLLMENT' AS BME
)

577 views
2 replies, 3 years ago
Hadoop Databases not found Topic by h2oknut 09 Aug 2015

Hi
 Running hdp vm 2.1, TD Studio  15.10.00 (on MAC) (no problems with 15.10.3 TD Studio express on MAC)
connect to HDP VM, and cannot pull up Hadoop databases on HDP... exact same configuration as my TD Studio express which works
Suggestions?
thanks

1569 views
18 replies, 3 years ago
CREATE TYPE shows 'failed' but no details are available and the UDT is created Topic by DaveWellman 12 Aug 2015

Hi,
I'm doing some testing with the ARRAY type and have come across the following:

822 views
4 replies, 3 years ago
How to load data from a csv file into a table using Teradata Studio Topic by zioli 30 Jul 2015 teradada loadcsv csv teradatastudio

Hi everybody, 
someone here may help me on that? I have to load data from a csv file into a table but I have no idea how. 
There are about 12 million records into the csv file.
thanks

1436 views
1 reply, 3 years ago
Studio 15.10 Data Transfer Wizard does not trigger a transfer job Topic by NC185016 14 Jul 2015 studio, data transfer

Hi,
I have just upgraded from Studio 15.00 to 15.10.00.03 and now the Data Transfer Wizard no longer seems to work.
The dialogue appears, details the correct source and destination tables and columns, but then when I hit 'Finish', nothing appears in the Transfer Progress View, or the Transfer History View.

1524 views
4 replies, 3 years ago
Displaying text data on a single line in result viewer Topic by DaveWellman 23 Jul 2015 studio line break display text char

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 text. These are often sent to the dbms with included line breaks. Those line breaks are recorded in DBQL and hence returned to an application which selects that data.
Cheers,

597 views
0 replies
Teradata Studio 14.10 vs Studio Express 15.10 Topic by ruyeh00 17 Jul 2015 Studio 14.10, Studio Express 15.10

Can someone tell me the pros and cons to upgrading or downgrading from Teradata Studio 14.10 to Teradata Studio Express 15.10?  I'm generally dealing with multiple Teradata DBs and on a daily basis routinely running queries that are > 1 Billion records.  I also have all of the Enclipse plug-ins installed for my Studio 14.10 version.

961 views
2 replies, 4 years ago
Load CSV MaxErr5000 RestartRowAt5001 Topic by ragesz 14 Jul 2015 load csv, max row

Hi All,
I tried to load a CSV into a Teradata DB. My CSV has more than 1 million row. But the TeradataStudio__win64_x86.15.10.00.01 limits the loaded rows at 50.000. OK, I installed the TeradataStudio__win64_x86.15.10.00.03 version. So I successfully loaded my full CSV. And now I want to load an other CSV into an other table. And now I get this error: "MaxErr5000 RestartRowAt5001"

750 views
2 replies, 4 years ago
Teradata Studio Alter Table statement error on TD DB. Topic by cr255014 12 Jul 2015 teradata studio

When I run a query

ALTER TABLE tablename DROP COLUMN columnname;

from my SQL Assistant, It runs file, but when I run the same in Studio it fails to run.

ALTER TABLE tablename DROP  columnname;

runs fine in STUDIO.

 

774 views
2 replies, 4 years ago
v15.10.3 - syntax highlighting appears case sensitive Topic by DaveWellman 12 Jul 2015 studio keyword highlight case

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 and coloured accordingly.
 
but if I type in
Where
it is not recognised and just stays grey.
The same happens with from / From, in / In.

749 views
3 replies, 4 years ago
v15.10.3 - commit processing Topic by DaveWellman 12 Jul 2015 studio create user error

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 the pages of the dialog and specify an inavalid parameter (I originally had the PERM space higher than the owner but it also happens if you break the password rules).

736 views
1 reply, 4 years ago
15.10.00.03 Error After Query Result Limit Topic by zwestbrook 08 Jul 2015

After executing a query and accepting the "Max Row Limit" dialog box ("Result set contains at or over 2,000 rows. Cancel at 2,000 rows in accordance with settings?), running the same query a subsequent time results in the error below. Running the same query again, however, will then process the query and present the limit dialog box again. This happens every other running of the query.

1154 views
6 replies, 4 years ago
Teradata Studio query returned 0 rows but SQLA returned 1,027 rows...identical query. Topic by DannyChin 06 Jul 2015

I submitted the identical query in Teradata Studio (Version: 15.00.00.201407291521) and SQL Assistant (Version 14.10.0.08). In Teradata Studio, 0 rows returned but SQLA returned 1,027 rows. Is there a setting that will prevent rows from returning?

831 views
2 replies, 4 years ago
Data Source Explorer result set view only displaying 500 rows. No apparent way to change. Topic by dafydh 26 Jun 2015 studio, data source explorer, Result Set, row limit

Hello all,

1098 views
1 reply, 4 years ago
Teradata Studio User Guide Topic by janetgag 30 Oct 2013

I cannot locate a Teradata Studio User Guide ...... does this exist?
Thanks!

3937 views
6 replies, 4 years ago

Pages