How to check if a DataSet is null

[sconner]

Hi,

Is there a way in DataStage wherein we can check if the dataset is null or not?

cheers,
sconner

[ray.wurlod]

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.

[lcduddridge]

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.

Hi,

Is there a way in DataStage wherein we can check if the dataset is null or not?

cheers,
sconner