59616 | 02 Sep 2016 @ 07:45 PDT | AtardecerR0j0 | Database | Reply | ALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDS | You can have a look to the DNOETH's blog. It's very interesting
http://developer.teradata.com/blog/dnoeth/2013/08/why-dont-you-use-alter-table-to-alter-a-table
|
59615 | 02 Sep 2016 @ 07:04 PDT | SGIT | Database | Reply | replacing existing column | Thanks Sachin. I will go with the second option as then I can do it all in one query.
|
59614 | 02 Sep 2016 @ 06:36 PDT | Private Forum |
59613 | 02 Sep 2016 @ 06:30 PDT | sachin.sebastian | Database | Reply | replacing existing column | You can create the all_apps2 same as all_apps1 and write an update statement for prcd_amt
Or you could just use 'HELP TABLE all_apps1' to get the column list and copy paste it in the Selec... |
59612 | 02 Sep 2016 @ 06:11 PDT | sachin.sebastian | Database | Reply | DECLARE | You can define of parameter variables in Macors, Stored procedures and utilities such as Fastload, Mload etc. You cannot 'DECLARE' a variable outside of these. What are you trying to achiev... |
59611 | 02 Sep 2016 @ 03:42 PDT | knowledge | Database | Reply | between condition make bad execution plan | the result is 5041, the exclusion is irrelevant.
for the outer questions, i don't know the reply, i have to talk with the development enviroment.
"The product join result of all the comb... |
59610 | 02 Sep 2016 @ 03:38 PDT | srinivas_teradata | Database | Topic | ALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDS | Hi,
I am Altering the table for addition of new columns. And tables is having more than 1 billion records.
Please let us know is it standard to alter the table with more than one billion records ... |
59609 | 02 Sep 2016 @ 01:09 PDT | juanalfonso | Database | Reply | I can't execute an SP that calls another SP inside |
Thanks a lot! It has worked!
GRANT EXECUTE PROCEDURE ON novaquality TO novaquality;
I never thought I would have to give permissions to the database to execute its own procedures..... |
59608 | 02 Sep 2016 @ 01:04 PDT | erics44 | Database | Topic | DECLARE |
/*com 021 mi*/
DECLARE Var_EmployeeID INTEGER;
Hi
I am new to the forum so hello all :)
i am from a sql server background so just finding my feet with teradata
ive writen the above code an... |
59607 | 01 Sep 2016 @ 11:58 PDT | Akshay_Inp | Teradata Studio | Reply | Unable to connect to the database using Teradata Studio Express. | Hi,
I am new to teradata:
I have installed the Tearadata VM Player 14.10, I am using studio express inside the VM but not getting the options inside tools (ex. create,modify, security, administ... |
59606 | 01 Sep 2016 @ 10:06 PDT | Thiru07 | Tools | Reply | Error Table Mload | Thank you Ivyuan . Your sample script solved my problem.
/**
* author: [itmo] enot.1.10
* created: 29.08.2016 14:58:17
**/
#define __USE_MINGW_ANSI_STDIO 0
#include &l... |
59605 | 01 Sep 2016 @ 08:42 PDT | zskuza | Connectivity | Reply | Teradata ODBC 15.10 32bit and MSAccess 2016 32 bit Cannot find Terasso library | 15.00 works fine (install ICU, GSS then ODBC)
https://downloads.teradata.com/download/license?destination=download/files/185515/185514/0/td-ttu-15.00_for_Windows.zip
|
59604 | 01 Sep 2016 @ 06:05 PDT | zskuza | Connectivity | Reply | Teradata ODBC 15.10 32bit and MSAccess 2016 32 bit Cannot find Terasso library | I've also tried to install the 15.10.1.1 32-bit (and 64-bit) Teradata ODBC drivers and getting a dependency check error stating that the TeraGSS 15.10 libraries haven't been installed, even... |
59603 | 01 Sep 2016 @ 05:16 PDT | fgrimmer | Teradata Studio | Reply | Teradata Studio 15.10.01.01 on Mac OS X -- Hangs | Christopher, You can take a look at the terdata.log and see if any exceptions are being thrown. It is located in your workspace. USER directory/workspace-studio/.metadata/Teradata/teradata.log. Oth... |
59602 | 01 Sep 2016 @ 04:15 PDT | fgrimmer | Teradata Studio | Reply | Teradata preferences for new connection profile type missing | Steven, That is the workaround for now. The Studio product has this wizard but seems to be missing from Studio Express. I have opened a JIRA for this.
|
59601 | 01 Sep 2016 @ 04:03 PDT | Fred | Database | Reply | I can't execute an SP that calls another SP inside | GRANT EXECUTE PROCEDURE ON novaquality.F_QUITA_REPES TO database_containing_calling_procedure;
(Or GRANT on the entire database instead of the individual SP.)
|
59600 | 01 Sep 2016 @ 03:58 PDT | firstcaptain | Teradata Studio | Reply | Teradata Studio 15.10.01.01 on Mac OS X -- Hangs | Yep I am saving the password, but I am not making it past test connection or finish when it is set to connect when the connection wizard closes.
In addition I am using LDAP as authentication... |
59599 | 01 Sep 2016 @ 03:55 PDT | Fred | Database | Reply | DBC Diskspace, | Or maybe DBC is simply sized too small for your workload. What fraction of total system PermSpace is DBC MaxPerm?
|
59598 | 01 Sep 2016 @ 03:52 PDT | Fred | Database | Reply | DBC Diskspace, | Most likely, this is due to WAL space (DBC.TransientJournal) holding uncommited insert / update / delete information, in case a transaction aborts.
Perhaps you need to commit / c... |
59597 | 01 Sep 2016 @ 03:48 PDT | sboucher | Tools | Reply | File Writer operator writing out 0 for decimal columns with precision greater than 18. | Hello,
we have the same problem. Is this Issue fixed ?
|
59596 | 01 Sep 2016 @ 03:44 PDT | fgrimmer | Teradata Studio | Reply | Teradata Studio 15.10.01.01 on Mac OS X -- Hangs | Christopher, There is an issue that we have fixed where if you did not save the password for your connection profile, then select it in the SQL Editor list, it would stop responding. Can you verify... |
59595 | 01 Sep 2016 @ 03:08 PDT | flash7gordon | Connectivity | Reply | Can you get Teradata.Client.Provider for c#/dot.net just from disk? | I would mark the NetFx post as "Solve" but I don't see where to do this. I was able to solve this problem and I want to go over it because it might help others.
So there are th... |
59594 | 01 Sep 2016 @ 03:04 PDT | Dinesh1975 | Database | Topic | DBC Diskspace, | We have load jobs running in the night. DBC diskspace getting filled rapidly. I can see it in the view point, it raises from 11% to 80 %. or some time it reaches 100 % and all the jobs get failed. ... |
59593 | 01 Sep 2016 @ 12:59 PDT | SGIT | Database | Topic | replacing existing column |
Hello,
In the below query, i get the error
CREATE TABLE Failed. 3515: Duplication of column PRCD_AMT in a table, derived table, view, macro or trig... |
59592 | 01 Sep 2016 @ 12:19 PDT | firstcaptain | Teradata Studio | Reply | Teradata Studio 15.10.01.01 on Mac OS X -- Hangs | Yes I am able to launch the Teradata Studio but when after creating a Connection Profile and trying to connect to it (using Teradata) just hangs at that point.
|