Hi all,
I have a problem. I must get the number of rows which are really updated and inserted in database by a job.
I haven't a way to identify which rows are updated (I haven't a date for this in example.)
I must then insert this number in the database.
Have you any idea to solve my problem?
Thanks in advance.
How to get the number of rows which are updated by my job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
If there is no indicator in the target table of who/when each row was updated, then the best that DataStage can do would be to report the number of rows that were sent to the database, and the number that were rejected by the database (you have to design for this with a "driver Transformer" stage immediately preceding the database stage). The difference between the two *should* be the number of rows updated, if the input link was set to "update existing rows only".
If there is no indicator in the target table of who/when each row was updated, then the best that DataStage can do would be to report the number of rows that were sent to the database, and the number that were rejected by the database (you have to design for this with a "driver Transformer" stage immediately preceding the database stage). The difference between the two *should* be the number of rows updated, if the input link was set to "update existing rows only".
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.
Re: How to get the number of rows which are updated by my jo
hi,sandra63 wrote:Hi all,
I have a problem. I must get the number of rows which are really updated and inserted in database by a job.
I haven't a way to identify which rows are updated (I haven't a date for this in example.)
I must then insert this number in the database.
Have you any idea to solve my problem?
Thanks in advance.
If u wan insertion n updation count individually means den u shud ve some fields like timestamp etc.. in DB thereby u cud easily find the number of rows inserted n updated at a particular time by a partricular person.Meanwhile. if u wan jus the total count den u can use RoGetLinkCount in transformer stage.
Thanks,
Veera
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you would re-phrase your last post in English, so that I can understand it, then I might be able to offer some cogent advice. I do not understand your post as it is written. DSXchange is NOT a mobile telephone.
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.