#DateForumTypeThreadPost
64318 Nov 2013 @ 08:11 PSTDatabaseReplyStart from specific sql in Stored Procedurecheck the manuals  you have if then else and case construct to achive what you want. Ulrich
64218 Nov 2013 @ 02:10 PSTToolsReplyInstalling BTEQ / MLoad on Windows 7Hi Peter, the TTU is downwards compatible usually - Not 100% sure if 14.10 would still work with R5 systems. But it will work with 13.10. But all components need to be on the same level. So MLOAD...
64114 Nov 2013 @ 12:03 PSTDatabaseReplyProblems with the CASE structureHi, T1 = TRIM(TRAILING FROM Str1) type(TRIM(TRAILING FROM Str1) ) states that this is a varchar(10) - so you put in a char(10) and convert it to a varchar(10). -> LT1 = CHARACT...
64013 Nov 2013 @ 08:43 PSTDatabaseReplyfetching data by joining 2 tables in a viewit sounds you have some kind of combinatoric problem. Can you explain why the data is stored in this way and what you achieve with these joins? For a chance to understand your problem you would...
63908 Nov 2013 @ 08:01 PSTDatabaseReplyProblems with the CASE structureHm, not 100% sure but row one is stored as '          ' in the char field and '' in the varchar field to my understanding. Given your code the case result...
63808 Nov 2013 @ 06:53 PSTDatabaseReplyDynamic Table Nameswhat is the reason for creating one table per month? Can't you have one table and partition it by a date colume with RANGE_N each month?
63708 Nov 2013 @ 06:32 PSTDatabaseTopicAlgorithm and sql ways for Sorting and matching data IIHi, I was not able to post to the orig post at http://forums.teradata.com/forum/database/algorithm-and-sql-ways-for-sorting-and-matching-data#comment-118553 So here a try to overcome the techica...
63608 Nov 2013 @ 04:19 PSTDatabaseReplyJoining tables from two different serverswhat do you want to achive this this join?
63527 Oct 2013 @ 11:10 PDTDatabaseReplyNeed help with "TIMESTAMP WITH TIME ZONE"A bit of ugly but it shoud use the 3-4 partitons only SELECT * FROM Test_Table1 WHERE TestCol1 between timestamp '2013-09-30 00:00:00' and timestamp '2013-10-02 23:59:59' and ...
63425 Oct 2013 @ 12:32 PDTToolsReplyMulti load through java application.read the terms for Teradata Express - it's a development license and is not allowed for production. also read the inital comment from tomnolan JDBC fastload into empty table and merge can do w...
63321 Oct 2013 @ 04:34 PDTToolsReplyWhere can I find BTEQ?no, so far bteq and the other utilities are not supported on Mac OS. Only TD Studio is available for Mac OS.
63217 Oct 2013 @ 07:46 PDTDatabaseReplySub query vs OLAP approachHi Khurram, what do you mean with row at a time for the corelated subquery. The correlated subquery example below seems to be set based operations to me - not so effcient as the OLAP query in thi...
63116 Oct 2013 @ 03:46 PDTDatabaseReplyprimary index in IN clause or exists clause >?the datatype need to match and both columns need to be PI on the table.  And again - check the explain. Is one of the tables redistributed? In case yes, no PI join. You could also rewirte yo...
63015 Oct 2013 @ 11:40 PDTDatabaseReplyprimary index in IN clause or exists clause >?it will depend if id is the pi of table_b and id has the same data type as emp_id. you can veryfy be your own by reading the explain. 
62914 Oct 2013 @ 01:45 PDTDatabaseReplyUse of Analytical Functions in Join Indexfrom the manuals:   Aggregate Join Indexes An aggregate join index is a join index that specifies SUM or COUNT aggregate operations. No other aggregate functions are permitted in the defini...
62803 Oct 2013 @ 11:32 PDTDatabaseReplywhat happens when you drop a table that is used in a running insert query?what makes you sure that the table is droped while the insert/select is still running? Did you checked the DBQL records for the two statements? Do you still see the insert/select session in viewpoi...
62703 Oct 2013 @ 09:34 PDTToolsReplyConverting Binary extracted file using TPT to ASCII?Do you use any ETL tool for the file processing? Given your comments so far I would assume not and in this case I doubt it will be more efficient to do the past processing instead of exporting dir...
62603 Oct 2013 @ 09:31 PDTGeneralReplySpecifying 'Locking row for Access' in a View of two viewsdid you try an explain for the selects? It is stating which actual locks are set for the select. Is the join a PI join? Ulrich
62503 Oct 2013 @ 05:56 PDTToolsReplyConverting Binary extracted file using TPT to ASCII?you are right ;-) try google and search binary to ascii linux  I saw some possible solutions there. How big was the difference (binary compared to ascii) on your system?
62403 Oct 2013 @ 04:13 PDTDatabaseReplyCASE statement in SQLtry to avoid implicit conversions.    If you compare with a char constant on the righ side make sure the left side is also char. something like coalesce(trim(cast(id as varchar(11))),&...
62323 Sep 2013 @ 11:53 PDTGeneralReplyhow to select multiple variables with same prefixno, it's not possible to specify something like select v_1--v_100 you can generate the columnlist with SQL and copy paste the needed columns into your statement something like select case ...
62220 Sep 2013 @ 07:35 PDTDatabaseReplyPlease help me on BT/ET and ROLLBACK/ABORTHm, what you do is 1. Begin a transaction 2. Ins/select - at the end of the Ins/Select the transaction is still open. 3. End the transaction (Insert / Select is commited) 4. Rollback - What do...
62120 Aug 2013 @ 11:26 PDTDatabaseReplyLike Operator in TeradataHi, databasename has length 30 so like'H%DB' will only work for databasenames which are actually 30 characters long. an so use trim(databasename) like 'H%DB' Ulrich
62020 Aug 2013 @ 03:59 PDTAsterReplyAster_function load_from_teradataMost likely to be a network issue where is can be very ugly to track this down as the issue can be on every layer (VM, host, firewall...).  Are you sure that your Aster as access to your TD b...
61919 Aug 2013 @ 12:16 PDTAsterReplyAster_function load_from_teradataHi, the my_driver table is some kind of dummy and should be exactly defined as in the example. The code below works for me Ulrich CREATE TABLE mr_driver( c1 INT) DISTRIBUTE BY HASH (c1) ; ...

Pages