#DateForumTypeThreadPost
813 Dec 2012 @ 10:39 PSTDatabaseTopicSybase SIMILAR Function and Teradata 14.0 equivalentFolks, We are working on a Sybase to Teradata Conversion project and ran into a situation where Sybase similar function is used in WHERE condition. eg: where similar(a.bank_nbr, b.bank_nbr) >...
701 Aug 2012 @ 05:16 PDTDatabaseReplyStored Procedure - Continue Handler Dieter, I mean multiple statements in a single SQL string? Looks like it is not possible.... For example, in the code below, is it possible to have multiple grants as the value of one &l...
601 Aug 2012 @ 01:47 PDTDatabaseReplyStored Procedure - Continue Handler Do we have to declare two SqlTxt1 and SqlTxt2 separately or is it possible to combine both in one variable SqlTxt1 and call both? I tried to do it, but was unable to... Let us say, if we hav...
517 Jul 2012 @ 08:43 PDTExtensibilityReplyFast Path UDF -- REGEXP_REPLACE not working with Slashes Thank You Jim...  
416 Jul 2012 @ 06:59 PDTExtensibilityTopicFast Path UDF -- REGEXP_REPLACE not working with Slashes Database: 14.0 Situation: REGEXP_REPLACE function is not accepting slashes (\) in a regular expression string and replace with empty spaces. I checked the manuals and it is no where lis...
324 May 2012 @ 11:58 PDTAnalyticsReplyIs there a 'sounds-like' phonetic function ? This is an old post....and we are on TD 14.0 now. Do we have any inbuilt functionality in Teradata that simulates Sybase's difference function? Or the only option is building a custom U...
215 May 2012 @ 11:22 PDTDatabaseReplyHow to use fetch in a dynamic cursor Thanks Dieter. Glad to know that it is not fetched sequentially. I understand about the note about putting these in MACROs. The customer has a lot of SQL Server stored procedures and we are work...
114 May 2012 @ 04:00 PDTDatabaseReplyHow to use fetch in a dynamic cursor Dieter, We have a situation where the customer wants to output the results of the Teradata 14.0 Stored Procedure through a front end Java Application. Most of the Stored Procedures they...