All forum activity

#DateUserForumTypeThreadPost
4883729 Mar 2015 @ 09:46 PDTteradatauser2ViewpointReplyWhat Teradata products would you like to see in Viewpoint? Hi, 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...
4883628 Mar 2015 @ 10:35 PDTteradatauser2DatabaseReplyPerformance with pertitioned table Hi, Why dont you cast    STRT_DT TIMESTAMP(0)   to date and partition on it. Starting TD14, you can use the column in where predicate by casting to date and ge...
4883528 Mar 2015 @ 10:12 PDTteradatauser2DatabaseReplyTo split the data in percentage in large table and to load to subtablesHi, 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...
4883428 Mar 2015 @ 07:51 PDTVandeBergBDatabaseReplyTo split the data in percentage in large table and to load to subtablesHow are you defining the first 25%? Is there some criteria in play? or just the top 25% of the rows?
4883328 Mar 2015 @ 02:09 PDTsharib hussainDatabaseReplyLocking Table for ShareThanks Fred :)
4883228 Mar 2015 @ 01:21 PDTULICKERTToolsReplyMerging of Bteq and shell scriptsHi, you may just use a 'Here-script' #!/usr/bin/ksh LOGON='.logon $TDPID/$user,$tdwallet($user)' variable='MYDatabase.MyTable' bteq <<-END create table $variab...
4883128 Mar 2015 @ 10:30 PDTFredDatabaseReplyLocking Table for ShareYes, SHARE is a (deprecated) synonym for READ.
4883028 Mar 2015 @ 09:12 PDTJerryLusaDatabaseTopicIntentionally Stale Bookend Statistics to get past inconsistent right-side stats extrapolation by query optimizerHere'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...
4882928 Mar 2015 @ 04:21 PDTChethana08DatabaseTopicTo split the data in percentage in large table and to load to subtablesHi 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...
4882827 Mar 2015 @ 04:08 PDTsharib hussainDatabaseTopicLocking Table for ShareCan 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 ...
4882727 Mar 2015 @ 03:54 PDTsharib hussainDatabaseReplyTeradata 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...
4882627 Mar 2015 @ 03:28 PDTdnoethDatabaseReplyHow to find if a varchar field has 9 digit intergersWhat'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...
4882527 Mar 2015 @ 03:18 PDTdnoethGeneralReplyDatatype of a column from dbc tablesThis 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...
4882427 Mar 2015 @ 03:09 PDTFredDatabaseReplyHow 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...
4882327 Mar 2015 @ 02:57 PDTFredDatabaseReplyHow 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...
4882227 Mar 2015 @ 02:36 PDTFredGeneralReplyDatatype of a column from dbc tablesAre 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...
4882127 Mar 2015 @ 02:15 PDTFredDatabaseReplyCreating function returning DATE from tableTrue, 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...
4882027 Mar 2015 @ 02:03 PDTravimansDatabaseReplyPerformance with pertitioned tableIt won't increase the performance.
4881927 Mar 2015 @ 12:12 PDTpleinoToolsTopicLoading 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,...
4881827 Mar 2015 @ 12:11 PDTdnoethGeneralReplyIs 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 ...
4881727 Mar 2015 @ 10:13 PDTVandeBergBGeneralReplyIs 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;
4881627 Mar 2015 @ 09:50 PDTJun.WuConnectivityReplydead 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...
4881527 Mar 2015 @ 09:36 PDTnaveed_4481mGeneralTopicIs 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  Ex: sel * from table_a where ID not in ( sel ID from table_b)  1. would like to whether...
4881427 Mar 2015 @ 09:03 PDTtomnolanConnectivityReplydead 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.
4881327 Mar 2015 @ 08:14 PDTJun.WuConnectivityReplydead 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. Best regards, Jun

Pages