Noah Drake 26.Jul.13 01:36 PM a Web browser LEI LEI - 8.0 Windows
I am trying to create a Replication Activity to take data from a DB2 file and update a Notes nsf. I have the fields mapped etc. but I am running into an issue with the data. The DB2 key field can be blank, if that is the case I want to skip it since the file is so large. If the key fields match I want the NSF to update with the DB2 data but there are so many blank records on the DB2 side it is taking too long for the activity to run and it I think the length of time is timing out or something because it says the activity ran but it is not updating anything on the NSF side.
I have tried to write the clause statement (both source and target since I can't really figure out what I need to be looking at) to skip blanks but I keep getting errors on my syntax. Can someone tell me how to write the statement to skip blanks ( I have tried, <>, NE, != and a variation of not equal to "", " ", *blanks, null)