|643||18 Nov 2013 @ 08:11 PST||Database||Reply||Start from specific sql in Stored Procedure||check the manuals
if then else and
case construct to achive what you want.
|642||18 Nov 2013 @ 02:10 PST||Tools||Reply||Installing BTEQ / MLoad on Windows 7||Hi 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... |
|641||14 Nov 2013 @ 12:03 PST||Database||Reply||Problems with the CASE structure||Hi,
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... |
|640||13 Nov 2013 @ 08:43 PST||Database||Reply||fetching data by joining 2 tables in a view||it 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... |
|639||08 Nov 2013 @ 08:01 PST||Database||Reply||Problems with the CASE structure||Hm, 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... |
|638||08 Nov 2013 @ 06:53 PST||Database||Reply||Dynamic Table Names||what 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?
|637||08 Nov 2013 @ 06:32 PST||Database||Topic||Algorithm and sql ways for Sorting and matching data II||Hi,
I was not able to post to the orig post at
So here a try to overcome the techica... |
|636||08 Nov 2013 @ 04:19 PST||Database||Reply||Joining tables from two different servers||what do you want to achive this this join?
|635||27 Oct 2013 @ 11:10 PDT||Database||Reply||Need help with "TIMESTAMP WITH TIME ZONE"||A bit of ugly but it shoud use the 3-4 partitons only
WHERE TestCol1 between timestamp '2013-09-30 00:00:00' and timestamp '2013-10-02 23:59:59'
and ... |
|634||25 Oct 2013 @ 12:32 PDT||Tools||Reply||Multi 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... |
|633||21 Oct 2013 @ 04:34 PDT||Tools||Reply||Where 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.
|632||17 Oct 2013 @ 07:46 PDT||Database||Reply||Sub query vs OLAP approach||Hi 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... |
|631||16 Oct 2013 @ 03:46 PDT||Database||Reply||primary 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... |
|630||15 Oct 2013 @ 11:40 PDT||Database||Reply||primary 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.
|629||14 Oct 2013 @ 01:45 PDT||Database||Reply||Use of Analytical Functions in Join Index||from 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... |
|628||03 Oct 2013 @ 11:32 PDT||Database||Reply||what 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... |
|627||03 Oct 2013 @ 09:34 PDT||Tools||Reply||Converting 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... |
|626||03 Oct 2013 @ 09:31 PDT||General||Reply||Specifying 'Locking row for Access' in a View of two views||did you try an explain for the selects?
It is stating which actual locks are set for the select.
Is the join a PI join?
|625||03 Oct 2013 @ 05:56 PDT||Tools||Reply||Converting 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?
|624||03 Oct 2013 @ 04:13 PDT||Database||Reply||CASE statement in SQL||try 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))),&... |
|623||23 Sep 2013 @ 11:53 PDT||General||Reply||how to select multiple variables with same prefix||no, 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
select case ... |
|622||20 Sep 2013 @ 07:35 PDT||Database||Reply||Please help me on BT/ET and ROLLBACK/ABORT||Hm,
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... |
|621||20 Aug 2013 @ 11:26 PDT||Database||Reply||Like Operator in Teradata||Hi,
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'
|620||20 Aug 2013 @ 03:59 PDT||Aster||Reply||Aster_function load_from_teradata||Most 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... |
|619||19 Aug 2013 @ 12:16 PDT||Aster||Reply||Aster_function load_from_teradata||Hi,
the my_driver table is some kind of dummy and should be exactly defined as in the example.
The code below works for me
CREATE TABLE mr_driver( c1 INT)
DISTRIBUTE BY HASH (c1) ;