All forum activity

#DateUserForumTypeThreadPost
5836712 Jul 2016 @ 09:24 PDTN_RaghuToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colors I think you misunderstood my question. I am not worried about settings. It is just that tab colors weren't working in the new TDSQLA.  If a query is running in one tab1 an...
5836612 Jul 2016 @ 08:52 PDTrl151007ConnectivityReplyTeradata Kerberos : Failure server not found in kerberos database Has the system been added to the Domain Controller?  If so, does it have a reserve lookup entry in the DNS?
5836512 Jul 2016 @ 08:45 PDTfgrimmerTeradata StudioReplyNeed help on export file option in tereadata studio expressAbhilash, It sounds like your result set is very large. Your best option is to use the Export Mode setting.  This will execute the query and send the result set directly to the export file ins...
5836412 Jul 2016 @ 08:27 PDTmanasanisDatabaseReply3899 Internal error in teradata SQL parserWhat was the workaround provided by Teradata for this issue? we are getting similar issue on one of Preprod environment but not on QA environment. 
5836312 Jul 2016 @ 08:23 PDTbilal.farooqDatabaseReplyJDBC queries on Teradata not logged in DBQLogTbl with parameters.Hello,   The ParamInfo. column in table DBC.DBQLParamTbl is a BLOB. How can we view it ?   Regards, Bilal
5836212 Jul 2016 @ 08:08 PDTchenstefAsterTopicFind Create Timestamp of a tableIs there a way to find the Create timestamp and Last Modified timestamp of a table?
5836112 Jul 2016 @ 08:03 PDTMartijnToolsTopicFastload - Error on piom GET ROW: 64Hello, I hope some one can help me with the following problem. I have a .txt file on my windows computer I need to import into Teradata. The file is 18 MB in size. It is delimited with comma and e...
5836012 Jul 2016 @ 07:58 PDTsachin.sebastianDatabaseReplyCalculate column value based on previous computed valueYou can do this as given below SEL VAL.*, FRU - CSUM(VEG,VEG DESC) AS TOTAL FROM test VAL  
5835912 Jul 2016 @ 06:58 PDTAtardecerR0j0DatabaseReplyFind the minimum alignment date query based on alignment number drop table Example; create multiset volatile table Example ( Alignment_No integer, Alignment_Date date )primary index( Alignment_No) on commit preserve rows; insert into Example(30, cas...
5835812 Jul 2016 @ 06:53 PDTdrmkd17DatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingSAME IS NOT working in Teradata 14.10.  How to get the Drop stats work ??Any particular syntax?
5835712 Jul 2016 @ 06:37 PDTdrmkd17DatabaseReplyStoring History DAta into tablesOk. Do you think making the partition as 1 month instead of 1 day will help.
5835612 Jul 2016 @ 06:14 PDTToddAWalterDatabaseReplyStoring History DAta into tablesMulti-value compression will NOT slow down access time, if anything it will improve performance by requiring fewer IOs. 
5835512 Jul 2016 @ 05:56 PDTdrmkd17DatabaseReplyStoring History DAta into tablesIS there any way to quickly uncompress a table?? Alter table remove Compression type of query . Loading and unloading this huge table is freaking me out.
5835412 Jul 2016 @ 05:09 PDTM.Saeed KhurramDatabaseReplyFaster way to delete and rebuild a tableHi, Thank you for clarification, but these all first 6 steps will lead the table B in same state as it is in initial state. So you can directly add the new data to table B without these steps. Jus...
5835312 Jul 2016 @ 04:56 PDTabhilash.dwbi@gmail.comTeradata StudioTopicNeed help on export file option in tereadata studio expressHi All, i am trying to export my result set from Teradata studio express but am getting the below error while exporting data, how can over come this error. Failed to Export result set Reason: Gc...
5835212 Jul 2016 @ 04:39 PDTthnkgreenDatabaseReplyFaster way to delete and rebuild a tableThanks for your replies.  To answer your question Fred, table A is dropped after it is copied to table B new (step 5).    What is really happening is the original table B is being ap...
5835112 Jul 2016 @ 04:27 PDTrdeshpandeDatabaseTopicNeed recursive SQL codeHi,  I have data in following format: I have first two columns  and I need to get third column using SQL/Recursive SQL. The first two columns show mobile number and their call time to ...
5835012 Jul 2016 @ 04:15 PDTsachin.sebastianGeneralReplycumulative sum and moving average You can try something like below SEL CSUM(salary,cont_join_date), MAVG(salary,6,cont_join_date) FROM <TABLENAME> WHERE EXTRACT (YEAR FROM cont_join_date) = 2015 AND EXTRACT (MONTH FROM ...
5834912 Jul 2016 @ 03:49 PDTM.Saeed KhurramDatabaseReplyStoring History DAta into tablesThe table design seems to be OK, if this BA_GENL_ID is unique you can make the PI as UPI to have more faster access. Also, you have used lot of compression, it may slow down the access time, is it...
5834812 Jul 2016 @ 01:13 PDTdrmkd17ViewpointReplyMeaning of basic terms I see in ViewpointThis link doesnot work. Please guys can you share the latest link
5834712 Jul 2016 @ 01:11 PDTRonaldBrayanDatabaseReplyRestore using DSA with NO BUILD option.Thanks Abhishek for your reply. My question was, is it possible to  BUILD the table separately after restore completed with NO BUILD just like ARCMAIN. Anyway I got the answer from TD univers...
5834612 Jul 2016 @ 01:09 PDTdrmkd17DatabaseReplyStoring History DAta into tablesYes stats are collected. 
5834512 Jul 2016 @ 01:02 PDTdrmkd17DatabaseReplyStoring History DAta into tablesCREATE MULTISET TABLE BA_FCT ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,      CHECKSUM = DEFAULT,      ...
5834412 Jul 2016 @ 12:41 PDTM.Saeed KhurramToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colorsHi, This is not an issue. The color settings are for code editor and not for tabs. so when you execute a query select statement the color of the running query changes to pink and once done, the co...
5834312 Jul 2016 @ 12:34 PDTArpan.RoyToolsReplyTPT output from ODBC includes Indicator Bytes?Hi Steve, When I put INTEGER in schema defination, the script is not failing, but all the records are going to ET1 table. Below is the console log. Teradata Parallel Transporter Version 15.10....

Pages