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 truncates char fields with double quotes
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] DB2 bulkload truncates char fields with double quotes
 Login/Join
 
Platinum Member
posted
I have CHAR fields in a DB2 source table which has sometimes double quotes within the value, for example a company name is: '"Car-Discount" B.V.'
(The single quotes at the beginning and end are not part of the value but the double quotes are)

When this data is transferred by DB2 BULKLOAD from the source table to a target table (with exact same definition, just in different database) I get the following message:
SQL3114W Some data following ""Car-Discount"" in row "F0-2211" and column "10" was not loaded.

In the target table the resulting value is 'Car-Discount', so no quotes at all and truncated.

I noted in the tab-delimited intermediate file it still has the original value, but somehow the db2 client considers it a quoted string because it starts with a double quote and truncates the value after the 'closing' double quote.

Can the DB2 BULKLOAD somehow use properly quoted strings to prevent this problem?
I have also started a case with TechSupport, but maybe someone else has also encountered this issue (in DB2 or other database) and knows how to solve this.

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


WebFocus 7.7.06M/8.2.03M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 149 | Registered: March 29, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
In researching your hottrack case we determined that the DB2 bulk load program defaults to treating double quotes as a character string delimiter; we'll need to change that. In the meantime I would suggest using Insert records from memoy load type instead.
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply 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 truncates char fields with double quotes

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