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

[a4g atl <a4ginatl2@xxxxxxxxx>]

Thanks

1. I forgot about the DB monitor and I did check for the changes to the SQL
in V6.1. Nothing seemed obvious.

I'll try the DBMONITOR and see how well I can interpret it.

thank you.

Darryl

On Fri, Sep 30, 2016 at 12:04 AM, Elehti <eric@xxxxxxxxxx> wrote:

> Read the IBM 6.1 release notes. Some SQL statements fail at 6.1 because
> this release adheres more closely to ANSI standard, thus abending with that
> message. You can work around this by creating a data area object that
> enables your SQL statements to perform like they did in previous release.
> Ask IBM
> On Sep 29, 2016, at 15:26, a4g atl <a4ginatl2@xxxxxxxxx> wrote:
>
> 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.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.