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.
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.
If nevertheless you find a way to use a transform function at capture site using a built in function, please let us know.