Hi
i have a requirement where i need to read a fixed width flat file and insert the rows into a oracle DB. My input File has detailed records and Footer record. records will be inserted into database based on some constraints.
I need to capture the no of records that got inserted and that number has to be inserted into a Database. Need your help on how to capture the records and insert them into a database.
Thanks
count the number of inserts
Moderators: chulett, rschirm, roy
Really depends on how you are identifying your inserts, if its predetermined and all you are doing is inserting records then you can get the link count. Search for several methods discussed here.
If its insert/update then you could do a count(*) on your target table after the inserts.
If its insert/update then you could do a count(*) on your target table after the inserts.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, unless you timestamp or otherwise identify the run, and count the table beforehand and afterwards.
In DataStage you can only count the number of rows SENT to the database server - whether they get inserted successfully or not is a different question.
Download ETLstats, which already exists and will do most of the process metadata capture for you.
In DataStage you can only count the number of rows SENT to the database server - whether they get inserted successfully or not is a different question.
Download ETLstats, which already exists and will do most of the process metadata capture for you.
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.