Teradata Eclipse Plugin problem
Openning SQL Scrapbook triggered the following error:
Eclipse: 20090621-0832
Data Tools: 1.6.2
TD Plugin : 13.0.0.1
ava.lang.NoClassDefFoundError: org/eclipse/datatools/sqltools/routineeditor/ProcEditorInput
at com.teradata.datatools.dtp.sqltools.db.teradata.TeradataExecuteMultiSQLAc...
by emilwu
15 weeks 2 days ago
|
202 views
|
6 replies,
from 14 hours ago
|
SQLA missing functionality
Hi,
Does anyone know if final version of Java SQLA will contain database export (DDL generation) functionality, which was available in early beta version.
It was one of the best features which I can not find anymore ;(
Regards
Artur
by arturb123
3 days 23 hours ago
|
47 views
|
2 replies,
from 2 days ago
|
Teradata Geospatial application setup -help needed?
Can someone guide me in installing teradata Geospatial software?
I have the following setup
1.Teradata database version 12.0 running on Linux server
2.Teradata Tools and utilities Version T13 running on Windows XP
How do I setup the the software on my client machine and install the rel...
by leo.issac
11 weeks 2 days ago
|
176 views
|
2 replies,
from 1 week ago
|
Fastload error in schedule job
Hi ,
we have a faslload process, that runs fine when we double click a .CMD file in explorer, however, when we try to schedule the same job using the task schedule, fastload aborts with an error before even the logon command is procesed.
The fast load verion is 12.00.00.004, this is runnin...
by johnstg
1 week 3 days ago
|
57 views
|
3 replies,
from 1 week ago
|
SQLA 13.0.0.7 Tera Express 13
SQLA fails on Win 7 RC with
SQLA Version: 13.0.0.7
System.NullReferenceException
Object reference not set to an instance of an object.
at Teradata.SQLA.MainFrm.ToolbarMgr_ToolValueChanged(Object sender, ToolEventArgs e) in F:\ttu130_efix_snap\tdcli\qman\sqla\MainFrm.vb:line 640
at I...
by jvycpalek@csob.cz
1 week 3 days ago
|
30 views
|
0 replies
|
Failure 2673 The source parcel length does not match data that was defined.
While using BTEQ IMPORT I am getting the following error. I know that this is due to a data item not matching the definition, i.e. definition set to VARCHAR(5) and data item being 6 charaters.
What I would like to know is how to halt the code and exit with an error code. The objective being ...
by firstj
1 week 4 days ago
|
42 views
|
0 replies
|
TDWM - Event Combination (under System Regulation)
When editing any 'Event Combination' belonging to either a SysCon or an OpEnv, it is mandatory to choose ANY ONE of "Chagne OpEnv/SysCon" OR "Queue Table", otherwise the event combination cannot be created.
It makes sense that we have to provide the "Change OpEnv/SysCon" field for a combinatio...
by monisiqbal
2 weeks 2 days ago
|
40 views
|
0 replies
|
TDWM gives “No Operating Environment, System Condition pair is mapped to State”
My question is posted at:
http://teradataquestions.stackexchange.com/questions/19/tdwm-gives-no-operating-environment-system-condition-pair-is-mapped-to-state
To repeat:
I am getting this warning when trying to save a TDWM ruleset with a State I created. I don't think that a system condi...
by monisiqbal
3 weeks 3 days ago
|
56 views
|
1 reply,
from 3 weeks ago
|
Teradata Database Setup errors out for some queries
We have installed Teradata on Windows machine. Now on running Database Setup and providing the following information (in the WIndows GUI):
Database Name : db1
Super User: DBC
Super User Password: dbc
Console Password: dbc
Set up DB for Teradata Manager: Yes
Perm Space: 100 MB
DB Type: MPRA...
by monisiqbal
5 weeks 19 hours ago
|
161 views
|
1 reply,
from 4 weeks ago
|
How to resolve the 'Expired' status in TD Query Scheduler (QS)
Hi all,
The 'Expired' status can be found in the Status column of the TD QS Viewer application. When I only had a handful of jobs, I used to just drop and recreate a scheduled request to get rid of the 'Expired' status. (Yes, it may be primitive, but it worked for me then). But now, I have a w...
by Jomark
7 weeks 4 days ago
|
119 views
|
1 reply,
from 7 weeks ago
|
Multiple Sessions Setting in Teradata Tools and utilities
I see that we can set the number of sessions in BTEQ. How does this multiple session setting work in BTEQ?
If I run a Batch script in BTEQ with number of sessions set to more than 1, Will I see the benefit in query run-time? How does 'set sessions ' setting work in BTEQ and in general how does...
by leo.issac
14 weeks 2 days ago
|
301 views
|
4 replies,
from 7 weeks ago
|
What tool (SQL Assistant?) do I use to browse a Teradata database?
I'm not going to be using Teradata much, but I may need to browse a particular Teradata database. What tool do I need to install (MS Windows XP) so I can do that? I've heard of "SQL Assistant", but I just can't find it anywhere. I wouldn't mind using the Eclipse plugin, but I tried to install i...
by dkarr
18 weeks 10 hours ago
|
1078 views
|
17 replies,
from 8 weeks ago
|
Sending data to Windows Named Pipe
Hi:
I left this post on the main Teradata website forum, but I thought this might be more appropriate and perhaps get a response. Thanks for taking a look. I just found this little nook inside of Teradata and I'm glad it exists.
I've created a Windows named pipe in a vb.net application us...
by toadrw
10 weeks 13 hours ago
|
258 views
|
2 replies,
from 8 weeks ago
|
how to convert date format in Multiload
Here is a sample record from my input file (which is comma delimited)
3,840,7/3/2009,718143.47
Table structure is
NBR1 SMALLINT NOT NULL,
NBR2 SMALLINT NOT NULL,
Date1 DATE FORMAT 'YYYY-MM-DD' NOT NULL,
Amount DECIMAL(12,2) NOT NULL
I am using Mload to load this file into table
.L...
by TD-ETL Developer
14 weeks 1 day ago
|
899 views
|
3 replies,
from 10 weeks ago
|
SCD type 2
Hi All,
How do we implement SCD type 2 in teradata.
Thanks,
kiran
by kiranparsha
14 weeks 1 day ago
|
161 views
|
1 reply,
from 11 weeks ago
|
How to loading the large object into the BLOB column?
We want to loading the large object into the blob column with the command line loading tool.
I guess it can be loaded with Java applications. But with bteq, fastload or multiload, how to load it.
by loafer
13 weeks 21 hours ago
|
174 views
|
3 replies,
from 12 weeks ago
|
DATA MOVER TOOL
Where can i find details about DATAMOVER TOOL in Teradata.
Thanks
by harimon
16 weeks 2 days ago
|
194 views
|
2 replies,
from 13 weeks ago
|
how to bypass bad record in Multiload
Hi,
we have a daily multiload insert job and a few critical jobs depend on the successful completion of it. This multiload often failed due to data issue e.g. unexpected input charactor appears same as delimiter. Currently we have difficulty to filter the source data, so I wonder if in multi...
by ubp6l
14 weeks 5 days ago
|
199 views
|
3 replies,
from 14 weeks ago
|
MLOAD with secondary index
Hi,
we have many tables with secondary indexes and while loading it's giving error. we have dropped the secondary indexes and loaded the data. Is it possible to include the below statement in MLOAD script?
create INDEX gmrdate_usi_mo_nm (mo_mm) on teradbc.gmrdate.
Please give me the soluti...
by shivatera
16 weeks 1 day ago
|
289 views
|
4 replies,
from 15 weeks ago
|
MLoad error during production loading
Hello,
I need some help regarding an error that occurred while our production loading was running. Here is the error message:
----------------------------------------------------------------------------
Access module error '34' received during 'read' operation on record
number '1361905': 'p...
by Greyghost
15 weeks 2 days ago
|
149 views
|
1 reply,
from 15 weeks ago
|
Fastload not handling VARCHAR field in Linux?
I'm having problems running Fastload from a Linux client where there's a variable length field present.
I want to copy a selection of data from the production server to the test one, I've tried running the Export using both FASTLOAD & TEXT formats, and then a Fastload using both FORMATTED & TE...
by Rob_Armitage
16 weeks 1 day ago
|
668 views
|
11 replies,
from 15 weeks ago
|
TPT error code 29
i'm running into this error while writing to a file in TPT:
STR_EMI_DET_SQL: sending SELECT request
STR_EMI_DET_SQL: retrieving data
PXTBS_PutRow: Invalid input row length, status = Length Error
STR_EMI_DET_SQL: Error 29 in putting a record onto the data stream
Operator(libselectop.so) ins...
by vdhawan
16 weeks 3 days ago
|
164 views
|
1 reply,
from 16 weeks ago
|
Welcome to the Teradata Developer Exchange discussion forums!
Please see this topic in the General forum for an introduction to the new discussion forums, and a chance to give feedback.
by neilotoole
18 weeks 3 days ago
|
77 views
|
0 replies
|
