|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/4/2006 6:20:00 AM
Posts: 1,
Visits: 1
|
|
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
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 2 days ago @ 3:41:05 AM
Posts: 522,
Visits: 264
|
|
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
|
|
|
|