#DateForumTypeThreadPost
117114 Nov 2014 @ 08:35 PSTDatabaseReplyUse of CTE within stored proceduresHow is your macro structure? You could have made a new topic :) for ease of reference. The topic above is  "use-of-cte-within-stored-procedures".
117014 Nov 2014 @ 08:13 PSTGeneralReplyBTEQ .IF ERRORCODE <> 0 THEN <QUERY>I m not able to understand it properly. It looks like you just want to copy and paste the code. Try to put in a viewable way and press enter or in some unix env , you need to put front slash \, say...
116913 Nov 2014 @ 08:29 PSTDatabaseReplySQLServer - Teradata Timestamp IssueHave you checked the timstamp settings on both the servers too? say like selecting the timestamp.....?
116813 Nov 2014 @ 07:15 PSTDatabaseReplyTeradata basics Teradata Active Enterprise Data Warehouse --- 8TB to 61PB Teradata Data Warehouse Appliance------------ up to 21PB Teradata Integrated Big Data Platform------- 76TB up to 2,048 nodes wit...
116713 Nov 2014 @ 05:39 PSTDatabaseReplyLock on DBC.Accessright table and other Create/drop/Alter statement in Block stateJust my thought again, throwing more directions: Is it  a one-off situation or it is recurring? Background tasks such as defrag,..cylpack, fsg cache purging,TJ purging,cache flushing ..., ...
116613 Nov 2014 @ 12:13 PSTDatabaseReplyHow to avoid using QUALIFY OVER PARTITION BYYou can use regexp_substr like example below: regexp_substr(address,'bangalore',1,1,'i')   Next time, please issue a new topic, for ease of handling :) 
116512 Nov 2014 @ 08:16 PSTGeneralReplyRunning arcmain backup jobs on each partitionI am not pretty sure.I am thinking that the first job will place hut lock on the table, because we use RELEASE LOCK,  even when we specify the partition.  
116412 Nov 2014 @ 07:44 PSTDatabaseReplyIncrease the size limit of teradata objects name from 30 characters to more.It is 128.
116312 Nov 2014 @ 02:47 PSTDatabaseReplyLock on DBC.Accessright table and other Create/drop/Alter statement in Block stateHi Sandeep, I remember a discussion. Can it be because of: http://forums.teradata.com/forum/database/deadlock-on-dbc-accessrights?
116211 Nov 2014 @ 08:29 PSTConnectivityReplyTPT Help with SSISMaybe you can post your issues in attunity forum too.  ODBC operator for tpt is certified to work only with the DataDirect/Progress ODBC drivers. Others may work but may produce unwanted ...
116111 Nov 2014 @ 07:54 PSTDatabaseReplyIs it possible to modify my Partition?You have not told much about the altering criteria :). Here is an example: http://forums.teradata.com/forum/database/modify-the-partition Just for your information: You cannot use the ADD a...
116011 Nov 2014 @ 06:51 PSTGeneralReplyConvert multiple rows into single row Yes Dieter,indeed, the sorting  based on PromoType, back to the old style.
115911 Nov 2014 @ 05:07 PSTGeneralReplyConvert multiple rows into single row which version of TD? You can use : select Itinerary , tdstats.udfconcat(trim(PromoCode )) from yourtable group by 1   or do you want specifically : delimiter too?
115810 Nov 2014 @ 07:21 PSTDatabaseReplyAll access details for a databaseTry Join : dbc.allrights,dbc.allrolerights and dbc.rolemembers.
115710 Nov 2014 @ 10:00 PSTDatabaseReplyTransaction aborted by Administrator or operation staff On Sandeep's question: It is my curiosity if we can see in viewpoint or if there is a session id, connected with Linux/unix process id.....
115610 Nov 2014 @ 07:37 PSTTeradata ApplicationsReplyAfter devolping a script as a teradata devolper then unit test and after how it goes to production .It depends. Which methodologies? Continuous Integration, Extreme progamming, Agile and so one and so forth.... organizations adopt different  methodologies in different ways that benefit the...
115510 Nov 2014 @ 07:23 PSTDatabaseReplyTime Zone String Instead of OffsetWhich version of TD? Try this: select current_timestamp at 'gmt' (title 'GMT TIME'), current_timestamp at 'america pacific' (title 'America Pacific TIME...
115410 Nov 2014 @ 06:46 PSTDatabaseReplyBTEQ Export file with a date variable included in the nameBefore logon , you can do thus in Linux/unix: process_date=$(date "+%Y%m%d%H%M%S") then ..... = teradata_output_${process_date}.csv.....  
115308 Nov 2014 @ 05:42 PSTExtensibilityReplyCalling Web ServicesDid you check with MyBatis? An instant web service calls from stored proc. You can see much benefits with xml dealings and wsdl.......
115208 Nov 2014 @ 05:35 PSTExtensibilityReplyQueue to QueueMaybe this can help you: Kudos to Dieter's stored proc for stats, using queue table. Good reference for push..pop: http://developer.teradata.com/blog/dnoeth/2012/10/how-to-simplify-your-stati...
115106 Nov 2014 @ 09:12 PSTDatabaseReplyData skew /qry running longJust my opinion: I am not Dieter. The underlying view may have transformation, formats...wher it may need to be fine-tuned What happens if we run DIAGNOSTIC HELPSTATS ON FOR SESSION; for th...
115006 Nov 2014 @ 08:37 PSTDatabaseReplyEncryption in the indexI am not sure. Will it hash?????. But I don't think it is advisable , since when use in  where clause, it is nightmare.
114906 Nov 2014 @ 07:03 PSTDatabaseReplyCumulative Average where the partition are overlapping (Moving Avg.)You can think of in this direction like partition and restricting with qualify set by set maybe Paramterizing  for rows between never worked for me too a while back till now (like rows&n...
114806 Nov 2014 @ 06:37 PSTDatabaseReplyBackup and restore report Unity ecosystem manager is a multi-teradata system monitoring or alerting tool for UDA, including hadoop, aster.... Jobs , servers,tables, applications can be monitored.....like many other mo...
114706 Nov 2014 @ 06:05 PSTDatabaseReplyDisadvantages of CompressionnIt can increase CPU usage.  A trade-off is to be made with IO.

Pages