#DateForumTypeThreadPost
4116 Jan 2012 @ 07:40 PSTDatabaseReplyHow to cleanse non numeric characters from a field? How Long is the char(x) / varchar(x) fied definition?
4016 Jan 2012 @ 06:41 PSTDatabaseReplyHow to cleanse non numeric characters from a field? how does  1,30823E+12        - has to be 130823 comply with  and finally, there are some UNICODE characters ("Ю" and "Е"which have...
3913 Jan 2012 @ 05:22 PSTDatabaseReplyCreating a Percentage select col_group, column_a * 100.0000 / sum(column_a) over (partition by col_group rows) from table   check the SQL manual on orderd analytical functions
3812 Jan 2012 @ 10:24 PSTDatabaseReplyCheck row is Numeric or not Check the http://developer.teradata.com/blog/madmac/2010/03/a-few-basic-scalar-string-udfs there are some very good UDFs
3710 Jan 2012 @ 02:26 PSTDatabaseReplyCumulative calculation problem I think you need to follow a two step approach. The following might work. Set up a STG table with some example data create table csum_stg as ( Select cast(random(1,10) as integer) ...
3609 Jan 2012 @ 11:49 PSTDatabaseReplytimestamp of commit not to my knowledge
3509 Jan 2012 @ 11:30 PSTDatabaseReplyKeep Duplicate Rows Is NO_TAX_ID skewed? How many vprocs do you have? And regarding "it took an hour to get through one million records" I guess this is referring to the acquisition phase - co...
3409 Jan 2012 @ 03:42 PSTDatabaseReplyRemoving leading or trailing tabs... :-) - yes, this is nice, I always forget this option in trim...
3309 Jan 2012 @ 12:09 PSTDatabaseReplyRemoving leading or trailing tabs... And check also  http://developer.teradata.com/blog/madmac/2010/03/a-few-basic-scalar-string-udfs there are some very useful udfs...
3209 Jan 2012 @ 12:01 PSTDatabaseReplyRemoving leading or trailing tabs... you can use a simple substr  like  case when substr(cola,1,1) = '\t' then substr(cola,2) else cola end for leading '\t' need to be replaced with a tab.....
3107 Jan 2012 @ 12:10 PSTDatabaseReplyVOLATILE TABLE - Where is it located? did you specify ON COMMIT PRESERVE ROWS?
3006 Jan 2012 @ 12:54 PSTDatabaseReplydistribution and access details for fallback amps   Jim, yes you are right - I used the wrong term, was thinking of the cabinet - but this depends on your HW...    Section AMP Clustering and Fallback in the Database A...
2905 Jan 2012 @ 12:01 PSTDatabaseReplydistribution and access details for fallback amps Check the manuals on the HashMaps - there exits two. One primary, one for the fallback. The two hashmaps gurantees that the fallback data will be placed on a different cluster.  In case...
2804 Jan 2012 @ 11:50 PSTDatabaseReplyTrying to get correct rank order I am not sure that I understand your requirement corrently. Can you give us some examples data with your expected results? Why do you group by here? Shouldn't be needed...
2722 Dec 2011 @ 02:40 PSTToolsReplyBTEQ :Multi user login for two tables No, one session is related to one user.   So you need to give the user the right to access both tables.  
2622 Dec 2011 @ 01:02 PSTGeneralReplyHierarchies I think you can extend to 20 on your own...     create table relation (child char(2), parent char(2) ) primary index (parent); insert into relation values ('...
2521 Dec 2011 @ 07:27 PSTGeneralReplyHierarchies did you checked recursive queries I am pretty sure that you can find a solution for your problem with this feature.  
2421 Dec 2011 @ 07:20 PSTToolsReplyFASTEXPORT SEQUENCE NUMBER IN OUTPUT FILE not right away. things you would need to do: 1. maintain the sequence number within your TD systems and store the current value in a table. Which would contain only one row. 2. expor...
2320 Dec 2011 @ 11:47 PSTToolsReplyFASTEXPORT SEQUENCE NUMBER IN OUTPUT FILE Which other information do you want to use in your header record? Can you use TPT? It can write append.
2218 Dec 2011 @ 10:39 PSTToolsReplyFASTEXPORT SEQUENCE NUMBER IN OUTPUT FILE Where do you want the sequence number? In the file name or a sequence number per row?
2112 Dec 2011 @ 11:42 PSTDatabaseReplyOptimizing Between clause operation. hm, 50% is not a high selctivity for a 200m row table and an NUSI. In fact I wonder why the index is used in a single table query - do you only count(*) in this querys. without knowing the d...
2008 Dec 2011 @ 03:22 PSTDatabaseReplyOptimizing Between clause operation. Check the documentation - in the SQL Reference there is a Temporary Table Support. NUSI - did you check the value ordered NUSI? Selectivity - assume the 200 mio rows. How many rows would...
1907 Dec 2011 @ 12:05 PSTDatabaseReplyOptimizing Between clause operation. Did you tried to combine the start_date and end_date in a period data type and define a temporal table with valid time? But I don't have performance figures on this. You can also try...
1807 Dec 2011 @ 12:29 PSTDatabaseReplyOptimizing Between clause operation. Which DB release you are on?
1730 Nov 2011 @ 11:21 PSTDatabaseReplyCreate table help How about Partitioned Primary Index primary index (col1) partition by (col2); Any condition on col2 would limit the scans of data to the relevant rows.

Pages