Hi All,
I have a requirement to create the hashed file with FileName and RecordCount. FileName as key column.
If the source stage doesn't return any rows the hashedfile needs to create with the records as Filename and recordcount as 0.
If the soure stage return any rows it would create the Filename and the actual record count.
I am facing the issue when the Sourcestage doesn't retun any rows.
Please let me know on how to create a hashed file with the Filename and recordcount as 0 when the sourcestage doesn't retun any rows.
Thanks,
Satheesh
Hashed File record insertion with default values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It can't. You have to design this. Typically detecting zero rows involves two jobs - one to do the testing and a different one to take the action. Control is exerted, of course, via a sequence.
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.