|54714||05 Feb 2016 @ 04:37 PST||fgrimmer||Teradata Studio||Reply||Windows Defender Trojan detected - install for Studio 15.10.01.01||@toddube, We agree. We have scanned the files and found nothing. We have had others download the package without reporting any issues. I am not sure where/how the virus could slip in? Just curious,... |
|54713||05 Feb 2016 @ 02:27 PST||Fred||Connectivity||Reply||MAC ODBC does not handle Unicode||Have you tried using the driver with your own ODBC application or a full-featured client? This is likely a limitation of the tdxodbc test program rather than the driver.
|54712||05 Feb 2016 @ 02:09 PST||Fred||Database||Reply||How to recover from error 3916: Requested information not in dictionary||To remove the "orphan" foreign key constraint:
ALTER TABLE xxx DROP INCONSISTENT REFERENCES;
|54711||05 Feb 2016 @ 01:53 PST||Pat GoHabsGo||Connectivity||Topic||MAC ODBC does not handle Unicode||
MAC ODBC doesn't handle UNICODE correctly. It just removed none plain text character. Does anybody have a trick to fix it?
Below are conducted test:
|54710||05 Feb 2016 @ 11:34 PST||jessielin||Data Modeling||Topic||How to expose Temporal Table to BI tools which doesn't speak Temporal||Does anyone has experience in exposing Temporal Table to BI tools which doesn't speak Temporal?
For example, I have temporal table below:
CREATE MULTISET TABLE DimModel.Stores_ST_Temp... |
|54709||05 Feb 2016 @ 11:18 PST||todddube||Teradata Studio||Reply||Windows Defender Trojan detected - install for Studio 15.10.01.01||@fgrimmer thanks - it was wierd -
|54708||05 Feb 2016 @ 11:16 PST||Private Forum |
|54707||05 Feb 2016 @ 09:51 PST||david.craig||Database||Reply||Equivalent sentence in Teradata for the Oracle "CONVERT"?||If I understand correctly, you want the Teradata equivalent of the Oracle CONVERT function. For starters, I was pointing out some of the differences in string literals between the two products. The... |
|54706||05 Feb 2016 @ 09:42 PST||perezco||Connectivity||Reply|| issue to install ODBC Driver (64x) -CLIv2 (64x) not recognized ||adding comments
both version point 15.10.01.00
|54705||05 Feb 2016 @ 07:54 PST||maestrox2||Database||Topic||How to recover from error 3916: Requested information not in dictionary||Hello,
I have a probelm that I have been banging my head trying to recover from.
We have an application that replicates data from our own database into Teradata. Tests are run which repeatedly wi... |
|54704||05 Feb 2016 @ 07:35 PST||ssi112||Database||Reply||DECODE Does Not Trap Divide by Zero Error||Excellent solution Dieter, thanks much for the help!
|54703||05 Feb 2016 @ 07:30 PST||Fred||Database||Reply||RDBMS error 3813: The positional assignment list has too many values||That error specificallly indicates you have too many commas within the INSERT statement. Check that you don't have any lines with both leading and trailing commas, or extra comma befo... |
|54702||05 Feb 2016 @ 07:27 PST||perezco||Connectivity||Topic|| issue to install ODBC Driver (64x) -CLIv2 (64x) not recognized ||
I am having issue to install ODBC Driver (64x)
The CLIv2 - Suite 15.10.04.00 for Windows (X64) after been installed is not been recognized when I installed the... |
|54701||05 Feb 2016 @ 06:00 PST||KerryMcClain||Teradata Studio||Reply||Flyout weirdness||Awesome, thank you for the info!
|54700||05 Feb 2016 @ 05:25 PST||yuvaevergreen||Database||Reply||Question about "regexp_replace"||REGEXP_REPLACE('XXX A1 A2 XXX', '(.* )(A[0-9])( )(A[0-9]).*', '\2', 1, 1, 'I');
|54699||05 Feb 2016 @ 04:14 PST||juanalfonso||Database||Topic||Alternative to Oracle's packages||
Hello to everybody,
I'm starting to carry out a migration from Oracle PL-SQL to Teradata Stored Procedure Language and I can't find how to declare my own packages.
I've alrea... |
|54698||05 Feb 2016 @ 03:59 PST||gymprathap||Training||Reply||Any best Training Centres you guys know in Hyderabad??||what is the prerequistes to leran teradata please?
I know core Java ver well.
|54697||05 Feb 2016 @ 03:58 PST||juanalfonso||Database||Topic||How to define an array of varchars in Stored Procedure Language?||
Hello to everybody,
I'm studying a migration from Oracle PL-SQL to Teradata Stored Procedure Language and I'm having problems trying to find a way to declare an array of varchars ins... |
|54696||05 Feb 2016 @ 03:49 PST||Win||Database||Reply||Spool Space Issue on More Projected Columns Than Lesser Projected Columns||Hi Todd,
Thank you very much for your input.
|54695||05 Feb 2016 @ 03:41 PST||Ckp||Database||Reply||Automate my Teradata queries||Say if I need to refresh the content of my table at 1:00 AM every friday,
I will use the following btq script (which includes insert query) and unix scheduler like cron:
btq script exampl... |
|54694||05 Feb 2016 @ 03:11 PST||Ckp||Database||Reply||How to compare rows among different columns using particular scenario||Hi Gaurav2512
Make sure one thing your flag can have more values then you expressed in question.
Below query will work for you :
CASE WHEN... |
|54693||05 Feb 2016 @ 02:47 PST||Ckp||Database||Reply||Column with keywords found in comments field||Can you post sample data from your view and output you expect as it will make your requirement more clear.
Also I am not sure about Teradata on this but you can do it with a combination of Bteq in... |
|54692||05 Feb 2016 @ 02:44 PST||n@new1||Teradata Applications||Topic|| *** Failure 6760 Invalid timestamp. in bteq import||Hi All,
While importing data from INDICDATA file I m getting following error :
*** Growing Buffer to 4757
*** Failure 6760 Invalid timestamp.
|54691||05 Feb 2016 @ 02:40 PST||Abhishektd||Database||Topic||Patitioning expression||Which of the following partitioning expression has a better performance while SELECT, INSERT operations ? Consider the table has data around couple of Terabytes.
PARTITION BY RANGE_N(LOAD_TIMESTAM... |
|54690||05 Feb 2016 @ 02:15 PST||juanalfonso||Database||Topic||Question about "regexp_replace"||Hello to everyone,
When I execute this sentence:
select REGEXP_REPLACE('XXX A1 A2 XXX', '.*( )(A[0-9]).*', '\2', 1, 1, 'i');
I get the second "... |