All forum activity

#DateUserForumTypeThreadPost
5962002 Sep 2016 @ 09:45 PDTSNguyenWFTeradata StudioReplyTeradata preferences for new connection profile type missingI found the wizard!  File > New Wizards > Other, then checkmark the box "Show All Wizards".  A little tricky, but it's there. HOWEVER, no matter what connection I try ...
5961902 Sep 2016 @ 07:45 PDTAtardecerR0j0DatabaseReplyALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDSYou 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
5961802 Sep 2016 @ 07:04 PDTSGITDatabaseReplyreplacing existing column Thanks Sachin. I will go with the second option as then I can do it all in one query.
5961702 Sep 2016 @ 06:36 PDTPrivate Forum
5961602 Sep 2016 @ 06:30 PDTsachin.sebastianDatabaseReplyreplacing 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...
5961502 Sep 2016 @ 06:11 PDTsachin.sebastianDatabaseReplyDECLAREYou 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...
5961402 Sep 2016 @ 03:42 PDTknowledgeDatabaseReplybetween condition make bad execution planthe 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...
5961302 Sep 2016 @ 03:38 PDTsrinivas_teradataDatabaseTopicALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDSHi, 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 ...
5961202 Sep 2016 @ 01:09 PDTjuanalfonsoDatabaseReplyI 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.....
5961102 Sep 2016 @ 01:04 PDTerics44DatabaseTopicDECLARE /*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...
5961001 Sep 2016 @ 11:58 PDTAkshay_InpTeradata StudioReplyUnable 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...
5960901 Sep 2016 @ 10:06 PDTThiru07ToolsReplyError Table MloadThank 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...
5960801 Sep 2016 @ 08:42 PDTzskuzaConnectivityReplyTeradata ODBC 15.10 32bit and MSAccess 2016 32 bit Cannot find Terasso library15.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
5960701 Sep 2016 @ 06:05 PDTzskuzaConnectivityReplyTeradata ODBC 15.10 32bit and MSAccess 2016 32 bit Cannot find Terasso libraryI'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...
5960601 Sep 2016 @ 05:16 PDTfgrimmerTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsChristopher, 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...
5960501 Sep 2016 @ 04:15 PDTfgrimmerTeradata StudioReplyTeradata preferences for new connection profile type missingSteven, 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. 
5960401 Sep 2016 @ 04:03 PDTFredDatabaseReplyI can't execute an SP that calls another SP insideGRANT EXECUTE PROCEDURE ON novaquality.F_QUITA_REPES TO database_containing_calling_procedure; (Or GRANT on the entire database instead of the individual SP.)
5960301 Sep 2016 @ 03:58 PDTfirstcaptainTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsYep 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...
5960201 Sep 2016 @ 03:55 PDTFredDatabaseReplyDBC Diskspace, Or maybe DBC is simply sized too small for your workload. What fraction of total system PermSpace is DBC MaxPerm?
5960101 Sep 2016 @ 03:52 PDTFredDatabaseReplyDBC 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...
5960001 Sep 2016 @ 03:48 PDTsboucherToolsReplyFile Writer operator writing out 0 for decimal columns with precision greater than 18.Hello, we have the same problem. Is this Issue fixed ?
5959901 Sep 2016 @ 03:44 PDTfgrimmerTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsChristopher, 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...
5959801 Sep 2016 @ 03:08 PDTflash7gordonConnectivityReplyCan 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...
5959701 Sep 2016 @ 03:04 PDTDinesh1975DatabaseTopicDBC 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. ...
5959601 Sep 2016 @ 12:59 PDTSGITDatabaseTopicreplacing 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...

Pages