3753 | 05 Jun 2015 @ 08:35 PDT | Database | Reply | Concatenate using || causes null | This is Standard SQL behaviour, use COALESCE(field,'').
|
3752 | 05 Jun 2015 @ 08:30 PDT | Database | Reply | timestamp problem | Teradata can't use single digit month/day/hour, you might try TO_TIMESTAMP instead:
to_timestamp(upper(col1), 'mm/dd/yyyy hh:mi:ss am')
|
3751 | 05 Jun 2015 @ 07:38 PDT | Teradata Applications | Reply | Why TPT is successful with return code 0, even when records goes to ET table? | Hi Chandu,
and now for something completely different :-)
0008 SET RECORD VARTEXT "»" DISPLAY_ERRORS NOSTOP;
Total Error Table 1  ... |
3750 | 05 Jun 2015 @ 05:02 PDT | Database | Reply | Reg Rules and Limitations for Dynamic Result Sets | Hi Lav,
have a look at ALLOCATE:
http://www.info.teradata.com/htmlpubs/DB_TTU_15_00/index.html#page/SQL_Reference/B035_1148_015K/ch03.139.001.html
|
3749 | 05 Jun 2015 @ 04:42 PDT | General | Reply | Tuning query | There're no matching PI, so the optimizer needs to do some preparation steps and the estimated time is quite close to the actual runtime, so maybe you can't speed it up...
The esti... |
3748 | 05 Jun 2015 @ 04:25 PDT | General | Reply | CASE is a solution? | Can you show some sample data and expected result?
|
3747 | 05 Jun 2015 @ 04:21 PDT | Database | Reply | No More Spool Space Issues | What's the Explain and the actual resource usage from QryLogStepsV?
The Tables are having millions of records. If we simply select and execute the subquery it will give some billions of rec... |
3746 | 05 Jun 2015 @ 04:16 PDT | Database | Reply | timestamp problem | You need to define the input as a VarChar instead of a timestamp (and your format doesn't match the input):
USING
(
COL1 VARCHAR(16)
)
INSERT INTO XXX.TIME_TABLE VALUES
(
CAST (:COL... |
3745 | 05 Jun 2015 @ 04:13 PDT | Database | Reply | Collect stats taking long time | Hi Srichakra,
in 14.10 it's not recommended
to collect stats individually
to drop and recreate stats
There's an Orange Book on the new functionality in TD14.10, addit... |
3744 | 05 Jun 2015 @ 04:00 PDT | Teradata Applications | Reply | Why TPT is successful with return code 0, even when records goes to ET table? | Hi Chandu,
where in the FastLoad log did you find that information?
Only the number of errors is returned.
|
3743 | 04 Jun 2015 @ 03:10 PDT | Database | Reply | Import Null Values | insert into mytable (column4) values (?);
And don't forget to add COMPRESS to the remaining 3 columns.
|
3742 | 04 Jun 2015 @ 10:01 PDT | General | Reply | INMOD and UDF library listing | Hi Sam,
what exactly are you trying to do?
Maybe the FROM_BYTES function is what you need:
select from_bytes('1234567890abcdef'xb, 'base16')
http://www.info.teradata.com/HTMLP... |
3741 | 04 Jun 2015 @ 09:39 PDT | General | Reply | Tuning query | What's the Explain of the Insert/Select?
Did you check the QueryLog which steps are slow?
|
3740 | 04 Jun 2015 @ 09:14 PDT | Teradata Applications | Reply | Why TPT is successful with return code 0, even when records goes to ET table? | Hi Chandu,
afaik this is not possible, but this was the same for FastLoad :-)
|
3739 | 04 Jun 2015 @ 09:09 PDT | Teradata Studio | Reply | Load Limit of 50K Rows in v15.10 | I just tried it and it's the same bug in Studio 15.10.00.201504221135 on my Mac :-)
|
3738 | 04 Jun 2015 @ 08:09 PDT | Teradata Studio | Reply | Load Limit of 50K Rows in v15.10 | Is the target table a SET table and FastLoad removed duplicate rows silently?
|
3737 | 04 Jun 2015 @ 07:34 PDT | Tools | Reply | When are secondary indexes required? | Hi Mahesh,
you're correct, this index is totally useless as 'c2' is already partitioned by day.
|
3736 | 04 Jun 2015 @ 07:33 PDT | Teradata Applications | Reply | Why TPT is successful with return code 0, even when records goes to ET table? | Hi Chandu,
FastLoad exits with "Highest return code encountered = '0'" if there are any rows in the Error Tables.
Only when you specify an ErrorLimit the job will fail, th... |
3735 | 04 Jun 2015 @ 07:15 PDT | Teradata Studio | Reply | Load Limit of 50K Rows in v15.10 | How did you check it, SELECT COUNT(*) FROM tab?
|
3734 | 03 Jun 2015 @ 03:00 PDT | General | Reply | CYlinder size | Without access to DBA tools, the easiest way is:
CREATE VOLATILE TABLE vt, DATABLOCKSIZE = 20 KBYTES(i INT)
If this returns an error message your system uses large cylinders.
On those systems... |
3733 | 03 Jun 2015 @ 12:42 PDT | Database | Reply | SQL query to find given IDs not in table | You need to split the list of values into rows:
WITH cte AS
(
SELECT CAST(token AS INT) AS id
FROM TABLE (STRTOK_SPLIT_TO_TABLE(1, '1991,1992,1993', ',')
RE... |
3732 | 03 Jun 2015 @ 12:39 PDT | Database | Reply | How to get sequence numbers for a particular group based on consecutive values | Hi Javed,
in fact this is not a dense rank, but a similar problem:
select dt.*,
sum(flag) over (partition by ManagerName
order by VisitDate
rows unb... |
3731 | 02 Jun 2015 @ 04:47 PDT | General | Reply | SQL Sub Queries | Hi Shoaib,
this is usually done using HAVING plus CASEes:
SELECT Appl_id
FROM tab
GROUP BY Appl_id
HAVING SUM(CASE WHEN Security_Type = 'Misc' THEN 1 ELSE 0 end) > 0
AN... |
3730 | 02 Jun 2015 @ 04:33 PDT | Database | Reply | Teradata Express database instance - why no Windows version | Teradata is no longer supported on Windows.
Now as a Virtual Machine you can run it whereever you want, Linux/Windows/Mac.
It requires you to install a VM Player, but previously you needed admin ... |
3729 | 01 Jun 2015 @ 02:55 PDT | Database | Reply | How to substract exactly one month | If this is correct or not depends on the definition of "exactly one month" :-)
You might want Oracle's definition:
oAdd_Months(2015-02-28,-1)
is supported in TD14
|