I don't remember at what OS release it happened but DB2 introduced a data truncation property on it's driver settings and you need to set it to false as it defaults to true. True means it throws an error, false means it will truncate the data and not throw an error.
From: JAVA400-L [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of a4g atl
Sent: Wednesday, July 11, 2018 2:00 PM
Subject: Issues with either SQL or JAVA after upgrading from v5.4 to v7.2
We have upgraded to V7.2 from V5.4. I do not know if this is a JAVA or SQL
issue or both.
We have a number of Web Methods interfaces to our systems using the JT400
tools. In v5r4 it works fine, but in v7 something is going wrong and the
database or system is returning a data truncation error. We cannot find
what this truncation is.
We installed the latest JT400 on the remote system.
Web methods is trying to do a simple INSERT into a file that returns a
I ran a communications trace with IBM and IBM sees the request, it is
processed and does not return an error.
What is strange is that IBM sees a PREPARE statement but the EXECUTE is
never received from the client system. The client, a UNIX box, does not
send a PREPARE followed by an EXECUTE so IBMi is doing something under the
covers to convert to PREPARE and EXECUTE. This process must be generating
Has anyone experienced this issue and if so, how do you overcome the
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.