Hi,
Is there a way in DataStage wherein we can check if the dataset is null or not?
cheers,
sconner
How to check if a DataSet is null
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not sure what you mean by null here. Remember that a data set is something constructed by DataStage. Therefore, if it's been loaded with zero rows; you can get at best zero rows out of it. This is not an error condition (for a silly example your data set may have been populated with the records of all employees whose date of birth is in the future). Your job will process zero rows; this condition can be detected in a number of ways, such as inspecting the log entries or using the job interrogation functions.
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.
-
- Participant
- Posts: 8
- Joined: Tue Nov 16, 2004 12:34 pm
Re: How to check if a DataSet is null
You can use DSJob routine that can check the total records from the file using "dsrecords" command from the unix prompt. You should write general routine which calls unix commands.
sconner wrote:Hi,
Is there a way in DataStage wherein we can check if the dataset is null or not?
cheers,
sconner