|48837||29 Mar 2015 @ 09:46 PDT||teradatauser2||Viewpoint||Reply||What Teradata products would you like to see in Viewpoint?||
Can we have a portal in VP to do the L1 activities like - password reset/unlock, getting locking information for an ID, getting user information(from dbc.users), granting roles , roles a... |
|48836||28 Mar 2015 @ 10:35 PDT||teradatauser2||Database||Reply||Performance with pertitioned table||
Why dont you cast
to date and partition on it. Starting TD14, you can use the column in where predicate by casting to date and ge... |
|48835||28 Mar 2015 @ 10:12 PDT||teradatauser2||Database||Reply||To split the data in percentage in large table and to load to subtables||Hi,
You can use a rownum function to give row numbers to all rows based on a column sorting sequence. and then use the rowcout values to split the table in four parts.
ROW_NUMBER() OVER (ORDER BY... |
|48834||28 Mar 2015 @ 07:51 PDT||VandeBergB||Database||Reply||To split the data in percentage in large table and to load to subtables||How are you defining the first 25%? Is there some criteria in play? or just the top 25% of the rows?
|48833||28 Mar 2015 @ 02:09 PDT||sharib hussain||Database||Reply||Locking Table for Share||Thanks Fred :)
|48832||28 Mar 2015 @ 01:21 PDT||ULICKERT||Tools||Reply||Merging of Bteq and shell scripts||Hi,
you may just use a 'Here-script'
create table $variab... |
|48831||28 Mar 2015 @ 10:30 PDT||Fred||Database||Reply||Locking Table for Share||Yes, SHARE is a (deprecated) synonym for READ.
|48830||28 Mar 2015 @ 09:12 PDT||JerryLusa||Database||Topic||Intentionally Stale Bookend Statistics to get past inconsistent right-side stats extrapolation by query optimizer||Here's a clever way to force the query optimizer to follow the same *stable* plan for a query regardless of the data set it runs against. Useful when the data set cardinalities and row co... |
|48829||28 Mar 2015 @ 04:21 PDT||Chethana08||Database||Topic||To split the data in percentage in large table and to load to subtables||Hi All,
I would need a query for below mentioned logic:
1)I have table which has huge data(In terms of Million).
2)I need to split the data into 4 parts(If I consider whole data as 100%,parts wo... |
|48828||27 Mar 2015 @ 04:08 PDT||sharib hussain||Database||Topic||Locking Table for Share||Can anyone tell me something about locking modifier "LOCKING ROW/TABLE/DATABASE FOR SHARE". Is it same as READ lock??
locking table student.employee for share
select * from ... |
|48827||27 Mar 2015 @ 03:54 PDT||sharib hussain||Database||Reply||Teradata database restart?||TRATRACE command can be used to see information about restarts.
If you want to see last 5 restart information, then login to any node and enter tpatrace 5.
You can also use DBC.SW_Event_Log table... |
|48826||27 Mar 2015 @ 03:28 PDT||dnoeth||Database||Reply||How to find if a varchar field has 9 digit intergers||What's your exact TD release, TD14?
Is the source defined as LATIN or UNICODE?
There have been some bugs regarding the RegEx functions, this should have been fixed in recent patch lev... |
|48825||27 Mar 2015 @ 03:18 PDT||dnoeth||General||Reply||Datatype of a column from dbc tables||This is a UDF I wrote some tme ago:
Returns the datatype of a column as a literal
20111012 initial version - Dieter Noeth
20131010 added TD14.10 ARRAY datatypes - dn
20140812 a... |
|48824||27 Mar 2015 @ 03:09 PDT||Fred||Database||Reply||How to check size of the table with compress and without ||With a single row, the difference is only 4 bytes, which is much smaller than the minimum data block size.
What you are seeing in TableSize reflects a table header on e... |
|48823||27 Mar 2015 @ 02:57 PDT||Fred||Database||Reply||How to determine Number of AMPs and Number of Nodes ?||The number of AMPs per node is configured by Teradata when the system is ordered, and is not something the customer can change. In general it depends on the specific hardware configuratio... |
|48822||27 Mar 2015 @ 02:36 PDT||Fred||General||Reply||Datatype of a column from dbc tables||Are you asking about getting the keyword spelled out, e.g. SMALLINT vs. I2? Then the answer is no, that's not in any DBC table.
Depending on what you are trying to do, you might con... |
|48821||27 Mar 2015 @ 02:15 PDT||Fred||Database||Reply||Creating function returning DATE from table||True, SQL UDFs cannot do SELECT.
Why not define a SQL UDF that simply returns a date which is specified as a literal in the function body, and change the other process to do REPLACE... |
|48820||27 Mar 2015 @ 02:03 PDT||ravimans||Database||Reply||Performance with pertitioned table||It won't increase the performance.
|48819||27 Mar 2015 @ 12:12 PDT||pleino||Tools||Topic||Loading from DB2 to Teradata with SSIS 2012 converts content with special characters ("zero characters") to NULL.||
Loading from DB2 to Teradata with SSIS 2012 converts content with special characters ("zero characters") to NULL.
When I hit PREVIEW in SSIS DB2 OLE DB Source component,... |
|48818||27 Mar 2015 @ 12:11 PDT||dnoeth||General||Reply||Is there a way to avoid NOT IN function ||Hi Navy,
you should always try to avoid NOT IN unless both columns (from the inner and outer table) are defined as NOT NULL (that's similar for all DBMSes), because otherwise you have to ... |
|48817||27 Mar 2015 @ 10:13 PDT||VandeBergB||General||Reply||Is there a way to avoid NOT IN function ||select a.* from table_a a left outer join table_b b on (a.id=b.id) where b.id is null;
|48816||27 Mar 2015 @ 09:50 PDT||Jun.Wu||Connectivity||Reply||dead connection from jdbc pool for the first time run ||that is possible but....
from the pool configuration,the maximum pool size is 25, allowed idle connection is 3.
i think in my first run there should be new connection created, how come that is... |
|48815||27 Mar 2015 @ 09:36 PDT||naveed_4481m||General||Topic||Is there a way to avoid NOT IN function ||Hi Team,
Sorry to ask such a simple Question but i didnt find any concrete way to avoid NOT IN
sel * from table_a where ID not in ( sel ID from table_b)
1. would like to whether... |
|48814||27 Mar 2015 @ 09:03 PDT||tomnolan||Connectivity||Reply||dead connection from jdbc pool for the first time run ||Even on the "first run" of your application, all the connections in the connection pool may be old and may have been killed.
|48813||27 Mar 2015 @ 08:14 PDT||Jun.Wu||Connectivity||Reply||dead connection from jdbc pool for the first time run ||Hi,
thanks for the reply.
i will check that point.
but how that can explain my problem? it gives me all dead connection in the first run. no matter how many try I made.