58867 | 01 Aug 2016 @ 11:40 PDT | naresh01 | Aster | Topic | Alternative to Strtok in Teradata Aster | Hi 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 ... |
58866 | 01 Aug 2016 @ 10:05 PDT | AmolZ | Database | Reply | PPI | How does it help when we choose partition on single column which is part of "multi-columned Unique Primary Index"?
|
58865 | 01 Aug 2016 @ 05:23 PDT | maximumwoltage | Third Party Software | Reply | Sublime text as Interactive BTEQ editor | Unfortunately, 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... |
58864 | 01 Aug 2016 @ 04:47 PDT | alihammad | Third Party Software | Reply | Sublime text as Interactive BTEQ editor | Did you manage to do it yourself?
|
58863 | 01 Aug 2016 @ 03:08 PDT | Fred | General | Reply | error table's are invalid state or table is being loaded | Have 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?
|
58862 | 01 Aug 2016 @ 03:07 PDT | stevehager | Tools | Reply | MLOAD APPLY WHERE condition which is not an equality | It 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... |
58861 | 01 Aug 2016 @ 02:57 PDT | Fred | Database | Reply | How 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... |
58860 | 01 Aug 2016 @ 02:49 PDT | Fred | Database | Reply | How to Enable UTC using TimeDateWZControl cmd | Not 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... |
58859 | 01 Aug 2016 @ 08:35 PDT | stevehager | Tools | Topic | MLOAD APPLY WHERE condition which is not an equality | I 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 ... |
58858 | 01 Aug 2016 @ 06:57 PDT | ToddAWalter | Database | Reply | Multiload | 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.
|
58857 | 01 Aug 2016 @ 06:51 PDT | Private Forum |
58856 | 01 Aug 2016 @ 05:44 PDT | Nileshhmali | Database | Reply | How to Enable UTC using TimeDateWZControl cmd | You 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 ... |
58855 | 01 Aug 2016 @ 05:39 PDT | raindew12 | Database | Reply | Calculating min and max column values in Teradata | Awesome that worked! Thank you Dieter!! :-) |
58854 | 01 Aug 2016 @ 05:15 PDT | abhishank18 | Database | Reply | Multiload | Can you please elaborate second point where keys are provided from an external source ? How does the external source provides values ?
|
58853 | 01 Aug 2016 @ 03:41 PDT | lokesh_meesala | General | Reply | error table's are invalid state or table is being loaded | Thanks 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... |
58852 | 01 Aug 2016 @ 02:09 PDT | dnoeth | Database | Reply | Calculating min and max column values in Teradata | You 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
(... |
58851 | 01 Aug 2016 @ 12:12 PDT | Nileshhmali | Database | Topic | How to Enable UTC using TimeDateWZControl cmd | I am not able to enable UTC for using below command
"TimeDateWZControl is set to 2 (enable UTC)
|
58850 | 31 Jul 2016 @ 10:36 PDT | Nileshhmali | Database | Topic | How 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... |
58849 | 31 Jul 2016 @ 10:28 PDT | raindew12 | Database | Topic | Calculating min and max column values in Teradata | I'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,... |
58848 | 31 Jul 2016 @ 09:21 PDT | AVOT | Viewpoint | Reply | Viewpoint SUSE Compatibility | Thanks guys,
We are now upgrading to SLES11/VP15.11.
|
58847 | 31 Jul 2016 @ 06:38 PDT | AVOT | Viewpoint | Reply | Viewpoint Cluster cache database replication question | Also 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... |
58846 | 31 Jul 2016 @ 06:31 PDT | AVOT | Viewpoint | Topic | Viewpoint Cluster cache database replication question | Hello 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 ... |
58845 | 31 Jul 2016 @ 06:21 PDT | AVOT | Viewpoint | Topic | Viewpoint 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... |
58844 | 31 Jul 2016 @ 09:52 PDT | Fred | General | Reply | error table's are invalid state or table is being loaded | This 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... |
58843 | 31 Jul 2016 @ 09:32 PDT | Fred | Database | Reply | DBC - CURRENTPERM EXCEEDS MAXPERM | Some 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... |