#DateForumTypeThreadPost
3231 Aug 2016 @ 02:31 PDTToolsTopicTDCH: escapedby and enclosedby I am not able to use enclosedby and escapedby arguments in Teradata hadoop connector. I get the following error when I pass these arguments. here I am trying to set enclosedby wit...
3130 Aug 2016 @ 01:51 PDTToolsTopicTDCH Export from HDFS timestamp issue.I am loading a file from HDFS into Teradata using Teradata Hadoop connector. All my records are getting rejected due to error code 6760 (invalid timestamp). All the timestamp fields are of format y...
3029 Aug 2016 @ 08:36 PDTToolsTopicTDCH error limit for Export from HDFS with method batch.insertI am trying to load data from HDFS/Hive into Teradata using the method batch.insert.  Is there a way to set errorlimit property for the load so that the job will not fail when X-1 or lesser r...
2904 Jul 2016 @ 12:43 PDTConnectivityReplyJDBC Fastload Error Tablesboth the fastload error tables are getting dropped as soon the JDBC fastload job completes. This happenes even when the error tables have error record entry. Is there a way with JDBC fastload to pe...
2829 May 2015 @ 01:54 PDTToolsTopicTPT Inserter OperatorHi, Does TPT SQL Inserter operator supports error limit attribute?. Looking at the manual it seems it doesn't. But Stream operator does seems to support it. currently we are looking for altern...
2713 May 2015 @ 09:48 PDTToolsReplyTPT Permission errorYes Steve, So I understand that there doesn't seem to be any issue with TPT script but what I am facing is a environment issue. But I would need help in finding out what environment variable is...
2613 May 2015 @ 09:16 PDTToolsReplyTPT Permission errorThanks Steve for the reply. here are the requested information   TPT version 14.10 The TPT script is USING CHARACTER SET UTF8 DEFINE JOB update_aff_gpn_lup1_temp_trans_chlr1( DE...
2513 May 2015 @ 07:07 PDTToolsReplyTPT Permission errorspecifcally in which directory does these files TPT_DCOP_RE_TMP_optimus_app_*.txt are generated.   Thanks, Charles
2413 May 2015 @ 06:57 PDTToolsTopicTPT Permission error  I have very weird TPT permission issue. When I trigger a TPT script from a Linux Centos Terminal the script succeeds. But if I trigger it  from our Enterprise scheduler (Opswise) th...
2306 Feb 2014 @ 07:05 PSTDatabaseTopicDatablocksize and FreespacepercentDoes the properties of Table like Datablocksize and Freespacepercent is applicable to Spool? in that case if we have a Table A with Datablocksize x1 and Freespacepercent x2 and Table B with Databl...
2208 Sep 2013 @ 06:28 PDTDatabaseReplyMONITORQUERYBAND Open API IssueHi Dieter, Thanks for your reply.. But the issue is that some of the sessions that I process are FASTLOAD/MLOAD/FASTEXPORT sessions (through TPT). Hence I think these sessions are logged on to t...
2124 Aug 2013 @ 09:35 PDTDatabaseTopicMONITORQUERYBAND Open API IssueHi, I am using the SYSLIB.MONITORQUERYBAND Open API in my application. the API takes three parameters,  HostId,SessionNo,RunVProcNo The CLIv2 counterpart of this API has the option of pass...
2014 Aug 2013 @ 07:10 PDTToolsReplyRejected Rows in TeradataIMHO TPT should honour both server side and client side rejects when it evaluates ERRORLIMIT attribute. I believe as of now only server side rejects are considered (ET/UV tables). setting RowE...
1912 Mar 2013 @ 09:26 PDTTeradata StudioReplyTeradata Studio Expressfollowing your suggestion, I removed the workspace directory and reinstalled the application. The issue has been resolved now :) reading the log file in the workspace I could see that the applica...
1811 Mar 2013 @ 11:05 PDTTeradata StudioReplyTeradata Studio Expressone of my other colleague is also facing the same issue in MacBook Pro. 
1711 Mar 2013 @ 10:21 PDTTeradata StudioReplyTeradata Studio ExpressHi, Thanks for the reply. PFB the requested information   ------------------------------------------------------------------------------------------------------------------------------ ...
1611 Mar 2013 @ 01:34 PDTTeradata StudioReplyTeradata Studio ExpressBTW I am using 14.02.
1511 Mar 2013 @ 01:33 PDTTeradata StudioTopicTeradata Studio ExpressHi, I am using Teradata studio express in Macbook pro. The Application is abruptly closing every time I try to open it. It was working for almost a day after upgrading the SQL Client. I've ...
1420 Nov 2012 @ 02:59 PSTToolsReplyTeradata PMon based Java applicationThanks Dieter and Nolan.. This is what I was searching for..
1318 Nov 2012 @ 08:00 PSTToolsTopicTeradata PMon based Java applicationHi all, my project uses a TD 13.10 system. we are planning to develop a Java based application to dynamically view the queries run by our ETL jobs. specifically queries that are blocked by oth...
1217 Sep 2012 @ 10:08 PDTGeneralTopicTeradata V14 CertificationHi all, I recently recieved an E-mail inviting me to take the TD-14 beta certification exams. I am a Teradata V12 certified technical specialist. I am planning to take further  V12 certif...
1109 Sep 2012 @ 07:59 PDTDatabaseTopicTD 14 Columnar data organization.. Hi all,   I have small doubt regarding Teradata Columnar feature consider a column partitioned table with three column partitions C1,C2 and C3. The table has say a billion rows. ...
1005 Sep 2012 @ 10:31 PDTToolsReplyusage of check point in fastload FastLoad will not load duplicate data in both SET and Multi-Set Table is perfectly understandable.. But what would happen if the Target Table is a NOPI table? does the rule is still appl...
909 Aug 2012 @ 10:11 PDTDatabaseTopicRowHash match scan Hi, is the presence of Rowhash match scan in the explain plan an indicator for Fastpath Merge join? Thanks
809 Aug 2012 @ 05:35 PDTDatabaseTopicStatistics for Non-equality constraint Hi all,         I would like to know to what level statistics on a column(s) is useful when the column(s) is used in a non-equality constraint (u...

Pages