|18443||12 Feb 2011 @ 12:55 PST||daggula||UDA||Reply||I need assistance on modify table||Thanks
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?
Ashok Reddy Daggula |
|18442||11 Feb 2011 @ 02:32 PST||dnoeth||Database||Reply||MLPPI question||You 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... |
|18441||11 Feb 2011 @ 02:27 PST||mnylin||Database||Reply||MLPPI question||Regardless 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... |
|18440||11 Feb 2011 @ 01:33 PST||Jim Chapman||UDA||Reply||I need assistance on modify table||The 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... |
|18439||11 Feb 2011 @ 12:38 PST||GKifer||Database||Topic||MLPPI question||The 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 ... |
|18438||11 Feb 2011 @ 11:05 PST||mnylin||Database||Reply||code 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 ... |
|18437||11 Feb 2011 @ 10:03 PSTfirstname.lastname@example.org||Tools||Topic||Multiload 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... |
|18436||11 Feb 2011 @ 05:12 PST||JustMe||Connectivity||Topic||CONNECTIVITY ERROR||One of our application teams just installed TTU13.0 on a server. When trying to connect, they receive the following error:
[.NET Data Provider for Teradata1150009] Message truncation error, n... |
|18435||11 Feb 2011 @ 05:09 PST||l.k||Database||Reply||code 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... |
|18434||11 Feb 2011 @ 04:57 PST||daggula||UDA||Topic||I need assistance on modify table||here is my create table query :
create table test(
testid int check(testid < 100 and testid > 1000),
testname varchar(100) uppercase
|18433||11 Feb 2011 @ 04:24 PST||AnnaK||Connectivity||Reply||The managed provider 'Teradata.Client.Provider' could not be instantiated||OK, 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... |
|18432||11 Feb 2011 @ 02:54 PST||pixzer||Tools||Reply||TdBench V5 database release support||waiting for answer too... |
|18431||11 Feb 2011 @ 12:54 PST||AnnaK||Connectivity||Reply||The managed provider 'Teradata.Client.Provider' could not be instantiated||Update: 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... |
|18430||10 Feb 2011 @ 01:54 PST||emilwu||Database||Reply||Concatenation 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... |
|18429||10 Feb 2011 @ 01:35 PST||mnylin||Database||Reply||code 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.
|18428||10 Feb 2011 @ 01:29 PST||mnylin||Database||Reply||Trying 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... |
|18427||10 Feb 2011 @ 01:21 PST||mphipps||Analytics||Topic||row concatenation for dummies? AKA oracle wm_concat() teradata equivalent||I'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 ... |
|18426||10 Feb 2011 @ 01:18 PST||emilwu||Tools||Reply||TPT 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... |
|18425||10 Feb 2011 @ 10:01 PST||RLine||Database||Topic||Trying 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.... |
|18424||10 Feb 2011 @ 09:03 PST||l.k||Database||Topic||code 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... |
|18423||10 Feb 2011 @ 01:36 PST||AnnaK||Connectivity||Topic||The managed provider 'Teradata.Client.Provider' could not be instantiated||Hi!
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... |
|18422||09 Feb 2011 @ 08:21 PST||stever||Viewpoint||Reply||SMS alerts through View Point||Yes, 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 ... |
|18421||09 Feb 2011 @ 03:06 PST||snikolaev||Tools||Reply|| Can't install SQL Assistant 184.108.40.206||Thanks for reply, Mike. Uninstalling .NET 4.0 didn't help though. I'll ask my admins to get the latest SQLA. |
|18420||09 Feb 2011 @ 02:52 PST||MikeDempsey||Tools||Reply|| Can't install SQL Assistant 220.127.116.11||I 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 18.104.22.168 (latest is 22.214.171.124)
and i... |
|18419||09 Feb 2011 @ 12:17 PST||snikolaev||Tools||Topic|| Can't install SQL Assistant 126.96.36.199||Hi,
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... |