All forum activity

#DateUserForumTypeThreadPost
146724 Jul 2006 @ 08:51 PDTWomperConnectivityReplyEfficiency UDF scalar function vs.conventional SQLnope... found my own issue. 1abcdefg1aany ideas on sql solutions?
146624 Jul 2006 @ 08:21 PDTWomperConnectivityReplyEfficiency UDF scalar function vs.conventional SQLHow bout this one... select * from ( select '1abcdefgha' as test_value from dbc.tables where tablename = 'tables' and databasename = 'dbc' union all select '0000000000' as tes...
146524 Jul 2006 @ 11:41 PDTcarmenUDATopicHow to run a stored procedure please?How to run a stored procedure please?nameofprocedure()
146424 Jul 2006 @ 10:59 PDTjporellDatabaseTopicConvert Varbyte to CharacterI would like to convert the Hostdata column from a TPUMP error table from varbyte to character. I found a UDF (VarbyteToVarchar.c) which said it would do it but I haven't had any luck calling it.
146324 Jul 2006 @ 10:19 PDTalvinyingDatabaseReplyProblem with Recursive ViewBelow is the recursive view. It's created and running fine. The problem is with the outer view encapsulating this recursive view. Teradata simply won't let me create it (the outer view). Keep getti...
146222 Jul 2006 @ 06:06 PDTj355gaDatabaseReplyProblem with Recursive ViewCould you include the DDL for the recursive view?
146122 Jul 2006 @ 02:08 PDTragavDatabaseTopicCodd RulesHi All,I was having a chat with my friend who is a oracle specialist.he was telling that oracle supports 8 E.F.Codd rules and inturn asked me how much teradata Rdbms supports.can anyone answer this...
146021 Jul 2006 @ 04:40 PDTAquent | Marketing IT | LAJobsTopicDirector, Statistical Analysis & Forecasting (Los Angeles, CA w/ relo)Aquent Marketing IT helps Marketing, Creative and IT organizations maximize the return on their data. We partner with our clients to understand their Marketing, Data Management, Business Intelligen...
145921 Jul 2006 @ 03:42 PDTalvinyingDatabaseReplyProblem with Recursive ViewAs a workaround I've created a volatile tableCreate volatile Table B_Temp As (Select *From B) With dataON COMMIT PRESERVE ROWS;And then created the View A based on the B_Temp table.This workaround ...
145821 Jul 2006 @ 12:53 PDTljschwabJobsTopicData Warehouse Architect position at Charles SchwabCharles SchwabData Warehouse ArchitectSan Francisco, CAGroup Objective: It is our objective within the Data Warehouse and Business Information Group to deliver high quality decision support applic...
145721 Jul 2006 @ 07:33 PDTANGELDatabaseReplyNUSI Bitmapping?Hi,If you do collect statistics on all NUSI ,then PE gains the ability to utilize Bit mapping. When multiple NUSI values are compared with AND operator, PE may choose a plan to create NUSI Bit map....
145621 Jul 2006 @ 05:31 PDTgiriToolsReplyMLOAD VARTEXT FORMATThank u.Now I have have got a better idea.
145521 Jul 2006 @ 03:22 PDTUwe PosseltConnectivityReplyTrying to set up ODBC connectionOk, thank you for the information.The package contains TeraGSS 06.01.00.00, TDICU 01.01.01.00 and TDODBC 03.05.00.05Meanwhile I've got a newer TeraGSS 06.01.00.14 by a NCR supporter. I don't know, ...
145421 Jul 2006 @ 01:25 PDTManoj_Kumar_ParmarDatabaseTopicNUSI Bitmapping?Hi All, What is NUSI Bitmapping, is it similar to Oracle Bitmap index or something else...can any body explain it.Thanks in Advance...
145321 Jul 2006 @ 12:40 PDTFredAnalyticsReplyUsing Statistics WizardPrior to V2R6.1, you can't run Index Analysis or Statistics Analysis while Access Logging is enabled (for the user and/or objects in question).
145220 Jul 2006 @ 11:53 PDTJohn MacAnalyticsTopicUsing Statistics WizardWhen attempting to analyse a workload, I get the following message...[NCR][ODBC Teradata Driver][Teradata RDBMS] Statistics Analysis is not allowed when access logging is enabled. [15102]Is this an...
145120 Jul 2006 @ 11:02 PDTrgans_99DatabaseTopicIdentifying a Node in MPPHi all,How do the request from the client send to appropriate Node in the MPP system?The AMP within a Node is identified by Mapping The hash value generated by PE's generator in the Hashmap.(But th...
145020 Jul 2006 @ 11:01 PDTrgans_99DatabaseTopicIdentifying a Node in MPPHi all,How do the request from the client send to appropriate Node in the MPP system?The AMP within a Node is identified by Mapping The hash value generated by PE's generator in the Hashmap.(But th...
144920 Jul 2006 @ 07:08 PDTMeredith at eBayJobsTopicSr. Manager of DataWarehouse Architecture Opportunity at eBay!Are you looking for an opportunity to work with one of the largest Data Warehouse installations in the world? If Dual Active, Multi Temperature Active Data Warehousing is your specialty and you liv...
144820 Jul 2006 @ 04:50 PDTfoxAnalyticsReplystandard deviation function with parition byI found this post -- Although you can't use STDDEV as a window function, the calculations for each of these involve functions that can be done with window aggregates. So, another alternative can be...
144720 Jul 2006 @ 04:12 PDTjkleeDatabaseReply"Teradata Unable to Perform Join"I found the problem. I can't have an aggregation on a column that I am joining on.
144620 Jul 2006 @ 02:47 PDTjkleeDatabaseTopic"Teradata Unable to Perform Join"I have the following join indexed defined:create join index session_base_ji asselect wh.visid_high , wh.visid_low , wh.visit_num , wh.prop49 as user_id , wh.hit_dt , wh.omniture_dtm , pco.client_or...
144520 Jul 2006 @ 02:24 PDTFredDatabaseReplyrisk associated with dynamic sqlTo use SysExecSQL, the user that is the creator of the stored procedure must also be the immediate owner. Statements run via SysExecSQL use the access rights of that user, not the caller.There is t...
144420 Jul 2006 @ 02:16 PDTfoxAnalyticsTopicstandard deviation function with parition byI want to use the STDDEV_SAMP() with the OVER (Partition by) clause.Teradata's standard deviation functions do not allow this. I want to calculate the standard deviation for each subset of data.Any...
144320 Jul 2006 @ 02:01 PDTAlfredoUDAReplyCould I stop an abort session?It's correct, we try to use the sentence but we can do it. Are there some diferent way to do that?

Pages