Re: A problem in embedded SQL

Il 11/12/2019 16:19, Marvin Radding ha scritto:

Jean,

I do trim the fields. And the same sql statement that fails in the RPGLE

program, works in STRSQL. The exact same statement.

Basically, this is hard to accept, and, if true, the only way to fix it
would be to open a PMR with IBM,as it is a flaawn in the SQL engine, and
we canot do anything about it.

Most probably, the statemnt you are executing *isn't* the one SQL
execute. As someone stated, using host variables, you are not seeing the
same statement that the SQL is executing.

If i run into a similar problem, either i'll use the PRTSQLINF as
suggested, or use SQL exit point to monitor the very statement that came
to the engine.

OTH

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com