|53578||27 Nov 2015 @ 10:15 PST||Fred||Cloud Computing||Reply||Teradata 22.214.171.124 Express Vmware: Viewpoint fails to add Teradata account||You need to have a System defined for monitoring (via the Viewpoint Admin portlet) before you can add TD accounts on that system to any user profile.
|53577||27 Nov 2015 @ 09:55 PST||Fred||Extensibility||Reply||MD5 Message Digest UDF||Correct syntax is "replace function databaseName.hash_md5 ..." but you can't add user-defined functions to TD_SYSFNLIB. You could use SYSLIB.
|53576||27 Nov 2015 @ 05:29 PST||MaximeV||Database||Reply||3707 error when using recursive 'with' in stored proc in an attempt to concatenate a field.||If the recursive query is the output you need, you should declare it inside the cursor like this ?
DECLARE CUR1 CURSOR WITH RETURN ONLY TO CLIENT FOR
|53575||27 Nov 2015 @ 05:25 PST||rupert160||Cloud Computing||Topic||Teradata 126.96.36.199 Express Vmware: Viewpoint fails to add Teradata account||Hey guys, got my hands on TD15.10_SLES11_vp vmware today and had trouble adding a teradata account to viewpoint when it requires the Authentication Mechanism drop down to be chosen. Unfortunatly th... |
|53574||27 Nov 2015 @ 04:45 PST||Boopathi15||Database||Topic||Avoiding Duplication on All Amps||Hi
I'm trying to join two tables, Left table "TableA" being (30 GB and 90 milion rows) with the another table "tableB" ( 2.5 GB and 21 million rows).
Following is th... |
|53573||27 Nov 2015 @ 03:03 PST||Win||Database||Reply||Where are Stored Procedures stored ?||
After using the "EXPLAIN SHOW PROCEDURE ...", I only received the following information:
1) First, we do an INSERT into Spool 1.
2) Next, we do an IN... |
|53572||26 Nov 2015 @ 05:04 PST||zskuza||Database||Reply||Insert into target table from source table for each date for a specific date range||I solved this by performing a sub-select to aggregate data, grouping by partition fields, then the sub-select was joined to other tables for filtering, etc.
You have to love a DBMS that ca... |
|53571||26 Nov 2015 @ 03:45 PST||Moyo||Aster||Reply||R Configuration in Aster Express VM||Hi,
I have spent a week on this. I also followed the same instructions. I have tried installing with internet , I got the "error: Unable to load plugin R: Command Zypper....Add a r... |
|53570||26 Nov 2015 @ 02:01 PST||Kenton02||Database||Topic||3707 error when using recursive 'with' in stored proc in an attempt to concatenate a field.||Hello
Using version 15, I am stuck with 3707 error:
 SPL1027:E(L417), Missing/Invalid SQL statement'E(3707):Syntax error, expected something like an 'END' keyword between ';... |
|53569||26 Nov 2015 @ 12:55 PST||tb516072||Tools||Reply||Bteq - Maintain Audit Info||Hi Tushar,
A great question. I've struggled with this in the past.
In theory, you can do this, by sending the bteq output to a file, then reading it back in, but it's a nightmare an... |
|53568||26 Nov 2015 @ 10:17 PST||tusharzaware1||Tools||Topic||Bteq - Maintain Audit Info||
HAPPY THANKSGIVING DAY!!!!
Need help on BTEQ!!! In our project our client asked us to maintain all audit information bteq load.
We need to maintain source and target r... |
|53567||26 Nov 2015 @ 04:31 PST||lylydinh||Teradata Studio||Topic||how to setup teradata in windows ||I don't know Edit the TeradataStudioDataSources_template.config file to define the connection profiles help me !And i don't know name is server,pass,dataase,..
|53566||26 Nov 2015 @ 04:15 PST||CarlosAL||Tools||Reply||Fast load Issue||Fred:
Yup. Of course you're right. I overlooked the ERRORFILES part.
|53565||26 Nov 2015 @ 03:30 PST||Ian Russell||Extensibility||Topic||MD5 Message Digest UDF||I am trying to install this downable function for MD5 but get the error below.
It is a bit old (dates back to 2008) - ... |
|53564||26 Nov 2015 @ 01:52 PST||b.saipavankumar||Database||Topic||How to calculate Space saved & project it in terms of dollars||Hello All,
As part of our work, we have applied Multi Value Compression on tables that are huge in size and reduced the space usage. The space saved was around 40TB.
However, along with projectin... |
|53563||25 Nov 2015 @ 11:32 PST||zskuza||Database||Reply||Insert into target table from source table for each date for a specific date range||I have a similar problem - call data that is partitioned by day, that I want to aggregate into a new physical table with different partitioning. Unfortunately my environment has Teradata Workload M... |
|53562||25 Nov 2015 @ 10:55 PST||singhkrishna||Aster||Reply||Aster Management console (AMC) is not working for Aster Express||Run the ifconfig command on server, it should show the local IP configured. Use that IP in host browser. Ideally it should be 192.168.100.100, if am not wrong. I assume you have already followed st... |
|53561||25 Nov 2015 @ 09:45 PST||Abhishektd||Database||Reply||Oracle Table to Teradata DDL||Try AQT (Advanced Query tool).
|53560||25 Nov 2015 @ 02:20 PST||AOHorvli||Tools||Topic||Copy data from TD15.00 to TD15.10 (TD Express for VMWare)||Hi,
I just tried to move data between TD 15.00.00.02 and TD 15.10.00.06 (both TD Express for VMWare). I'm using Arcmain from TTU 15 (arcmain 15.00.00.01). The archive runs perfect, but wh... |
|53559||25 Nov 2015 @ 01:06 PST||ToddAWalter||General||Reply||Unassigned Work Load Definition For properly Configured User in TASM !!!!||Observations:
- all the unassigned ones are on the 24th, the ones with a WD are on the 23rd. Did a change to TASM settings occur?
- all the unassigned ones have 0 cpu time and 0 execution time. T... |
|53558||25 Nov 2015 @ 12:17 PST||Glass||General||Reply||Unassigned Work Load Definition For properly Configured User in TASM !!!!||This may help explain.
I log K's/ day , all have 0 ampcputime, many do have small parsercputime.
|53557||25 Nov 2015 @ 11:48 PST||sureshbadam||General||Reply||Unassigned Work Load Definition For properly Configured User in TASM !!!!||Added more details to my earlier questions.
|53556||25 Nov 2015 @ 11:47 PST||JustMe||Teradata Studio||Topic||Database Explorer Tree||Is it possible to have ONLY the databases to which a user has access load to the explorer tree in Studio Express?
|53555||25 Nov 2015 @ 11:34 PST||sureshbadam||General||Reply||Unassigned Work Load Definition For properly Configured User in TASM !!!!||Subhash,
I got exactly same situation. As Geeta mentioned, I checked at my end and I do not see any of those conditions (like user DBC, TDWM and etc; help, show.. My requests are data extra... |
|53554||25 Nov 2015 @ 11:02 PST||zct0357||Database||Topic||request is eligible for IPE but does not meet thresholds||In TD14.10, I’m running an explain on a query and I’m getting the message “This request is eligible for incremental planning and execution (IPE) but does not meet thresholds. The ... |