All forum activity

#DateUserForumTypeThreadPost
5471405 Feb 2016 @ 04:37 PSTfgrimmerTeradata StudioReplyWindows 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,...
5471305 Feb 2016 @ 02:27 PSTFredConnectivityReplyMAC ODBC does not handle UnicodeHave 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.
5471205 Feb 2016 @ 02:09 PSTFredDatabaseReplyHow to recover from error 3916: Requested information not in dictionaryTo remove the "orphan" foreign key constraint: ALTER TABLE xxx DROP INCONSISTENT REFERENCES;
5471105 Feb 2016 @ 01:53 PSTPat GoHabsGoConnectivityTopicMAC 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:  ...
5471005 Feb 2016 @ 11:34 PSTjessielinData ModelingTopicHow to expose Temporal Table to BI tools which doesn't speak TemporalDoes 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...
5470905 Feb 2016 @ 11:18 PSTtodddubeTeradata StudioReplyWindows Defender Trojan detected - install for Studio 15.10.01.01@fgrimmer thanks - it was wierd - 
5470805 Feb 2016 @ 11:16 PSTPrivate Forum
5470705 Feb 2016 @ 09:51 PSTdavid.craigDatabaseReplyEquivalent 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...
5470605 Feb 2016 @ 09:42 PSTperezcoConnectivityReply issue to install ODBC Driver (64x) -CLIv2 (64x) not recognized adding comments both version point 15.10.01.00
5470505 Feb 2016 @ 07:54 PSTmaestrox2DatabaseTopicHow to recover from error 3916: Requested information not in dictionaryHello, 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...
5470405 Feb 2016 @ 07:35 PSTssi112DatabaseReplyDECODE Does Not Trap Divide by Zero ErrorExcellent solution Dieter, thanks much for the help!
5470305 Feb 2016 @ 07:30 PSTFredDatabaseReplyRDBMS error 3813: The positional assignment list has too many valuesThat 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...
5470205 Feb 2016 @ 07:27 PSTperezcoConnectivityTopic issue to install ODBC Driver (64x) -CLIv2 (64x) not recognized   HI,  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...
5470105 Feb 2016 @ 06:00 PSTKerryMcClainTeradata StudioReplyFlyout weirdnessAwesome, thank you for the info!
5470005 Feb 2016 @ 05:25 PSTyuvaevergreenDatabaseReplyQuestion about "regexp_replace"REGEXP_REPLACE('XXX A1 A2 XXX', '(.* )(A[0-9])( )(A[0-9]).*', '\2', 1, 1, 'I');
5469905 Feb 2016 @ 04:14 PSTjuanalfonsoDatabaseTopicAlternative 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...
5469805 Feb 2016 @ 03:59 PSTgymprathapTrainingReplyAny best Training Centres you guys know in Hyderabad??what is the prerequistes to leran teradata please?   I know core Java ver well.
5469705 Feb 2016 @ 03:58 PSTjuanalfonsoDatabaseTopicHow 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...
5469605 Feb 2016 @ 03:49 PSTWinDatabaseReplySpool Space Issue on More Projected Columns Than Lesser Projected ColumnsHi Todd, Thank you very much for your input.   Best regards, Win
5469505 Feb 2016 @ 03:41 PSTCkpDatabaseReplyAutomate my Teradata queriesSay 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...
5469405 Feb 2016 @ 03:11 PSTCkpDatabaseReplyHow to compare rows among different columns using particular scenarioHi Gaurav2512 Make sure one thing your flag can have more values then you expressed in question. Below query will work for you :   SEL Route_cd, Event_Actual_Dttm, Src_Obj_Id, CASE WHEN...
5469305 Feb 2016 @ 02:47 PSTCkpDatabaseReplyColumn with keywords found in comments fieldCan 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...
5469205 Feb 2016 @ 02:44 PSTn@new1Teradata ApplicationsTopic *** Failure 6760 Invalid timestamp. in bteq importHi All, While importing data from INDICDATA file I m getting following error :  *** Growing Buffer to 4757  *** Failure 6760 Invalid timestamp.           &nbs...
5469105 Feb 2016 @ 02:40 PSTAbhishektdDatabaseTopicPatitioning expressionWhich 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...
5469005 Feb 2016 @ 02:15 PSTjuanalfonsoDatabaseTopicQuestion 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 "...

Pages