All forum activity

#DateUserForumTypeThreadPost
5814230 Jun 2016 @ 09:06 PDThvganipineniDatabaseReplyCreate NUPI and USI having the same ColumnI dont think its necessary if you do the data modeling right. 
5814130 Jun 2016 @ 08:12 PDTjkurdsjukDatabaseReplyCreate NUPI and USI having the same ColumnIs this a question or a quiz?  ;)   Only thing I can think of is on a partitioned table where the partitioning column is not part of the PPI and therefore the PI cannot be unique.
5814030 Jun 2016 @ 07:05 PDThymaDatabaseTopicCreate NUPI and USI having the same ColumnHi Under which circumstances does it make sense to define NUPI and USI having the same column? It sounds curious, isn't it? Thanks.
5813930 Jun 2016 @ 03:50 PDTM.Saeed KhurramExtensibilityReplyurgent : xml conversionHi, This issue has been resolved. The issue ocurred due to a tag in annotatedschema definition. There is a tag <defaultDatabase>Databasename</defaultDatabase>. Update this tag w...
5813830 Jun 2016 @ 03:35 PDTM.Saeed KhurramToolsReply2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD-Hi, Do the following: execute the following statment: release mload tablename; delete the log table. and restart the job. Br, Khurram
5813730 Jun 2016 @ 01:06 PDTarkaprava.chandraGeneralTopichow to find frequently used data in a table of Teradata DatabaseHi All, could you please tell me, how to find frequently used data in a table of Teradata Database? Portions of data within tables that were accessed within last 2 years – Ex, if ...
5813630 Jun 2016 @ 12:04 PDTprem.rpkDatabaseReplyAnalytical Function for deriving datesHi Everyone,                     I had tried the below query and its working for scenario when parent level from 3,2,1 is having dates less than 4...
5813529 Jun 2016 @ 11:57 PDTarkaprava.chandraGeneralReplySome roles are showing in DBC.ROLEINFO but not in DBC.ALLROLERIGHTSThanks Sachin, it's like untill the role is not assigned/granted to any databases, we cannot see the same in 'ALLROLERIGHTS'.
5813429 Jun 2016 @ 11:51 PDTanilkumar922ToolsTopic2555:TABLE DOES NOT BELONG TO THE MLOAD JOB.Hi all, When I tried to load the table I got below error 2555:TABLE DOES NOT BELONG TO THE MLOAD JOB. I defined all required tables to this load But still I'm getting this error. Please su...
5813329 Jun 2016 @ 11:48 PDTanilkumar922ToolsTopic2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD-Hi all, When I tried to load the table using mload I'm getting below error 2554 INCONSISTENT SITUATION OCCURS IN RESTART MLOAD- could you please suggest how I can overcome this issue??
5813229 Jun 2016 @ 08:01 PDTkchinnadTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listing@fgrimmer , Thanks for your response and greatly appreciate your support & guidance on this. In our organisation , we have only this version 15.10.00.04 available at the moment. It will take a ...
5813129 Jun 2016 @ 04:59 PDTddmaddoTeradata ApplicationsReplyLinking/Joining Different Databases in Teradata Question to clarify about the QueryGrid T2T CREATE FOREIGN SERVER Command   ip_device / local_ips - The DNS name of the local Teradata nodes or the IP addresses of the local Teradat...
5813029 Jun 2016 @ 02:54 PDTCarlosALDatabaseReplySyntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") You can turn the "b" SELECT into a subquery and then use the IN clause. You could spare the rest of the "b" columns if you only need Var1 and Var5 and your select list is only a.SITE_ID. The IN...
5812929 Jun 2016 @ 02:47 PDTteradatatesterDatabaseTopicShapefile doesn't load the GEOM part for 1 out of 4 rows? I have a shapefile that has 4 territories. Three of the territories have a territory name and one is null because it is the row for everything that is outside of the 3 territories. The shape file ...
5812829 Jun 2016 @ 01:34 PDTKellnerKDatabaseReplySyntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") So is this just a limitation of IN within Teradata?  The OR solution works but the real query I'm writing has multiple IN statements already mixed with a bunch of OR and AND, so I was tryi...
5812729 Jun 2016 @ 01:30 PDTCarlosALDatabaseReplySyntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") Hi. Replace "CROSS JOIN" with a comma "," and change the IN clause to: WHERE a.SITE_ID = b.Var1 OR a.SITE_ID = b.Var5 Cheers. Carlos.
5812629 Jun 2016 @ 01:25 PDTprem.rpkDatabaseTopicAnalytical Function for deriving datesHi Everyone,                     I am new to Teradata forum. Could anyone in forum please help out in deriving an analytical function. Trying to ...
5812529 Jun 2016 @ 12:39 PDTKellnerKDatabaseTopicSyntax Error: WHERE "a"."Field1" IN("b"."Test1", "b"."Test2") I have a query that cross joins a table of information against a table of dynamic dates that I create on the fly. For some reason, when using IN, I cannot list multiple fields.  It will run a...
5812429 Jun 2016 @ 12:12 PDTsham5ToolsReplybteq export and import for _ET dataparcelHi Feinholz,   I tried using the TWBERTBL utility to extract the DataParcel Column in the error table and noticed special characters in the output file. Below is the command thats been used ....
5812329 Jun 2016 @ 11:44 PDTac110057Teradata Database on VMWareReplyAuthentication failure while log in the SUSE Linux Enterprise Server 11 Which TVME version (15.10, 15.01, 15.0, etc...) and which flavor (Community/Developer/Base edition)? Try logging in directly through the console of your image.
5812229 Jun 2016 @ 10:41 PDTssavoyeToolsReplyTPT load failure on Interval datatype - Error code 7452I just reformatted and replaced the plus sign when pulling data out of ORacle as such: ,REPLACE(TO_CHAR(CAST(MAX_HOURS as interval day( 4) to second( 6))),'+',null) ...
5812129 Jun 2016 @ 10:26 PDTfgrimmerTeradata StudioReplyTerdata Studio - Connection to Hive - Database is not listing@kchinnad, Can you upgrade Studio to the latest 15.11 release. We have added additional error checking for Hadoop connections which may help to understand what the problem is. Also, you do not need...
5812029 Jun 2016 @ 08:37 PDTlongqilongTeradata Database on VMWareTopicAuthentication failure while log in the SUSE Linux Enterprise Server 11 Authentication failure  while log in the SUSE Linux Enterprise Server 11 username : root password : root   Someone help  me, please!  
5811929 Jun 2016 @ 08:02 PDTpoptcornToolsTopicSQL Assistant: Shortcut creation for "Sel top 10 * from"Hi all, I'm fairly new to SQL assistant as I have mostly used SSMS previously. In SSMS you were able to assign queries to shortcuts, and one of the queries I used religiously was "Select ...
5811829 Jun 2016 @ 07:52 PDTloafobDatabaseReplyOREPLACE issues between environments just realized i put this in the wrong sub-forum, apologies, and feel free to move if warranted.   Thanks

Pages