Is there a way to debug or trace a SQL statement submitted from a client system.

We are on v6.1 just recently upgraded to it on the way to 7.1.

A insert into our table from a remote system using Web Methods is failing
with a SQL0104 if i remember.

The statement is rejected and I cannot see what is wrong or what the system
sees to reject it.

This is the statement generated by WebMethods.

"INSERT INTO OEFILES.FTFOLHDV(H1ORTP, H1ORD#, H1CPO#, H1EDAT, H1CST#,
H1BNAM, H1BAD1, H1BAD2, H1BCTY, H1BSTE, H1BZIP, H1BCNT, H1SNAM, H1SAD1,
H1SAD2, H1SCTY, H1SSTE, H1SZIP, H1SCNT, H1LNTL, H1RDAT, H1PDAT, H1MFOR,
H1SHPC, H1SHPM, H1PLST, H1OPO#, H1OPOL, H1DROP, H1QUOT) VALUES (?, ?, ?, ?,
?, coalesce(?,' '), coalesce(?,' '), coalesce(?,' '), coalesce(?,' '),
coalesce(?,' '), coalesce(?,' '), coalesce(?,' '), ?, ?, coalesce(?,' '),
?, ?, ?, ?, ?, ?, ?, coalesce(?,' '), coalesce(?,' '), coalesce(?,' '),
coalesce(?,' '), coalesce(?,' '), coalesce(?,' '), ?, coalesce(?,' '))". "

(22001/0) Data truncation"


We have tried updating the JDBC but that did not help.


TIA


Darryl Freinkel.