All forum activity

#DateUserForumTypeThreadPost
5934422 Aug 2016 @ 03:13 PDTfeinholzToolsReplyEasy Loader Error - 2 Teradata SystemsPlease change the job variable "SelectStmt" to "SourceSelectStmt" and let me know if the job is successful.
5934322 Aug 2016 @ 03:02 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTYou need to escape (double) the single quote characters around the date.
5934222 Aug 2016 @ 02:36 PDTaaibinderToolsTopicTPT Script, Only Pull Entries Within Last 6 Months?So my original query in Sqoop was included the condition   BROADCAST_DT > DATE - INTERVAL '6' MONTH   I've been trying to put this into my TPT script, inside the S...
5934122 Aug 2016 @ 02:18 PDTcgermain904DatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthThanks Dieter!
5934022 Aug 2016 @ 01:52 PDTdlcookToolsTopicEasy Loader Error - 2 Teradata SystemsI'm following (somewhat) the example on http://developer.teradata.com/tools/articles/using-tpt-easy-loader-to-move-data-within-the-database-environment , but I'm running into an error ...
5933922 Aug 2016 @ 01:36 PDTtoadrwToolsReplyEasyloader Schema Error 15.10 OnlyOn 15.00 you are correct everything is varchar.  Moving the same file on 15.10 is not. 15.00 Private Log - Success TPT_INFRA: TPT04101: Warning: TMSM failed to initialize Teradata Paralle...
5933822 Aug 2016 @ 01:13 PDTNaresh12ToolsReplyZero records are fetching when using where statement in TPTSelectStmt='SELECT * FROM TABLE_NAME WHERE EFF_DT='2016-08-12' '   Unable to Enclose date inside single quotes while passing the variable in job_variable file for tdload scri...
5933722 Aug 2016 @ 12:30 PDTZackHoweTeradata Database on VMWareReplySetting up Teradata Python Module on VMware imageI decided I didn't like the Python version from the OSS package (3.3.2) since I wanted to use subprocess.run() so I went back to the install drawing board. using the OSS repo, I found the righ...
5933622 Aug 2016 @ 11:29 PDTfeinholzToolsReplyEasyloader Schema Error 15.10 OnlyYou will have to show me a job run with TPT 15.0 and a schema with FLOAT. It should not have worked. We have been pretty strict about this since Day 1.
5933522 Aug 2016 @ 11:13 PDTdnoethDatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthThe calculation might be simplified to: if it's not the first day of a month calculate the last day and add one day CASE WHEN EXTRACT (DAY FROM COLUMNNAME) = 1 THEN COLUMNNAME ...
5933422 Aug 2016 @ 11:03 PDTtomnolanConnectivityReplyQuerying Teradata from JavaScript/jQuery?Teradata REST Services is available from AWS: https://aws.amazon.com/marketplace/pp/B01DJUOW10   Also, if you're a customer, Teradata REST Services is available from "Teradata at Yo...
5933322 Aug 2016 @ 10:53 PDTtoadrwToolsReplyEasyloader Schema Error 15.10 OnlySorry about that.  It doesn't work with the new DDL.  We don't have a problem on 15.00 even with the original DDL where there are float columns.  Here is the new test.  ...
5933222 Aug 2016 @ 10:51 PDTJayant2306DatabaseTopicNeed information aboutHi All, I am trying to tune a query. Basically I joinning two table A,B on columns Col1. both having different Indexes Example: select * from Table1 A inner join Table2 B on A.Col1 = B.Col1 a...
5933122 Aug 2016 @ 10:27 PDTtomnolanConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityCorrection: In my post above, where I said that the nullability for column c2 is inaccurate -- it's actually the nullability for column c1 that is inaccurate.   Column c1 doesn't hav...
5933022 Aug 2016 @ 10:22 PDTtomnolanConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullability>>> Maybe it's related to sub-queries messing up the nullability?  Is this a known limitation?   In short, Yes.   Your subquery is used as a derived table. Here is a...
5932922 Aug 2016 @ 10:10 PDTcgermain904DatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthYou, my friend, are awesome! Thanks so much, this worked great! I read more about the ADD_MONTHS and EXTRACT functions to help understand what is happening. Great learning from my first post. I lo...
5932822 Aug 2016 @ 09:52 PDTsachin.sebastianDatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthSEL CASE WHEN EXTRACT (DAY FROM COLUMNNAME) > 2 THEN ADD_MONTHS((COLUMNNAME - EXTRACT(DAY FROM COLUMNNAME)) +1,1) ELSE COLUMNNAME END Use your column name inplace of 'COLUMNNAME'
5932722 Aug 2016 @ 09:35 PDTcgermain904DatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthCorrection to above on 'however, could I just modify that expression to be "> 2"?'
5932622 Aug 2016 @ 09:34 PDTcgermain904DatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthThank you for your response, Sachin. This CASE yields the date as the first of that particular month, not the following month which is what I need. I've also noticed that records will store on ...
5932522 Aug 2016 @ 09:11 PDTsachin.sebastianDatabaseReplyConvert date > xx/01/xxxx of given month to first of following monthTry this SEL CASE WHEN EXTRACT (DAY FROM CURRENT_DATE) <> 1 THEN (CURRENT_DATE - EXTRACT(DAY FROM CURRENT_DATE)) +1 END Just replace the CURRENT_DATE with your column name
5932422 Aug 2016 @ 08:59 PDTfgrimmerTeradata StudioReplyTeradata 15.1 Error when trying to execute queryVinoth, I think there is a problem in selecting the conneciton profile in the SQL Editor. A workaround is mentioned above. As a work around, can you try creating another connection profile wit...
5932322 Aug 2016 @ 08:58 PDTfeinholzToolsReplyEasyloader Schema Error 15.10 OnlySUBSCRIBER_NO is defined as FLOAT. It needs to be VARCHAR.  
5932222 Aug 2016 @ 08:56 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTIf you tried to put the SELECT statement in the script, please send me your script and I will make adjustments as necessary.  
5932122 Aug 2016 @ 08:55 PDTfgrimmerTeradata StudioReplyLooking for a TD Studio 14.10 install packageBrian, You can get older versions of Studio on the Teradata Patch Server. Just a reminder that if you have any support issues, you will need to move to the latest version.
5932022 Aug 2016 @ 08:26 PDTalokku55GeneralReplyinterview helpHi Anand, If you dont mind, could you please upload in google doc share and share the link. This is just to avoid any spam on our personal email by not sharing it on the web. Thanks in advance! ...

Pages