All forum activity

#DateUserForumTypeThreadPost
5846715 Jul 2016 @ 12:40 PDTAtardecerR0j0DatabaseReplyViewing Generated Dynamic SQL QueryYou can use DYNAMIC RESULT SETS . Then you have to create a cursor using then string variable where you storage the dynamic sql statement, for instance: DECLARE cursor_1 CURSOR WITH RETURN...
5846614 Jul 2016 @ 11:47 PDTdrmkd17DatabaseTopicTeradata DBA documentsHi People, I need some Teradata DBA docuemnts that would gear me up for a Teradata DBA Role. Can anybody help me out here. Thansk, Katie
5846514 Jul 2016 @ 07:12 PDTsalladDatabaseReplyTD 14 - Data Storage QuestionsThanks Khurram, I have done the introduction to Teradata 1 day training course and the 4 day basic SQL course, but it was a while ago and I hadn't used SQL / Teradata for a few months so I forg...
5846414 Jul 2016 @ 02:52 PDTpremkishore83Third Party SoftwareTopic'enabled' columnHi All,   We are in the process of moving from Greenplum to Teradata, When i try to insert into one of the teradata tables, I'm getting the following error,   Error: RDBMS code 3...
5846314 Jul 2016 @ 02:48 PDTmhusseyAsterReplyAster Visualization SpacingThe image upload isn't working, so here is a link to the example picture. Because of sensitive data, I cropped it, but the verticle amount of information is all that I can see on my browser, wi...
5846214 Jul 2016 @ 02:44 PDTmhusseyAsterTopicAster Visualization SpacingI've started building some visualizations in Teradata App Center using Aster, and I'm running into an issue. The viz type I'm using in this example is a Sankey diagram. The visualizatio...
5846114 Jul 2016 @ 01:58 PDTbeargilesToolsReplyError creating .genuine_TTU file on Ubuntu systemI may have found it. 1. Create /opt/teradata/client/ttu_bash.env file and add one line: NLSPATH=/opt/teradata/client/15.10/lib 2. install and run bteq I don't know if the key was the .env fi...
5846014 Jul 2016 @ 01:16 PDTteradatatesterDatabaseTopicMedian function - Fails on view when trying to cast as decimalI have a database table which has four columns and two of the columns are INT. The two INT columns' rows are sometimes empty. When I try to cast them as DECIMAL(18,3) and then use the Median f...
5845914 Jul 2016 @ 12:55 PDTfeinholzToolsReplyTPT deadlock Issue.I see that you are using the Inserter operator. Are you using multiple instances? Multiple sessions? In order to cut down on the deadlocks on the target table, you will need to restrict your Ins...
5845814 Jul 2016 @ 12:12 PDTfeinholzToolsReplyTeradata Tool and Utilities package for LinuxFastExport is not a free utility. It requires a license (part of the Basic or Enterprise license for TTU).
5845714 Jul 2016 @ 12:09 PDTbeargilesToolsTopicError creating .genuine_TTU file on Ubuntu systemI'm trying to install the (Redhat) RPM files on my Ubuntu system. I tried using 'alien' to convert the .rpm to .deb files but, inexplicably, it refuses to convert a i386 package on a x6...
5845614 Jul 2016 @ 11:57 PDTfeinholzToolsReplyEncryted Password File for FastExportCheck out the .RUN FILE command in the documentation. You cannot encrypt the contents, but you can restrict its usage through access rights settings. DataEncryption is for the data going across t...
5845514 Jul 2016 @ 11:33 PDTindra91ToolsReplyTeradata Tool and Utilities package for LinuxI am new to Teradata and unaware whether FastExport utility is among the drivers available for free download from Teradata site or would need to be obtained via Teradata or from your Tera...
5845414 Jul 2016 @ 11:27 PDTvenkata_k01ToolsReplyTeradata tpt $EXPORT: TPT10508: RDBMS error 3706: Syntax error: expected something between the 'DATE' keyword and the integer '2016'. Hi Fred, Format is YYYY-MM-DD. I tried by puting the ...
5845314 Jul 2016 @ 11:14 PDTindra91ToolsTopicEncryted Password File for FastExportI wanted to know if there is a way to store the .logon  username/Password in a separate File and include it while calling the Fastexport script.Also is there any option to encrypt the password...
5845214 Jul 2016 @ 11:02 PDTindra91ToolsReplyTeradata Tool and Utilities package for LinuxThanks a lot for the info.But the drivers available for download on the does'nt include the Fastexport utility so I need to obtain it from Teradata.Is this understanding correct?
5845114 Jul 2016 @ 10:30 PDTHanCDatabaseReplyhow to make Stored Procedure with dynamic SQL to display the records?thanks a lot Dieter!!!
5845014 Jul 2016 @ 10:26 PDTkamKAMAnalyticsReplyCoverting Char to Date BONJOUR SVP, DE L'AIDE  JE CHERECHE COMMENT UN CHAMP SI TOUT SES CARACTeRS  SE TROUVENT DANS UNE LISTE DE VALEURS! PAR EXEMPLE: LA LISTE DE VALEUR EST '0987654321&#...
5844914 Jul 2016 @ 10:10 PDTFredToolsReplyTeradata Tool and Utilities package for LinuxThe drivers and Teradata Studio downloads for Linux are on that site. But the full TPT suite for Linux would need to be obtained via Teradata @ Your Service or from your Teradata representativ...
5844814 Jul 2016 @ 09:39 PDTAROLD001DatabaseReplyNOT IN and nested queryThanks that clears the air!
5844714 Jul 2016 @ 09:36 PDTFredToolsReplyTeradata tptWhat is data type / format for ROW_EFF_DT (for implicit data type conversion)? If it is a DATE column, better to explicitly use DATE constant - keyword DATE in front of opening (double) single quot...
5844614 Jul 2016 @ 09:23 PDTHart3945DatabaseTopicViewing Generated Dynamic SQL QueryWe recently converted many of our static stored procedures to dynamic sql to reduce the amount of duplicated code.  Does Teradata have a function or process that would allow the users to view ...
5844514 Jul 2016 @ 09:14 PDTHustlerDatabaseReplyFormatting CURRENT_TIMESTAMPhow to find different timezone from one time zone?
5844414 Jul 2016 @ 09:00 PDTsuhailmemon84ToolsReplyTPT deadlock Issue.Thanks Johannes. We are in the process of familiarizing ourselves with the new features of 15.10. You're right. The PI changes could help. Hopefully the deadlocks reduce a bit after the upgrade...
5844314 Jul 2016 @ 08:59 PDTdavid.craigGeneralReplyConverting Time stamp in UTC including Day light SavingThe query is not attached. In any case, it sounds like Teradata support needs to assist in the timezone rules configuation settings in DBSControl, tdlocaledef and the gettimezonedisplacement UDF. ...

Pages