Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-10 : 07:51:24
|
| Circ writes "I am having trouble figuring out how to handle Null values that are passed to a lookup inside a Data Driven Query task. what I have is a lookup that contains all the fields in a table, and I pass it every field, so that it can check if the row needs to be updated. My problem is that some of the fields can be NULL, and in the lookup when I have ID = ? and the value is NULL, it brings back a row when I do not want it to. I understand that the = NULL will bring back the rows, but what I need is a way to somehow switch between a "= ?" and a "is ?". I am sure there must be a simple way to do this as it seems like it would come up alot. I have no control over the original data, as it is a datafeed from a flat file." |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-10 : 12:38:50
|
| Is the flat file from the mainframe?DB2 Supplies a Null indicator of "?" on unload if there is no data.More than likely you have spaces where the column is suppose to unloaded to.Also I'm guessing it's fixed width.I would suggest a bcp to a work table.Brett8-) |
 |
|
|
|
|
|
problem with Nulls in a lookup