All forum activity

#DateUserForumTypeThreadPost
1844312 Feb 2011 @ 12:55 PSTdaggulaUDAReplyI need assistance on modify tableThanks Is there any way to get the identity column for the created table? can you tell me the datatype attribute like check,minvalue,maxvalue...etc? Thanks Regards Ashok Reddy Daggula
1844211 Feb 2011 @ 02:32 PSTdnoethDatabaseReplyMLPPI questionYou can't do what that, but monthly partitions are exactly what you need, why do you think your approach would perform better? The effort to scan "year 2010" in a table partitoned by month or ye...
1844111 Feb 2011 @ 02:27 PSTmnylinDatabaseReplyMLPPI questionRegardless of if you can do that or not, I don't think it would be terribly useful. The way MLPPI works is that you define a top level set of partitions. In your example this is the EACH '1' YEAR...
1844011 Feb 2011 @ 01:33 PSTJim ChapmanUDAReplyI need assistance on modify tableThe Teradata alter table statement does not allow the identity column attribute to be specified or changed, either for an existing column or an added column. Identity columns can be defined only i...
1843911 Feb 2011 @ 12:38 PSTGKiferDatabaseTopicMLPPI questionThe use of MLPPI is of interest to me and I have a question that I cannot seem to find resources on, here is what I am having an issue with. . . We currently partition on date_loaded and I would ...
1843811 Feb 2011 @ 11:05 PSTmnylinDatabaseReplycode check For step-level information, the step number corresponds to the step number in the explain plan. Take a look at the DBQLExplainTbl to see the explain plan as it was generated at execution time and ...
1843711 Feb 2011 @ 10:03 PSTakhil.bansal@gmail.comToolsTopicMultiload on Teradata 12 desktop edition hung.Hello all, I am facing a strange problem where in my mload script goes into hung state while loading the data. The solution that works for me is to restart the Teradata while MLoad is in hung st...
1843611 Feb 2011 @ 05:12 PSTJustMeConnectivityTopicCONNECTIVITY ERROROne of our application teams just installed TTU13.0 on a server. When trying to connect, they receive the following error: [.NET Data Provider for Teradata[]1150009] Message truncation error, n...
1843511 Feb 2011 @ 05:09 PSTl.kDatabaseReplycode check Hi, We are using TD12 version... 2.Collect stats. is upto date 3. Can you please help me out how to see the DBQL steps to determine the longest step (in DBQLsteptbl ,i see the s...
1843411 Feb 2011 @ 04:57 PSTdaggulaUDATopicI need assistance on modify tablehere is my create table query : create table test( testid int check(testid < 100 and testid > 1000), testname varchar(100) uppercase ...
1843311 Feb 2011 @ 04:24 PSTAnnaKConnectivityReplyThe managed provider 'Teradata.Client.Provider' could not be instantiatedOK, so I found the problem. It had actually nothing to do with the Teradata provider, instead this error message derived from my service account not being correctly set up. I stopped the analysis s...
1843211 Feb 2011 @ 02:54 PSTpixzerToolsReplyTdBench V5 database release supportwaiting for answer too...
1843111 Feb 2011 @ 12:54 PSTAnnaKConnectivityReplyThe managed provider 'Teradata.Client.Provider' could not be instantiatedUpdate: I never mentioned that the database server (Server3) is actually in another domain. I guess this can have an impact when impersonating the service account in SSAS. But would an impersonatio...
1843010 Feb 2011 @ 01:54 PSTemilwuDatabaseReplyConcatenation in INNER Join -Performance Issue...generally a design issue. when functions (including string concatenation) is used optimizer is not able to use statistics on table to generate plan. for your case here, there should be no differenc...
1842910 Feb 2011 @ 01:35 PSTmnylinDatabaseReplycode check I'll start with the basic questions first. 1. Have you evaluated the explain plan for anything suspicious like a product join? I'd expect to see at least one given your cross join condition. ...
1842810 Feb 2011 @ 01:29 PSTmnylinDatabaseReplyTrying to create a table that has a PPI that partions by hour.Depending on your version of Teradata, you can only partition by integer fields (or fields that can be expressed as integers, like dates). Timestamps don't qualify. I think that might be availabl...
1842710 Feb 2011 @ 01:21 PSTmphippsAnalyticsTopicrow concatenation for dummies? AKA oracle wm_concat() teradata equivalentI've been looking for a solution to this, and I found this: http://forums.teradata.com/forum/enterprise/concatenating-different-values-in-a-field but I'm just not able to figure out how to make it ...
1842610 Feb 2011 @ 01:18 PSTemilwuToolsReplyTPT Stream Operator Bug?Stream operator is no different from TPUMP. if your try to update a PI (primary index, not primary key, the physical pi), i do not think it is possible. If you looks closely what is happening u...
1842510 Feb 2011 @ 10:01 PSTRLineDatabaseTopicTrying to create a table that has a PPI that partions by hour.High I am trying to create a table with a PPI that partions by hour but keep getting a 3732: The facility of a test value with a data type other than integer or DATE has not been implemented yet....
1842410 Feb 2011 @ 09:03 PSTl.kDatabaseTopiccode check Hi All, This query is taking more than 3 minutes .query is given below SELECT RANK(dt1.Source_Value) + dt2.Max_Key (INTEGER) AS Ranked_Id , '-'|| CAST(Ranked_Id AS CHAR(10)) (CHA...
1842310 Feb 2011 @ 01:36 PSTAnnaKConnectivityTopicThe managed provider 'Teradata.Client.Provider' could not be instantiatedHi! This might very well be an easy problem to solve - but I obviously need help doing so. I'm using a dev environment (BIDS) on Server1 (Windows Server 2008 x64). Analysis Services is runnin...
1842209 Feb 2011 @ 08:21 PSTsteverViewpointReplySMS alerts through View PointYes, the workaround is to use the email functionality in Viewpoint to send SMS messages. Each wireless carrier has an email format that includes the mobile phone number and a specific domain name ...
1842109 Feb 2011 @ 03:06 PSTsnikolaevToolsReply Can't install SQL Assistant 13.0.0.3Thanks for reply, Mike. Uninstalling .NET 4.0 didn't help though. I'll ask my admins to get the latest SQLA.
1842009 Feb 2011 @ 02:52 PSTMikeDempseyToolsReply Can't install SQL Assistant 13.0.0.3I think the problem is that you have .Net Framework 4.0. Our older install scripts do not allow for 4.0, only 2.0 thru 3.5. We fixed this problem in SQLA 13.10.0.1 (latest is 13.10.0.4) and i...
1841909 Feb 2011 @ 12:17 PSTsnikolaevToolsTopic Can't install SQL Assistant 13.0.0.3Hi, I have Windows Server 2003 SP2 64 bit and I spent last few days trying to install SQL Assistant. It fails to install. The Message I get is: This setup requires the .NET Framework 2.0 or gre...

Pages