#DateForumTypeThreadPost
1012 Apr 2015 @ 08:47 PDTDatabaseReplyPattern match and Extracting the words from columnHi Dieter, That sounds great. Let me check PCRE syntax to understand better. We have TD14 Thanks a lot for all your help !!  
912 Apr 2015 @ 01:28 PDTDatabaseReplyPattern match and Extracting the words from columnHi Dieter,  Thanks for your solution. but the number of occurence is not constant in my case so as per your suggestion,  I have to use REGEXP_SPLIT_TO_TABLE and XMLAGG. But co...
812 Apr 2015 @ 12:51 PDTDatabaseReplyPattern match and Extracting the words from columnHi , Pattern is constant and we can hard code the pattern in query directly.. Im expecting something from regex but I couldn't  find the proper documents for the same.
711 Apr 2015 @ 09:41 PDTDatabaseTopicPattern match and Extracting the words from columnHi, I have a requirement to match the pattern and extract the word as explained below. Ex: Column value  = "A_B_C.D_E_F NOT NULL HAVING COUNT EQ 0 SAMPLE A_B_C.H_I_J" I need to ma...
614 Jul 2014 @ 11:40 PDTDatabaseTopicUser-generated transaction ABORT - while reading the data from JDBC driverHi, We are reading the data from Teradata table using JDBC driver from a java application via connection pools. We are getting the error "3514 - User-generated transaction ABORT" for al...
514 Jul 2014 @ 11:32 PDTDatabaseReplyToo many END TRANSACTION statements - Informatica - ODBCHi, Finally we tried using terdata driver provided by informatica instead using Teradata native client driver and it resolved the issue.
414 Jul 2014 @ 02:41 PDTDatabaseTopicToo many END TRANSACTION statements - Informatica - ODBCHi, We are trying to update a table in Teradata using informatica ODBC driver. While doing it, we are getting the below error in DBQL history table though the informatica session is succeeded. &...
306 Mar 2014 @ 10:37 PSTDatabaseReplyUsing Teradata in OLTP applicationHi Deiter, Thanks for your response. The no of o/p rows will be equal to no of REQ_IDs in IN clause. The stats are already collected for the REQ_ID column. Yes, you are correct it does 5 sequen...
206 Mar 2014 @ 12:16 PSTDatabaseTopicUsing Teradata in OLTP applicationHi, Recently we migrated our database from Oracle to Teradata and it provides healthy support in OLAP operations. But we need to explore few Teradata tables to OLTP world where we are getting 250...
114 Feb 2014 @ 05:59 PSTDatabaseTopicHow to get sequence numbers for a particular group based on consecutive valuesHi All, I have a requirement to generate sequence numbers for a particular group based on consecutive values. For example, I have my source data as below which gives the audit details&n...