SQL issues after upgrading from V5R4 to V7.2
a4g atl <[email protected]>
| Newsgroups | gmane.comp.hardware.ibm.midrange,gmane.comp.lang.as400.java |
|---|---|
| Message-ID | <CA+3DDvU4F2=3q1VAjB3LkwpqegFUw=uYNLmB_oN9nXYRm_6MDQ@mail.gmail.com> |
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 truncation error. 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 the error. Has anyone experienced this issue and if so, how do you overcome the problem. TIA Darryl Freinkel. -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support-Zwy7GipZuJhWk0Htik3J/[email protected] for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD