Hi,
I want to capture the number of records that are getting updated / inserted into the database.
I am capturing the job statistics using a routine.
Oneway to capture the record count is through reading the log file and get the statistics.
Is there any function so that I can get the rowcount directly instead of reading the log file.
Thanks for the inputs.
Thanks,
Phani
Oracle Enterprise Stage - Update / Insert rowcount
Moderators: chulett, rschirm, roy
Re: Oracle Enterprise Stage - Update / Insert rowcount
Check out DSGetLinkInfophanee_k wrote:Hi,
I want to capture the number of records that are getting updated / inserted into the database.
I am capturing the job statistics using a routine.
Oneway to capture the record count is through reading the log file and get the statistics.
Is there any function so that I can get the rowcount directly instead of reading the log file.
Thanks for the inputs.
Thanks,
Phani
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DSLinkRowCount on the link servicing the database reports how many rows were sent successfully along that link.
You also need to capture whether any rows were not accepted by the database - standard reject handling in DataStage - by counting the number of rows on the reject link.
You also need to capture whether any rows were not accepted by the database - standard reject handling in DataStage - by counting the number of rows on the reject link.
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.
Hi,
Thanks for the inputs. I am capturing the row count at the link level.
But, I want to capture the number of records getting updated / inserted through the oracle enterprise stage using the UPSERT command.
Infact I am able to capture them by reading the log and capturing the occurrences of the insert and update statement.
Is there any other way to capture the records or is this only the way ie. by reading the log.
Thanks,
Phani
Thanks for the inputs. I am capturing the row count at the link level.
But, I want to capture the number of records getting updated / inserted through the oracle enterprise stage using the UPSERT command.
Infact I am able to capture them by reading the log and capturing the occurrences of the insert and update statement.
Is there any other way to capture the records or is this only the way ie. by reading the log.
Thanks,
Phani
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't believe there is any way within DataStage.
If the records contain timestamps for created and updated, you may be able to determine these counts with SQL queries.
If the records contain timestamps for created and updated, you may be able to determine these counts with SQL queries.
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.