All forum activity

#DateUserForumTypeThreadPost
5886901 Aug 2016 @ 11:40 PDTnaresh01AsterTopicAlternative to Strtok in Teradata AsterHi Team - i have a string field with about 600,000 rows like the below. Aster data base is connected through Teradata Studio. Text1,Text2,Text3 Text1,Text2 Text1,Text2,Text3,Text4,Text5 I need ...
5886801 Aug 2016 @ 10:05 PDTAmolZDatabaseReplyPPIHow does it help when we choose partition on single column which is part of "multi-columned Unique Primary Index"?
5886701 Aug 2016 @ 05:23 PDTmaximumwoltageThird Party SoftwareReplySublime text as Interactive BTEQ editorUnfortunately, no. Jet Brains' Data Grip (https://www.jetbrains.com/datagrip/)has been cool, though. I have been using it for Hive/Impala, Postgres and have yet to hook it up to Teradata, but a...
5886601 Aug 2016 @ 04:47 PDTalihammadThird Party SoftwareReplySublime text as Interactive BTEQ editorDid you manage to do it yourself?
5886501 Aug 2016 @ 03:08 PDTFredGeneralReplyerror table's are invalid state or table is being loadedHave you verified in those cases that you don't have error tables left from a non-fatal error (i.e. some rejected rows) in the prior LOAD?    
5886401 Aug 2016 @ 03:07 PDTstevehagerToolsReplyMLOAD APPLY WHERE condition which is not an equalityIt turns out that there was a second IMPORT statement involved here.  I had to add a "superfluous" condition on that IMPORT to get the behavior I expected to see with the IMPORT comm...
5886301 Aug 2016 @ 02:57 PDTFredDatabaseReplyHow to use UTC ??What does "use UTC" mean? You can specify a TIMESTAMP WITH TIME ZONE value with +00:00 as the offset, or use the "AT time zone" modifier, or MODIFY USER to set a defa...
5886201 Aug 2016 @ 02:49 PDTFredDatabaseReplyHow to Enable UTC using TimeDateWZControl cmdNot sure what you mean by "enable" UTC. You can certainly play with TimeDateWZControl setting on a TD Express VM; but please contact Teradata support for assistance before changing t...
5886101 Aug 2016 @ 08:35 PDTstevehagerToolsTopicMLOAD APPLY WHERE condition which is not an equalityI have a very simple working MLOAD and have a new requirement to block data from being INSERTED.  I see many examples where the WHERE of an APPLY statement is specified as equality (=) and am ...
5886001 Aug 2016 @ 06:57 PDTToddAWalterDatabaseReplyMultiload The same way any data is loaded. A souce is decribed that contains the PI values to delete and multiload is told to load those PIs and then use them to delete rows.
5885901 Aug 2016 @ 06:51 PDTPrivate Forum
5885801 Aug 2016 @ 05:44 PDTNileshhmaliDatabaseReplyHow to Enable UTC using TimeDateWZControl cmdYou can do it 2 ways. At system level  You might need to change the setting for the DBS Control flag TimeDateWZControl. At Session Level SET TIME ZONE 'GMT+5:30'   ( This ...
5885701 Aug 2016 @ 05:39 PDTraindew12DatabaseReplyCalculating min and max column values in TeradataAwesome that worked! Thank you Dieter!! :-)
5885601 Aug 2016 @ 05:15 PDTabhishank18DatabaseReplyMultiload Can you please elaborate second point where keys are provided from an external source ? How does the external source provides values ?
5885501 Aug 2016 @ 03:41 PDTlokesh_meesalaGeneralReplyerror table's are invalid state or table is being loadedThanks Fred for quick response .. but in my case , we have cases where upload will fail due to file column length exceeds the target table column lengh or to few column etc.. in these cases we can...
5885401 Aug 2016 @ 02:09 PDTdnoethDatabaseReplyCalculating min and max column values in TeradataYou want to combine consecutive rows, this is usually done by assigning a group number using an OLAP function followed by aggregation: select cust_name, min(month), max(month) from (...
5885301 Aug 2016 @ 12:12 PDTNileshhmaliDatabaseTopicHow to Enable UTC using TimeDateWZControl cmdI am not able to enable UTC for using below command  "TimeDateWZControl is set to 2 (enable UTC)
5885231 Jul 2016 @ 10:36 PDTNileshhmaliDatabaseTopicHow to use UTC ?? How to use UTC ?? Hello Sir, Currently,I am working on Timestamp datatype for Teradata, I am not able to execute UTC in the SELECT script. Case-01:Below...
5885131 Jul 2016 @ 10:28 PDTraindew12DatabaseTopicCalculating min and max column values in TeradataI've a data in the following format  - cust_name , month, isAccountActive A, jan-15, 1 A, feb-15, 1 A, mar-15, 0 A, apr-15 , 1 A,  may-15, 0 B, jan -15, 0 B, feb-15,...
5885031 Jul 2016 @ 09:21 PDTAVOTViewpointReplyViewpoint SUSE CompatibilityThanks guys,   We are now upgrading to SLES11/VP15.11. 
5884931 Jul 2016 @ 06:38 PDTAVOTViewpointReplyViewpoint Cluster cache database replication questionAlso forgot to mention in my original question.  3. The active server is running dcs service and updating the active cache db on the active server 'A'. The standby server's dcs se...
5884831 Jul 2016 @ 06:31 PDTAVOTViewpointTopicViewpoint Cluster cache database replication questionHello Gurus,   I have a viewpoint cluster question? 1. I have set up a VP cluster between the active server 'A' and standby server 'B'.  2. The active server runs the ...
5884731 Jul 2016 @ 06:21 PDTAVOTViewpointTopicViewpoint Cluster Monitor is getting delayed messages.Hi Tech Gurus, Please see the following explanation: 1. I have set up a VP cluster for 2 VP servers. VP server A and VP Server B in our DEV environment.     Active Server 'A' a...
5884631 Jul 2016 @ 09:52 PDTFredGeneralReplyerror table's are invalid state or table is being loadedThis message can be interpreted as "Previous load attempt failed, and this job is not a valid restart from the point of failure." So you would need to figure out why the prior load failed...
5884531 Jul 2016 @ 09:32 PDTFredDatabaseReplyDBC - CURRENTPERM EXCEEDS MAXPERMSome things charged against DBC in space accounting are not subject to PermSpace limits, other things (like DDL inserting rows in the tables when you create an object) observe the normal rules...

Pages