All forum activity

#DateUserForumTypeThreadPost
5937023 Aug 2016 @ 05:35 PDTbhavesh_09DatabaseReplyTeradata Implicit CastingHi, What do you mean by "joined together". does it mean concat? if it is concat then you can check it by using  select type(cast(123456 as integer)||cast(123 as byteint)) &nb...
5936923 Aug 2016 @ 05:22 PDTjuanalfonsoTeradata Database on VMWareTopicUltraVNC is not working in Teradata Express 15.10Hello, I can't make UltraVNC work in the TD Express 15.10 Virtual Machine to make a remote desktop connection from Windows. It's strange because in the TD Express 15.00 it worked fine, bu...
5936823 Aug 2016 @ 04:20 PDTDeepakjiDatabaseTopicCan we pass object as parameter in a macro ? For eg :  replace macro database1.macro1(databasename char(50),tablename char(50)) as ( Select count(*) from :databasename.:tablename; );   Can someone let me know ho...
5936723 Aug 2016 @ 04:05 PDTagnit.chatterjee1988DatabaseTopicWhen to use Join Index Hi , What are the indications from the explain plan of a query that might indicate we should use a JI [ aggregate,sparse,single table or multi table ]? Thanks, Agnit
5936623 Aug 2016 @ 03:57 PDTbhushan.koliDatabaseReplyResource Monitoring While Running Sql querriesYes we can use ViewPoint ,But I don't have console access of TD machine
5936523 Aug 2016 @ 03:40 PDTsachin.sebastianDatabaseReplyrows unbounded precedingWhy is the result of the 3rd row 500 (and not 500-80 = 420)? Should there be no subtraction within a month? Also is the date format in example given DD/MM/YYYY?
5936423 Aug 2016 @ 02:07 PDTCarlosALDatabaseReplyRead Timezone Without ':' CharacterHi. You'll have to process the string to get a readable Teradata format (the day of month must be two digits too). BTW: 5 Mar 2015 was not Monday. HTH. Cheers. Carlos.
5936323 Aug 2016 @ 01:16 PDTG787010DatabaseReplyrows unbounded precedingHi All, Could anyone provide the suggestion for the below query, The requirement is, considering 2 columns with date and amount, if the month of the date is 1(January) then the amount should be t...
5936222 Aug 2016 @ 11:53 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityAnd as a follow-up question, could the driver use isNullable=N + mayBeNull=Y to instead return columnNullableUnknown?
5936122 Aug 2016 @ 07:16 PDTtoadrwToolsReplyEasyloader Schema Error 15.10 OnlyHello Steve: Again, sorry about the confusion.  Below is the error and the private log when running under 15.10.  We use the same command line switches for both loads.  I would assu...
5936022 Aug 2016 @ 07:13 PDTdlcookToolsReplyEasy Loader Error - 2 Teradata SystemsThat did it - thanks so much, SteveF!
5935922 Aug 2016 @ 07:13 PDTagnit.chatterjee1988DatabaseTopicTeradata Implicit CastingHi, I was just curious to know what would happen when 2 columns with different data types integer and byteint is joined together? According to me the byteint should be converted to integer. Howev...
5935822 Aug 2016 @ 06:31 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityOut of interest, what is the logic behind the property "mayBeNull" on FullContentMetadataItem?  I'm noticing that it differs from the isNullable property in the second query...
5935722 Aug 2016 @ 06:18 PDTjwahDatabaseTopicFetch multiple columns from cursorHi, I am try to use a cursor to loop through multiple values, which is fine if I only use one column. It doesn't seem to work if I try to fetch more than one column. e.g. DECLARE var_a V...
5935622 Aug 2016 @ 06:05 PDTBB160003Teradata StudioReplyLooking for a TD Studio 14.10 install packageThank you, my friend. I had forgotten about that resource. Appreciate the info and guidance. :-)
5935522 Aug 2016 @ 04:58 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityI really appreciate the effort you've put in.  Looks like this is defintely an a issue in the database server itself (not the driver/connectivity).
5935422 Aug 2016 @ 04:46 PDTsumapsDatabaseTopicRead Timezone Without ':' CharacterHi,   I have a source data column that has a timestamp with timezone in the below format: Mon, 5 Mar 2015 08:23:00 -0800 (PST) I am trying to cast this as timestamp(0) with timezone FORMAT...
5935322 Aug 2016 @ 04:23 PDTfeinholzToolsReplyError Running Teradata to hadoop script "PTS00031"Did you provide the Hadoop_Home and/or Hadoop_Prefix job variables?  
5935222 Aug 2016 @ 04:16 PDTtoadrwToolsReplyEasyloader Schema Error 15.10 OnlyThanks Steve:  I think I was sent the incorrect private log.  I'll get back to you as soon as I can with the correct one.  Sorry for the confusion.
5935122 Aug 2016 @ 03:51 PDTflash7gordonConnectivityTopicCan you get Teradata.Client.Provider for c#/dot.net just from disk?Hi,   Have one version of the Teradata Client installed on the laptop where I do my compiles.   I want to use another version of the Teradata.Client.Provider for my compiles.   Can I...
5935022 Aug 2016 @ 03:40 PDTFredDatabaseReplyNeed information aboutNeed more detail. For example: How unique / non-unique are Col1 alone, Col2 alone, combined (Col1,Col2)? How big is table1 vs table2?
5934922 Aug 2016 @ 03:38 PDTkchinnasamy@snaplogic.comToolsTopicError Running Teradata to hadoop script "PTS00031"cmd: tbuild -f PTS00031 -v jobvars.txt -j PTS00031   Output: Teradata Parallel Transporter Version 15.10.01.03 64-Bit Job log: /opt/teradata/client/15.10/tbuild/logs/PTS00031-57.out Job i...
5934822 Aug 2016 @ 03:32 PDTfeinholzToolsReplyEasyloader Schema Error 15.10 OnlyYour 15.10 job is not anything like the 15.0 job. The 15.00 job uses the DataConnector operator and the Load operator. The 15.10 job is using the ODBC operator and the Stream operator.  
5934722 Aug 2016 @ 03:25 PDTkchinnasamy@snaplogic.comToolsReplyUnderstanding teradata sample scriptsThanks that was really helpful.
5934622 Aug 2016 @ 03:24 PDTfeinholzToolsReplyTPT Script, Only Pull Entries Within Last 6 Months?SQL statements assigned to attributes are enclosed in single-quotes. Because of this, all single-quotes inside that string must be escaped (doubled) in order to be preserved.   So, your Sel...

Pages