Hello,
I have a job that deletes hashed file records using a UV stage. I would like to take a count of the records that will be deleted but I do not like the solution of a SELECT COUNT(*) before the DELETE. I would like to know whether there is a way of capturing the count of the deleted records as a result of the same SQL DELETE operation on the hashed file (like the automatic count that is shown at the end of a SQL DELETE against a relational database).
Thanks
Capturing deleted hashed records count
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 43
- Joined: Tue Sep 09, 2008 1:56 pm
Capturing deleted hashed records count
ASU Developer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage/SQL does report N records deleted when a DELETE statement is executed interactively. Does not this report appear in the job log?
It is not possible to take a count of the records that "will be" deleted without counting beforehand.
DataStage ("UniVerse") tables are relational. You can choose whether or not to enforce first normal form.
It is not possible to take a count of the records that "will be" deleted without counting beforehand.
DataStage ("UniVerse") tables are relational. You can choose whether or not to enforce first normal form.
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.
-
- Premium Member
- Posts: 43
- Joined: Tue Sep 09, 2008 1:56 pm
Re: Capturing deleted hashed records count
For the record, I have yet to use a relational database where a sql delete reported anything back automatically. Some may, but all certainly don't.ASU_ETL_DEV wrote:(like the automatic count that is shown at the end of a SQL DELETE against a relational database).
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 43
- Joined: Tue Sep 09, 2008 1:56 pm