Multiple Nullif checks for a field in Fastload

Tools & Utilities

Multiple Nullif checks for a field in Fastload

Hi All,

I want to convert a Mload script to Fastload for the purpose of performance improvement. One problem which I am facing is that I am not able to do a "Multiple Nullif checks for a field in Fastload which I was able to do in Mload".

For ex. say I want to do a '\' check and a space check for a time field as shown below.

END_TIME (CHAR(23),NULLIF '\'),
START_TIME (CHAR(23),NULLIF ' '),

I know the syntax to do one check at a time for a field, but not sure how to add two checks for a single field.

Is anyone aware of the syntax. I checked in the Fastload manual but I didn't find it anywhere. Or is it so that we can check do only a single check for field in the fastload unlike Mload where we can do many.

Thanks in advance for any kind of help / suggestions.

Regards,
SKM
1 REPLY
Junior Contributor

Re: Multiple Nullif checks for a field in Fastload

You can stop looking for the syntax, it just can't be done using FastLoad.
The only way would be writing an INMOD doing the check.

Dieter