How to get the number of rows which are updated by my job

[sandra63]

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.

[ray.wurlod]

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".

[veera24]

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.

hi,
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

[ray.wurlod]

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.