4 Replies Latest reply: Jan 31, 2012 8:21 PM by Johannes Sunden RSS

    Resident load where field is not null

    Matthew Green



      I'm trying to restrict a resident load to where a particular field is null.


      I've tried


      RESIDENT TableName
      WHERE NOT FieldToCheck IS NULL;


      But this didn't work.


      I can't do the restriction in the sql load statement, since I need the cases where the field is null to be present in another resident load.


      Any help would be appreciated.