|715||29 Sep 2014 @ 07:25 PDT||Database||Reply||Finding PI for a table created already||The PI has two purposes:
1. access and join support
A good PI will serve BOTH purposes and using a automated procedure which focus on distribution will often not result in best p... |
|714||18 Sep 2014 @ 12:05 PDT||Database||Reply||New Features in TD V15||
I have to admit that I find Teradata strategy to let customer pay for new feature information like Teradata 15.0 JSON Integration very odd.
But beside this a usually sta... |
|713||16 Sep 2014 @ 12:23 PDT||General||Reply||What is the purpose of using DBC.SYSEXECSQL?||it is about dynamic SQL.
You can only execute complete SQL's which can be parsed at SP creation time without DBC.SYSEXECSQL.
But sometimes you want to have a SP where you can pass a tabl... |
|712||29 Aug 2014 @ 01:13 PDT||Tools||Reply||TPT: How to forcefully fail the job||How do you invoke TPT?
Linux shell? -> control C
Usually ETL tools also allow to kill current processes.
|711||20 Aug 2014 @ 03:56 PDT||Database||Reply||To find number of null values in each columns of a table||you can make also easily a macro out of this...
|710||20 Aug 2014 @ 03:55 PDT||Database||Reply||To find number of null values in each columns of a table||maybe this gives a hint.
add your databasename and tablename - hit submit
this will generate an SQL which generates the ... |
|709||19 Aug 2014 @ 08:13 PDT||Private Forum |
|708||07 Aug 2014 @ 02:21 PDT||Database||Reply||Tactical queries||Check the CacheFlag in QryLogV
From the documentation:
Possible Values for the CacheFlag Column
T The query is found in step cache.
S The query is a par... |
|707||24 Jul 2014 @ 02:19 PDT||Database||Reply||Complex SQL Scenario||Can you provide SQLs to set up the test data please. Will make it easier to check the options.
How do you distinct rule 1 and 2 (e.g. rule 2 example data also is also comply to rule 1). Same is tr... |
|706||21 Jul 2014 @ 07:06 PDT||Database||Reply||How to check what values are passed to procedure call from qrylog table ?||you have to change your SP to log the information. Using queryband could be efficient
SET QUERY_BAND = "PROCEDURE_NAME=yourSP;PROCEDURE_IN_PARAM=param1name:param1value|param2name... |
|705||18 Jul 2014 @ 02:31 PDT||Database||Reply||SQL statement wanted||Try the following:
create table t1
(OUTLET_ID integer, DATE_ID date, QUALITY_FLAG integer
) no primary index ;
insert into t1 values (1,date-5,1);
insert into t1 values (1,dat... |
|704||17 Jul 2014 @ 04:43 PDT||Database||Reply||Group by on a Group by not working as expected!!!||Can you explain why you think you need the two group by?
What is the difference to
SELECT EXTRACT(YEAR FROM D) AS Y, SUM(V) AS V
GROUP BY Y
|703||08 Jul 2014 @ 12:36 PDT||Database||Reply||Can we able to perform all the ETL activites by using VIEWS ?????||Check you TASM setting and discuss it with your DBAs
|702||08 Jul 2014 @ 12:32 PDT||General||Reply||teradata viewpoint from SQL assitanct||check dieters comment at http://forums.teradata.com/forum/database/active-running-queries
|701||08 Jul 2014 @ 12:25 PDT||General||Reply||time difference in minutes||this should do
select cast('2014-06-16 23:33:52' as timestamp(0)) a,
cast('2014-06-16 22:36:22' as timestamp(0)) b,
a-b Minute(4) to Second c,
extract(minute from c) + e... |
|700||03 Jul 2014 @ 06:27 PDT||General||Reply||If we see a GTT table definition,there is a LOG.Can anyone please tell me.||From the documentation:
whether transient journaling occurs for a global temporary or volatile table or not. This option pertains to global temporary and volatile tables only.
|699||03 Jul 2014 @ 12:22 PDT||Database||Reply||Create a table with a date column that has a default lenght (8)||It is always easier if you share some example code...
Some clarification - a date data type is stored as 4 byte. Always.
What you can specify is the format how the date is shown, but this does no... |
|698||30 Jun 2014 @ 12:23 PDT||Database||Reply||Skewfactor||Values < 1 are OK. You might not getting better even if you use a UPI - depending on your number of rows and number of vprocs.
But as so often there are no fix numbers to say what is acce... |
|697||30 Jun 2014 @ 12:16 PDT||General||Reply||In BTEQ if we want to go forward we use condititional logic (if ..then GO TO .Label name).By using BTEQ can we go backward?||Hi,
no, you can't go backwards with an .goto statement.
|696||26 Jun 2014 @ 02:51 PDT||General||Reply||If hash collision occurs,how can we rectify this issue.||Hi,
can you provide some more details of your problem? What is the issue with the hash collision?
|695||24 Jun 2014 @ 11:48 PDT||Database||Reply||Types of Tablekind||your can run a
select tablekind from dbc.tables group by tablekind order by tablekind;
so see which are currently existing in your system.
By the way tablekind is very much misslea... |
|694||05 Jun 2014 @ 02:26 PDT||Database||Reply||How to calculate a character occurance in a string in teradata||which version are you on?
|693||15 May 2014 @ 11:24 PDT||General||Reply||Number of bytes-BIGINT||There is no doubt - 8 bytes
from the manuals - SQL Data Types and Literals
"BIGINT values are stored as eight bytes with the least significant byte first."
|692||14 May 2014 @ 01:01 PDT||Database||Reply||How to calulate Skew on Join Index||The join index is created by an SQL therfore using this SQL as a derived table should give you the right info.
SELECT HASHAMP(HASHBUCKET(HA... |
|691||13 May 2014 @ 04:46 PDT||Database||Reply|| incremental planning and execution (IPE)||yes, I used "only" 1 Mio rows on the PPI table.
But the SSI queries also contained a UPI access so should be pretty fast. I was wondering where to draw the line and was therefor asking f... |