#DateForumTypeThreadPost
69113 May 2014 @ 04:46 PDTDatabaseReply incremental planning and execution (IPE)yes, I used "only" 1 Mio rows on the PPI table. But the SSI queries also contained a UPI access so should be pretty fast. I was wondering where to draw the line and was therefor asking f...
69013 May 2014 @ 12:19 PDTDatabaseTopic incremental planning and execution (IPE)Hi all, I am exploring the new IPE feature on 14.10. Very nice! But sometimes the explain is showing   "This request is eligible for incremental planning and execution (IPE) &n...
68906 May 2014 @ 12:52 PDTDatabaseReplyIdentifying Temporal TablesIn 14.10 the dbc documentation states that tables views should have the column TemporalProperty Further down you find the following description:   TemporalProperty Column The TemoralPrope...
68829 Apr 2014 @ 02:35 PDTToolsReplyCan we use where clause in TPT Export selectortry to replace all ' with '' within the select. Something like (''000362464WH'', ''20550K01A'');  
68728 Apr 2014 @ 12:20 PDTToolsReplyLoading carriage returns with TPT Load Operatorsad, sad...
68626 Apr 2014 @ 12:50 PDTToolsReplyLoading carriage returns with TPT Load OperatorWill it make in 15.0? It creates so much overhead if you have to deal with it in preprosessing. These social network sources are full of this as it all about free text fields...
68516 Apr 2014 @ 07:05 PDTThird Party SoftwareReplyBi tool cannot read from different databases in teradata?Hm, not so easy to answer. I am not sure that I understand how the dead lock occurs. Questions: is the read lock nessesary for you? Would lock row for access be OK? I would strongly avoid the cre...
68407 Feb 2014 @ 11:38 PSTAnalyticsReplyteradataR package and R 3.0.0Just verified the package at (see message from nonsleeper above) git clone https://github.com/Teradata/teradataR/ is just working fine. What kind of message to you get? R version 3.0.2 (2013-...
68307 Feb 2014 @ 10:50 PSTTeradata ApplicationsReplyTPT export and error code 2595P.S. the error does not occur at TPT startup. There is already some GB of data retrieved...
68207 Feb 2014 @ 12:04 PSTTeradata ApplicationsTopicTPT export and error code 2595Hi, we are getting with an TPT export the error code 2595. Explanation: 2595 The FastExport select request has been aborted. Explanation: The current Select request has been aborted. Generat...
68107 Feb 2014 @ 01:05 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemOk found it myself: http://www.docjar.com/html/api/java/sql/Types.java.html But thanks again to tomnolan
68006 Feb 2014 @ 10:16 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemYes,yes,yes! That works! Thanks a lot! As I have to deal with different data types. Do you know where I can find the constanst for other data types? e.g. Types.String etc.? I didn't find th...
67906 Feb 2014 @ 12:54 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemP.S. I am not a Java programmer. Does null loads with JDBC Fastload work in a pure Java implementation? So is this clearly a R problem?  
67806 Feb 2014 @ 12:38 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemUnfortunatly it does not help. Error message is now: Fehler in .jcall(ps, "V", "setNull", as.integer(3), 4) :   method setNull with signature (ID)V not found
67706 Feb 2014 @ 12:44 PSTGeneralReplyCreate a macro that chooses from teo different select staments depending on a given parameter.SP might be the better way but in case there are limitations on SP and both SQLs deliver the same column lists and data types you can try something like replace macro con_test (test_val char(1))...
67605 Feb 2014 @ 11:51 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemHi,  no thats not the issue.  is.na(x) checks for NA and NaN.  You can change j[i1] <- NA and the error is the same. The message is "Fehler in .jcall(ps, "V&qu...
67505 Feb 2014 @ 07:54 PSTConnectivityTopicLoad Nulls with R & JDBC Fastload ProblemHi all, I try to load some data from R directly to Teradata 14.10 via JDBC Fastload. The data contains some Nulls for numeric values and I have not been able to load this data so far.  The ...
67405 Feb 2014 @ 07:46 PSTDatabaseReplyUse of NOT IN for a fact joinWhat is the PI of the fact table  
67305 Feb 2014 @ 12:46 PSTDatabaseReplyUse of NOT IN for a fact joinI don't get fully what you wanne achive Can you explain with some data? also not exists shows better performance select * from fact o where date_col / 100 + 190000 = 201310 and not exi...
67223 Jan 2014 @ 11:58 PSTDatabaseReplyUrgent : Latin to Unicode character conversion- Please helpwhat is your session setting of your BO query? It has to be unicode as well.
67123 Jan 2014 @ 04:44 PSTDatabaseReplyUrgent : Latin to Unicode character conversion- Please helpCan you explain how you managed to store the unicode data in the latin columns? Did you check the WITH ERROR option of the translate function?
67022 Jan 2014 @ 05:54 PSTConnectivityReplytd wallet for jdbcHi, on http://developer.teradata.com/tools/articles/introducing-teradata-wallet At present, only logon processing that is initiated through Teradata CLIv2 for Network Attached Systems utiliz...
66921 Jan 2014 @ 01:06 PSTAsterReplyAster without a SYS_CALENDAR?I guess there exists different use cases for a calendar table where system calendar is usually a starting point as it is part of TD default installations. 1. Check if date is a workingdate weekday...
66816 Jan 2014 @ 10:35 PSTAnalyticsReplyHelp with SQL to deal with overlapping date rangewhich release are you on?
66714 Jan 2014 @ 11:46 PSTDatabaseReplyConnection problem with TD14They are all on the same machine but quite different - the VM looks like a different computer to your laptop and therefore you need to enable that the VM can be reached from you laptop... Did you ...

Pages