DB2 Table Select and Update
Moderators: chulett, rschirm, roy
DB2 Table Select and Update
Is it possible to select values from a DB2 table and then update the DB2 table in the same stage? From what I've seen, you can only have an input to or an output from a DB2 stage...and not both.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Take a look at how these stages are set up.
Updates and inserts are handled on the Inputs tab of the stage. This means that they would occur first. Selects occur on the Outputs tab. This means that, if the stage has inputs and outputs, the Select operation occurs last.
I read between the lines in your message that this is not what you desire. To achieve your stated aim you will need two stages. Be careful of database locking, too. Ensure that the Select completes before you start trying to update.
Updates and inserts are handled on the Inputs tab of the stage. This means that they would occur first. Selects occur on the Outputs tab. This means that, if the stage has inputs and outputs, the Select operation occurs last.
I read between the lines in your message that this is not what you desire. To achieve your stated aim you will need two stages. Be careful of database locking, too. Ensure that the Select completes before you start trying to update.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.