All forum activity

#DateUserForumTypeThreadPost
5931922 Aug 2016 @ 08:17 PDTrakeshpToolsReplyUsing Rank Numbers are getting Skipped in Teradata 13.10Hello everyone, I really have big confusion between Rank and Rowno funtions in terradata. Can you please clarify me on these two functions? Regards Rakesh  
5931822 Aug 2016 @ 08:09 PDTtoadrwToolsTopicEasyloader Schema Error 15.10 Only Hello: We're receiving the following error on 15.10 whcih we were not receiving on 15.00.  Could you please help?  Here's our TD Load command line:   tdload -r...
5931722 Aug 2016 @ 07:33 PDTcgermain904DatabaseTopicConvert date > xx/01/xxxx of given month to first of following monthHi, I'm new to the forum and newly learning SQL. I'm hoping for some help on converting dates upon returning the query. The issue I have is that there is a PROCESS_DT field that I'm us...
5931622 Aug 2016 @ 06:32 PDTurskumarDatabaseReplyHow to convert the varchar to time(6) In Teradata?Thank you bhavesh its working fine :)
5931522 Aug 2016 @ 05:18 PDTkiran72329GeneralReplyinterview helpHi, Please forward the questions to kiran72329@gmail.com
5931422 Aug 2016 @ 04:27 PDTbhavesh_09DatabaseReplyHow to convert the varchar to time(6) In Teradata?try this:   select cast ('11:30'||':00.00' as time(6))  
5931322 Aug 2016 @ 04:07 PDTSmacDatabaseReplyCreate NUPI and USI having the same ColumnMany Thanks VandebergB Regarding 1st option - Multiset table will be effective when during DML activity. i.e., It will ignore the uniqueness checking while doing insert, update, etc. We will ...
5931222 Aug 2016 @ 03:49 PDTsachin.sebastianDatabaseReplyResource Monitoring While Running Sql querriesYou can use Viewpoint for this.
5931122 Aug 2016 @ 12:25 PDTLiji.AnoojGeneralReplyBTEQ .IF ERRORCODE <> 0 THEN <QUERY>Hi Amit, BTEQ commands must be preceded by a period '.' so use .IF in your BTEQ.So query must be .IF ACTIVITYCOUNT=2 THEN <QUERY >    
5931021 Aug 2016 @ 09:07 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityI've put together an example outside of the Spark application which has confirmed my suspicion above (using 15.10.00.22): val driver = new com.teradata.jdbc.TeraDriver() val url = "jdb...
5930921 Aug 2016 @ 04:15 PDTBB160003Teradata StudioTopicLooking for a TD Studio 14.10 install packagePreparing collateral for a customer that uses Studio 14.10. I skipped the 14.10 versions of all utilities and went straight to 15.10. Looks like the interfaces have changed a bit and I now need a 1...
5930821 Aug 2016 @ 04:13 PDTkrishna1985DatabaseReplyPadding and timestampthank all ...it worked like charm L:)  
5930721 Aug 2016 @ 06:58 PDTnaughtycreatorDatabaseReplyHow to install Teradata Express on Windows 7 64 bit machine?http://kosmisch.net/Blog/DataAndBusinessIntelligence/Archive/2014/6/29/1a7ee23474544efb9e2318c7a771f74f.html
5930620 Aug 2016 @ 10:19 PDTChrisRxToolsReplyTeradata Tool and Utilities package for LinuxIs there a particular reason why the TTU for Windows is made available and the TTU for Linux is not?
5930520 Aug 2016 @ 05:20 PDTdnoethToolsReplyUnicode Export through TPTYou must triple the VarChar size in your Export Schema, not in your Select.  Additionally you don't need to specify a schema at all, when the Format is DELIMITED, and your Select can be a...
5930420 Aug 2016 @ 04:01 PDTvenkata_k01ToolsReplyZero records are fetching when using where statement in TPTHi Steve,   We tried many ways by putting select statement in the script but still no luck. It would be very helpful if you could please provide one simple sample example.   Thanks &...
5930319 Aug 2016 @ 04:58 PDTsagar_GeneralReplyConcatenate Hi,  I can see your solution. But just thought of sharing below logic.  CREATE MULTISET TABLE TBL(COL1 SMALLINT,COL2 SMALLINT,COL3 SMALLINT,COL4 SMALLINT,COL5 SMALLINT); INSERT INT...
5930219 Aug 2016 @ 04:45 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityTrue, it is reducing a three-value to a boolean by mapping the unknown to nullable = true, and this might explain case #1. But I can see an actual problem in case #2 where every column was re...
5930119 Aug 2016 @ 04:14 PDTdfranks44DatabaseReplySet QueryBand as JDBC Connection ParameterThis is exactly what I need.  I can tease enough information out of here to trace our blocking issues down to the process id's in our job launcher logs.  Thank you very much.  Y...
5930019 Aug 2016 @ 03:56 PDTfeinholzToolsReplyUnicode Export through TPTPlease send me your script. (I may make changes to it.)  
5929919 Aug 2016 @ 03:51 PDTsrivigneshknToolsReplyUnicode Export through TPTI have changed the empcatnumber to 30. I even tried increasing the size to 60/90 but the error meesage remains the same. My TPT version is Teradata Parallel Transporter Version 15.10.01.02 64...
5929819 Aug 2016 @ 03:32 PDTPrajaktaDeosthaliConnectivityReplyQuerying Teradata from JavaScript/jQuery?Is there any update on this particular question?  I read Teradata Magazine article, but I am not able to find the REST API for Teradata system. It would be really helpful if someone can provi...
5929719 Aug 2016 @ 03:08 PDTmonsieurvinodhTeradata StudioReplyTeradata 15.1 Error when trying to execute queryDownloaded Just 20 mins back.. It is on Windows 7 64 bit machine.. Version --> TeradataStudioExpress__win64_x86.15.11.00.00 Below Error Message:  [[ Only when submitting queries ]] f...
5929619 Aug 2016 @ 03:07 PDTfeinholzToolsReplyUnicode Export through TPTIn the example script you sent, EmpCatNumber was defined in the table as VARCHAR(10). If that is the case, then the script must specify VARCHAR(30). If this is done correctly, I am not sure how T...
5929519 Aug 2016 @ 02:01 PDTsrivigneshknToolsReplyUnicode Export through TPTHi Steve,  I have mentioned UTF8 and tripled the size of the unicode fields, i still get the following error.   EXPORT_OPERATOR: connecting sessions TPT_INFRA: TPT02638: Error: ...

Pages