#DateForumTypeThreadPost
1107 Jul 2014 @ 10:50 PDTToolsTopicIssues happening after TTU13.10 upgradeRecently we installed TTU13.10 upgrade as many users were facing temporary connectivity issues for ABI and unix servers. Post upgrade we are getting to hear all new things from users. For ...
1003 Apr 2014 @ 02:19 PDTGeneralReplyUnable to import data from notepad or csv filewhile loading, in most cases, Teradata utilities require data as it is defined in table structure. Please check data type for your column from table which is having problem. if its yyyy-mm-dd, try...
903 Apr 2014 @ 02:06 PDTToolsReplyFastload Utility Locks due to abort- .FILLER command- possible solution?Thanks Steven for your brief explaination. :-)
803 Apr 2014 @ 02:04 PDTDatabaseReplyAnalyzing Teradata SQL QueriesI have done it manually for huge number of tables. for the sake of addition of PPI.   If somebody can have a solution, it will surely help me adding next time... :-)
703 Apr 2014 @ 02:02 PDTDatabaseReplyCan Decimal and Integer be a mismatch for Join?Thanks Dieter and Adharssh.. Dieter's point #3 would surely help.   Adharssh, space is ignored for trailing spaces, not for leading. it would be same for like as well. I guess, it works...
631 Mar 2014 @ 10:07 PDTDatabaseTopicCan Decimal and Integer be a mismatch for Join?Hello All, I have few questions, Can Decimal(12,0) and integer be a mismatch for join? Can Decimal(10,0) and Decimal(20,0) be a mismatch for join? Considering char and varchar ...
531 Mar 2014 @ 09:59 PDTJobsReplyTeradata Career Advicebuddy, everyone has basic knowledge at starting. It depends on you how you take it. It can be a gamble if you are thinking about long term. If you get going, you wont have question about job secur...
431 Mar 2014 @ 09:49 PDTDatabaseReplyQuestion regarding FastloadBeing new to Teradata, I still love old utilities about which you are complaining. I just feel, we can not handle error properly so that might lead to such feelings. Agreed, that most of these uti...
331 Mar 2014 @ 09:42 PDTDatabaseReplyAnalyzing Teradata SQL Queriesyou would probably need to use wildcard searches as querytext like '%tablename%columnname%' I think, in DBQLSQLTBL, it would be querytext or sqltext column which contains query executed...
231 Mar 2014 @ 09:35 PDTToolsReplyFastload Utility Locks due to abort- .FILLER command- possible solution?Thanks Krishna for your thoughts. But i do know about releasing mload locks. What my question was regarding FLOAD locks, and TPT locks if these job end abnormally. In such cases, I can not releas...
125 Mar 2014 @ 10:22 PDTToolsTopicFastload Utility Locks due to abort- .FILLER command- possible solution?While using utilities like Multiload, when any job ends abnormally, Teradata still holds locks and we get error 'Table is being mLoaded'. While in case of FastLoad/TPT end, we get error &#...