Dynamic RDBMS stage not remembering User-defined SQL option
Posted: Wed Jun 07, 2006 2:41 pm
Hello,
I am attempting to use the Dynamic RDBMS stage within a DataStage server 7.5.1 job, but an odd thing is happening. I want to use the User-defined SQL Update Action and the stage does allow me to select it. However, after I press the OK button and then open the stage back up, the Update Action has been reset to Insert new rows only. I can say that I have never run into this problem before and nothing that I do seems to remedy the problem. One thing to note is that the stage will remember Update Actions up to and including the Insert new rows option and that the stage is being used after a transformer.
Any help is appreciated,
Chris
I am attempting to use the Dynamic RDBMS stage within a DataStage server 7.5.1 job, but an odd thing is happening. I want to use the User-defined SQL Update Action and the stage does allow me to select it. However, after I press the OK button and then open the stage back up, the Update Action has been reset to Insert new rows only. I can say that I have never run into this problem before and nothing that I do seems to remedy the problem. One thing to note is that the stage will remember Update Actions up to and including the Insert new rows option and that the stage is being used after a transformer.
Any help is appreciated,
Chris