#DateForumTypeThreadPost
721 Dec 2015 @ 03:05 PSTDatabaseReplyDynamic partition not workingNo, both tables are not on same date.
616 Dec 2015 @ 07:49 PSTDatabaseTopicDynamic partition not workingHi, I am trying to insert data into table. Both source and target have same DDL structure. Source table has Dynamic partitions. Source DDL: CREATE MULTISET TABLE db1.tb1 ,NO FALLBACK ,  &n...
509 Dec 2015 @ 01:34 PSTToolsReplyRegex function REGEXP_REPLACE not accepting parameterI tried using single quotes, same results, it is not working on PROD UPDATE  table_name SET col1=REGEXP_REPLACE(col1,'RAM','SHYAM',1,0,'i'); Alternative, i have to ...
430 Nov 2015 @ 07:17 PSTToolsReplyFast load Issueif you are using UNIX/LINUX to run script, then use can easily remove the 1st record or last records using sed
330 Nov 2015 @ 12:37 PSTToolsTopicRegex function REGEXP_REPLACE not accepting parameterHi All, I want to replace all occurences of RAM with SHYAM in a column. I used for query: UPDATE  table_name SET col1=REGEXP_REPLACE(col1,RAM,SHYAM,1,0,'i'); Getting error: 9134, ...
223 Sep 2015 @ 02:45 PDTGeneralReplyRegular Expression guide for regular expression functionsThanks Dieter. That is why I was wondering why some of the regular expressions are not working. I was using regular expressions used in sed, awk.
122 Sep 2015 @ 08:04 PDTGeneralTopicRegular Expression guide for regular expression functionsIs there any document available for understanding the regular expressions used by regular expression functions like REGEXP_SUBSTR, REGEXP_SIMILAR etc.