1 Reply Latest reply: Jan 25, 2012 7:43 AM by 734707 RSS

    avoiding the LOB chunk updates as LOB columns are not propagated.

    TCSBPMUSER
      Hi,
      We have a setup where we are using the streams along with messaging gateway to propagate the changes to websphere MQ. we are deleting the LOB columns at the capture process itself using the delete_column function. but in case of LOB tables, insert statements are propagating in two parts(1 insert and 1 update, which is for lob column). we need to eliminate this second statement(update) as we do not require this statement. any help would be greatly appreciated.
      Regards,
      Ankit
        • 1. Re: avoiding the LOB chunk updates as LOB columns are not propagated.
          734707
          This amount to a transformation on the capture. You have no choice than abandon the built in function and create a transform function and attach this transform function on the capture using an action context. Action context are process that automatically fire.

          I wrote a note on this, it is not an easy matter but there is enough information on how to do it.

          http://sourceforge.net/apps/mediawiki/smenu/index.php?title=How_to_Transform_capture

          If nevertheless you find a way to use a transform function at capture site using a built in function, please let us know.