#DateForumTypeThreadPost
33713 Aug 2014 @ 04:17 PDTDatabaseReplyUnicode dataWhat tool are you using? In bteq: set session charset In SQLA: depends on the connection (ODBC/.Net), but it's all in the connection parameters window. In java (Teradata Studio/Eclipse) conn...
33613 Aug 2014 @ 02:32 PDTDatabaseReplyUnicode dataCheck your session character set. It MUST be unicode. It is working for me as expected: CREATE TABLE ECI_D.PRUEBAUNI(C_TXT VARCHAR(25) CHARACTER SET UNICODE); INSERT INTO ECI_D.PRUEBAUNI VALUES ...
33513 Aug 2014 @ 12:38 PDTDatabaseReplyUnicode dataIf the result of TRANSLATE_CHK() is 0 then all the characters can be translated without error (all the characters are "latin" -note the double quotes-) HTH. Cheers. Carlos.
33413 Aug 2014 @ 12:21 PDTDatabaseReplyUnicode dataYou may take a look at TERADATA FUNCTION TRANSLATE_CHK() HTH. Cheers. Carlos.
33311 Aug 2014 @ 08:13 PDTGeneralReplyRecursive sql with Left outer joinThe logic is not clear, since Table2 is missing in the required 'Resulting table'. 'abc', '123', '234'... No DDL, no REAL SQL, not a single piece of the progress ma...
33229 Jul 2014 @ 06:42 PDTDatabaseReplyTimestamp FormatHi: BTEQ -- Enter your SQL request or BTEQ command: SELECT CAST(CAST(CURRENT_TIMESTAMP(6) AS TIMESTAMP(6) FORMAT 'YYYY-MM-DDbhh:mi:ss.s(6)') AS VARCHAR(26)); *** Query completed....
33128 Jul 2014 @ 07:59 PDTDatabaseReplyHashBufferSizeI think you're a little bit disoriented... HashBufferSize is a parameter that Oracle uses to reserve memory for the hash tables in the hash joins. Cheers. Carlos.
33025 Jul 2014 @ 01:45 PDTDatabaseReplyerror in UPDATE statementDieter: I stick to my guns ;-) You cannot use table qualificator in the SET part of the update: "SET t1.TABLE_SIZE = t2.corrente -->  SET TABLE_SIZE = t2.corrente" C...
32924 Jul 2014 @ 08:48 PDTDatabaseReplyerror in UPDATE statementHi. Sorry for jumping in... You cannot use alias on the 'SET' part of the UPDATE: "set TABLE_SIZE = t2.corrente" should work HTH. Cheers. Carlos.
32814 May 2014 @ 01:04 PDTToolsReplyTPT script : syntax error at "VARCHAR"; Attribute definition must end with a comma ',' VARCHAR TdpId = 'LocalTd', HTH Cheers. Carlos.  
32730 Apr 2014 @ 06:59 PDTToolsReplyTPT script loading issueFastload (or TPT load operator) doesn't load duplicated rows, no matter if table is SET or MULTISET  (NoPI tables are an exception to this). If you need to load duplicates you must use mu...
32629 Apr 2014 @ 09:08 PDTCloud ComputingReplyTD-14 VM Ware IssueClark: The 14.10 VM on SUSE11 is very faulty. It starts iceVM instead of any 'regular' one, it has trouble with pango and the Teradata Studio/eclipse, no start gnome-session... etc I had ...
32529 Apr 2014 @ 12:26 PDTDatabaseReplyDBC.AccessLogThe purging of the AccLogTbl is not automatic. Once you start it, it stores the information whithout any limit of space or time. If you say you've got only three months, then someone is purging...
32428 Apr 2014 @ 05:16 PDTGeneralReplyRecursive Query - Cannot Have Aliases Whose Names Matches Recursive Name ... SELECT * FROM TSD_Candidate_Treatment WHERE a.Treatment IS NOT NULL   <-- This 'a.' reference is wrong ORDER BY CandidateID, Step_Order;   C...
32328 Apr 2014 @ 12:03 PDTDatabaseReplyCumulative Sum by distinct customer ID by yearHi Dieter: Agreed with the horrible query plan. Agreed with the scalar subqueries (I don't like them either). BUT: Sometimes the simplicity of the query can be a adequate solution for many u...
32225 Apr 2014 @ 12:40 PDTDatabaseReplyCumulative Sum by distinct customer ID by yearHi all: Sorry for jumping in (and jumping in late) I'm not sure about requirements but doesn't a scalar subquery do the trick? SELECT a.year,        count...
32118 Oct 2013 @ 11:00 PDTAnalyticsReplySuggestions to clean up phone numbersHi. It seems oTranslate() + SUBSTR() could do the trick. Cheers. Carlos.
32018 Oct 2013 @ 10:56 PDTConnectivityReplyHibernate, blob and large filesHi. I don't know much about hibernate (I've learnt enough to hate it though) but, why does your 2MB BLOB column seem to have a 64KB format? Cheers. Carlos.
31918 Oct 2013 @ 10:51 PDTExtensibilityReplyOracle functions in TD 14Wim: Talking about performance, we did some test after migrating from TD12 to TD14. We noticed that the new embedded functions were about 5 times faster than the old UDF's. A simple test case...
31801 Oct 2013 @ 11:55 PDTGeneralReplyOracle to Teradata SQL equivalents?Derrick: In Teradata DATES are DATES and TIMES are TIMES and TIMESTAMPS are TIMESTAMPS. Forget the Oracle nonsense of using DATES that are actually datetimes. SELECT * FROM YOUR_TABLE WHERE YOUR ...
31723 Aug 2013 @ 04:20 PDTDatabaseReplyMax No Of teradata ConnectionsYou can add PE vprocs. There can be more than one PE per node. Cheers. Carlos.
31620 Aug 2013 @ 11:31 PDTDatabaseReplyLike Operator in TeradataHi. DBC.Columns.DatabaseName is CHAR(30). Trailing blanks matter! Cheers. Carlos.
31513 Aug 2013 @ 06:09 PDTTeradata ApplicationsReplyHow to handle failure statement in Bteq ?Yep, I knew that ;-) I misunderstood the OP. I thought he wanted NOT to stop the inserts. If that's not the case, it may be worth to take a look at 'SET RETRY OFF' and 'SET REPEAT...
31413 Aug 2013 @ 05:14 PDTTeradata ApplicationsReplyHow to handle failure statement in Bteq ?Dieter: I think the answer is the opposite (e.g.: default bteq behaviour). The OP wants the inserts NOT to stop on error... Cheers. Carlos.
31312 Aug 2013 @ 11:47 PDTAnalyticsReplygroup the records based on datePlease STOP asking the same thing over and over. You'd better RTFM ('recursive' could be a good point to start searching, based on your reiterative question) and stop asking others to ...

Pages