All forum activity

#DateUserForumTypeThreadPost
5764109 Jun 2016 @ 03:05 PDTfgrimmerTeradata StudioReplyIs there a way to modify Connection Properties of DB Connections through some external Windows config file?1) One option is to distribute an .xml file that contains the connection profile with the new server name in the profile definition and users would import it into their Studio or Studio Express. Du...
5764009 Jun 2016 @ 02:35 PDTFredDatabaseReplyUnable to release locksEither re-run and complete the restore or drop the tables.
5763909 Jun 2016 @ 02:24 PDTFredDatabaseReplySeeing Junk character when inserting hyphen (-)That combination of characters is the 3-byte UTF-8 representation of EN DASH U+2013, misinterpreted as Windows-1252. In short, you are loading UTF-8 data using ASCII as the session character set. ...
5763809 Jun 2016 @ 01:53 PDTRoopaliniToolsReplyTPT WizardIt was an installatin issue. I uninstalled and resinstalled the TPT tool and that fixed it. 
5763709 Jun 2016 @ 12:49 PDTitdude369DatabaseTopicSeeing Junk character when inserting hyphen (-)Hi,   I am trying to insert a string containing hyphen (-) into a column defined as CHARACTER SET LATIN. But when I select, I see some junk character instead of '-'. Pls let me know ...
5763609 Jun 2016 @ 11:51 PDTfeinholzToolsReplyTPT attributes SkipRows and SkipRowsEveryFileThe DataConnector operator is able to read from multiple files at one time. The nature of parallelism implies that order is not important. If order is important, you cannot read multiple files in...
5763509 Jun 2016 @ 10:46 PDTpks_nikunjDatabaseReplyHow to declear Macro Variable?I want to create a global variable date and simply pass that date in another tables. What code should be used to create such a variable? I havent got any examples where we can create such a variable
5763409 Jun 2016 @ 10:25 PDTtsaloniaTeradata StudioTopicIs there a way to modify Connection Properties of DB Connections through some external Windows config file?We are in the process of migrating our systems to a new environment, with new server names, and, as such, need to modify all users' connection properties within Studio.  Is there a way to ...
5763309 Jun 2016 @ 10:04 PDTRoopaliniToolsTopicTPT WizardForum -  I installed TPT wizard 15.00 version recently and any job that I try to run is giving me the below error.  Completed with unexpected status from tbuild (-1,073,741,515). Could ...
5763209 Jun 2016 @ 09:29 PDTanurag2117DatabaseReplyDate format automatically changedThank you so much. It worked like charm :)
5763109 Jun 2016 @ 09:03 PDTwer61537ConnectivityReplypython / odbc connection to TDIs Driver={Teradata} the correct name for the Teradata driver?  I get "no default driver specified".
5763009 Jun 2016 @ 07:36 PDTalihammadDatabaseReplyGet database hierarchy to create similar directory structure on filesystem@CarlosAL Thanks mate. Looks like that's exactly what I want. Let me decipher it as I'm not used to recursion.   Cheers
5762909 Jun 2016 @ 06:51 PDTJustMeDatabaseTopicUnable to release locksWe are using DSA as our Backup and Restore option.  Lately, we have had issues with the Restore portion on our DRT system. We had a restore job that ran for several hours but seemed to make ...
5762809 Jun 2016 @ 06:39 PDTsneha.gToolsReplyTPT attributes SkipRows and SkipRowsEveryFileAlso, what is the default value of SkipRowsEveryFile?
5762709 Jun 2016 @ 06:37 PDTCarlosALDatabaseReplyGet database hierarchy to create similar directory structure on filesystemHi. WITH RECURSIVE JER (LEVEL, DATABASENAME, OWNERNAME, ROUTE) AS ( SELECT 1 LEVEL, DATABASENAME, OWNERNAME, CAST('/'||TRIM(DATABASENAME) AS VARCHAR(128)) ROUT...
5762609 Jun 2016 @ 05:42 PDTalihammadDatabaseTopicGet database hierarchy to create similar directory structure on filesystemI'm struggling with a query to fetch entire database hierarchy and calculating path of each node from root. I need to create same directory structure on the file system whereby each directory r...
5762509 Jun 2016 @ 04:33 PDTsneha.gToolsTopicTPT attributes SkipRows and SkipRowsEveryFileIf TPT Attributes INTEGER SkipRows = 1 and Varchar SkipRowsEveryFile = 'N' (There are more than 1 file), how will the loader know, for which file the row is to be skipped? How wil...
5762409 Jun 2016 @ 04:31 PDTpriyankbansalDatabaseReplyWhen a new node is added in teradata then the how the remapping will take place?Thanks Walter for answer...I think I need to read this concept (Hash Bucket) in deep to understand.
5762309 Jun 2016 @ 02:36 PDTrajezkumar11511DatabaseReplyFind which logon id locked the userThank you.. Really helps much :)
5762209 Jun 2016 @ 12:56 PDTM.Saeed KhurramDatabaseReplyTeradata demo version 13.1Hi, If you are looking for a free Teradata version for practice, you can download the VmWare edition from the below link: http://downloads.teradata.com/download/database/teradata-express-for-vmwa...
5762109 Jun 2016 @ 12:11 PDTKishore_1DatabaseTopicStats Histogram Accuracy (USING MAXVALUELENGTH) How to identify which  values contained in the histogram for  statistics for column(s) that are occupying more than 25 bytes, as per Teradata 14.10 . Do I need to check the sum...
5762008 Jun 2016 @ 11:12 PDTJohannes VinkDatabaseReplyMulti-level partition or differently partitioned JI?Hi Dieter, The reporting guys are complaining that it is "difficult" for them to present a year-week number in the report, and in the SQL select on the date... So changing the SQL from t...
5761908 Jun 2016 @ 10:52 PDTJohannes VinkToolsReplyWhat are the new features and major bug fixes in TTU 15.10? (in comparison with TTU15.00)Hi upriser, In TAYS the release notes are included. Please don't forget to check the compatability list of TTU with the database and the tools that use TTU. I.e. Powercenter 9.6.1 is only cer...
5761808 Jun 2016 @ 10:32 PDTniranjan_nr000GeneralTopicPassing Parameters to Bteq in MainframesHi, I am working with maniframe / teradata ..  Consider 2 databases "A" and "B".. I need to load table existing in database A using tables present in database B. I want ...
5761708 Jun 2016 @ 10:18 PDTupriser7ToolsTopicWhat are the new features and major bug fixes in TTU 15.10? (in comparison with TTU15.00)We are planning to upgrade from TTU 15.00 to TTU 15.10 but before doing so , I wanted to know whether there any major bug fixes and any new features in TTU 15.10 release when compared to 15.00 rele...

Pages