#DateForumTypeThreadPost
431 Mar 2015 @ 02:41 PDTDatabaseReplyNon duplicate row selection queryIf DIRECT_ID value doesn't matter in target: Step1: Create a SET table New_Consumer excluding DIRECT_ID column Step2: Insert from Consumer_Table to New_Consumer, your duplicates will go...
323 Mar 2015 @ 10:05 PDTDatabaseReplyREGEXP_SIMILAR SyntaxI got some clue from other thread where drop stat not working in SQL Assistant 15.0, same problem is with REGEXP_SIMILAR function too. I am able to run this function in BTEQ. Thanks Dieter fo...
218 Mar 2015 @ 12:09 PDTDatabaseReplyREGEXP_SIMILAR SyntaxIt showing only one function in TD_SYSFNLIB with NumParameters as 3.  In my example also using the syntax having three params. Not sure whats the issue.
117 Mar 2015 @ 02:27 PDTDatabaseTopicREGEXP_SIMILAR SyntaxHi, I am trying to use REGEXP_SIMILAR function but it returns following error: "3706: syntax error: Data Type "city" does not match a Defined Type name" I am using following ...