Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] DB2 bulkload converts empty strings into null value
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] DB2 bulkload converts empty strings into null value
 Login/Join
 
Platinum Member
posted
In DB2 (and other SQL databases I know) there is a clear difference between a CHAR field with empty string '' value and null (missing) value.
When using DB2 bulkload however data from the source is first put in a tab-delimited file on the DM server which uses unquoted strings, so there is no difference between the 2 values anymore.
This means an empty string in the source data is being loaded as a null value in the target, which is not the same as the source value.
Unfortunately I also have VARCHAR fields in the DB2 target table defined with NOT NULL, so I get errors on those records and they are rejected in the load, while the empty string should be accepted.

The problem seems to be that the intermediate tab-delimited file uses unqouted strings, if it uses quoted strings it would not cause this problem.

Is there some setting that DM will use quoted strings in the intermediate tab-delimited file for the bulkload?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 153 | Registered: March 29, 2013Reply With QuoteReport This Post
<Kathryn Henning>
posted
Hi Martin,

This looks like it's going to require some research, so I'd like to recommend opening a case on InfoResponse Online.

Regards,

Kathryn
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] DB2 bulkload converts empty strings into null value

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.