#DateForumTypeThreadPost
4714 Feb 2011 @ 12:29 PSTConnectivityTopicExecuteUpdate -- -row count return type is intI noticed that the statement.executeUpdate() method returns int data type , which conforms to JDBC standard. However, here is the question: it is Teradata!!! the affected row count can easily blow ...
4610 Feb 2011 @ 01:54 PSTDatabaseReplyConcatenation 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...
4510 Feb 2011 @ 01:18 PSTToolsReplyTPT 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...
4415 Dec 2010 @ 07:50 PSTGeneralReplyClipboard issues with Teradata SQL Assistant 12 in Citrix Hi Mike, thanks for the reply. the problem is the way microsoft office manage clipboard. When you copied something from excel, you will notice that if you did not paste the content into office rela...
4326 Oct 2010 @ 01:31 PDTGeneralReplydays since Jan 1 ,4712 BC in TeradataBTW, here is my solution: change the sys_calendar caldates table by adding the precomputed value in, expand the calbasics view , calendar view with the column. it should save a lot of headache syst...
4226 Oct 2010 @ 01:25 PDTGeneralReplydays since Jan 1 ,4712 BC in Teradatathanks for chrome... I can read spanish now!!!! LOL...
4126 Oct 2010 @ 12:44 PDTGeneralReplyClipboard issues with Teradata SQL Assistant 12 in Citrix BTW: the issue on SQLA 13.10 does not related to citrix product.
4026 Oct 2010 @ 12:44 PDTGeneralReplyClipboard issues with Teradata SQL Assistant 12 in Citrix same thing applied to Taradata SQL Assistant 13.10 .net version, the copy paste constantly fail. I have to copy paste to a third party software(notepad or etc) from excel before paste back to SQLa'...
3901 Oct 2010 @ 09:09 PDTDatabaseReplyWhat is method or strategy to calculate the CPU utilized in running a Query?can you elaborate : 100-(nullifzero(lg.TotalCPUTime/300)/(lg.HotAMP1CPU) *HASHAMP()) "Skew Factor", why divide 300 ?????
3826 Aug 2010 @ 12:30 PDTExtensibilityReplyExternal Store procedure to read a local client fileKris, your question is not related to this thread. However, Teradata utility cannot read the binary format file generated from the Oracle application. There are ways to do it by programming your ...
3726 Aug 2010 @ 12:27 PDTExtensibilityReplyExternal Store procedure to read a local client fileAdeel, Please elaborate the combination you mentioned here.. UDF reading data from file ... I do not think it is possible. The UDF may able to read file on the server node, while it will have ...
3626 May 2010 @ 08:25 PDTExtensibilityReplyExternal Store procedure to read a local client filewell, using scp/ftp to server side is not quite an option here. the node is out of reach from security point of view. It is interesting to see that the SQLJ.Install_Jar() can actually doing this ...
3507 May 2010 @ 08:55 PDTUDAReplyBULK INSERT in Teradatasyntax may not be taht accurate, but check teradata bteq manual, it should suffice what you need.
3407 May 2010 @ 08:54 PDTUDAReplyBULK INSERT in Teradatabteq .set sessions 5 .logon .import vartext ',' file = \\computer2\somefile.xxx; .repeat * pack 100 using (f1 integer, f2 varchar(20),f3 varchar(10)) insert into table (field1,field2,fied3...
3306 May 2010 @ 11:30 PDTDatabaseReplyWindowed aggregates with date constraintsif the requirement is simply calculate sum of purchase during the past ten days, then a simple select acct_nbr, sum(purchase) as pur from table where purchase_date between date and date -10 g...
3205 May 2010 @ 09:47 PDTExtensibilityTopicExternal Store procedure to read a local client fileExternal Store procedure to read a local client file I notice that the SQLJ.INSTALL_JAR can read a local binary file and store it to the server side. Wondering how to implement such function to ...
3104 May 2010 @ 01:50 PDTExtensibilityReplyalways got failure 7980 when try to create Java External store procedure. switch to jdk1.5 compliant when using javac and eclipse works perfect, thanks for the tip
3004 May 2010 @ 08:10 PDTExtensibilityReplyalways got failure 7980 when try to create Java External store procedure. I will try JDK1.5// that's what I suspected the other day, however the VMWARE version of TD13, comes with JDK1.6 in the VM.. I will move the compile part out of vmware and try it on a client host. ...
2929 Apr 2010 @ 11:20 PDTExtensibilityTopicalways got failure 7980 when try to create Java External store procedure. Teradata release: 13.00.00.00 Version 13.00.00.00 (Express version) Tried both eclipse and manual process. both throw such here. Here are the steps that I did.. public class jxsp1{ publ...
2825 Feb 2010 @ 09:33 PSTDatabaseReplycan someone give me a quick dirty answer?thanks for the prompt answer. That's what I suspected why the lock was not released. I will double check with the code again.
2724 Feb 2010 @ 08:38 PSTDatabaseTopiccan someone give me a quick dirty answer?well, actually I have two questions, but related to blocking issue. first question is how the dbc.pseudo table block happens? is there anyway to relieve such blocking on a busy system second i...
2624 Feb 2010 @ 08:35 PSTDatabaseReplyOptimizer expert, please correct my under standing herethanks for clear my doubts.. the resulset looks fine. I guess it is an explain bug.
2518 Feb 2010 @ 08:18 PSTDatabaseReplyOptimizer expert, please correct my under standing hereThanks for suggestion.. but I do not have that much access on this system. the curious thing about this explain is the distribution key of spool and the upcoming join are not quite related.. trying...
2416 Feb 2010 @ 10:51 PSTDatabaseReplyOptimizer expert, please correct my under standing herewelll , i am in this particular group who do not have such access to create incident... bunch red tapes to go through to bother the ones who have such access...
2315 Feb 2010 @ 09:06 PSTDatabaseReplyOptimizer expert, please correct my under standing heresomeone care to help?

Pages