Turnover question

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
We have a SQLRPGLE program generated with Turnover.  We keep getting the
message that the program was changed outside of turnover.  We do a DSPOBJD
and the only thing we see different is the last used and the change date.

Scenario:
Two 5250 sessions.
Session 1 generates program.
Session 2 does dspobjd and notes change time.
Session 1 starts program.
Session 2 does dspobjd and notices that last used is different but change
time is same
Session 1 moves from first screen to second screen.
Session 2 does dspobjd and notices that last used and change time have not
changed since last checking.
Session 1 moves from second screen to third screen.
Session 2 does dspobjd and notices that last used has not changed since
last checking, but changed has.
We've not exited the program at any time between the many dspobjd's.
Regen the program using Turnover and get message that program has been
changed outside of Turnover.

Scenario two:
Gen the program using Turnover
Gen it again but this time no message that the program has been changed
outside of Turnover.

Future runs of the program do not change the changed time.  Just the first
run.

What the heck is going on here?  Does it optimize an SQL statement and
store that into the compiled object?

All three screens have SQL in them.

My biggest concern is that developers will become numb to the warning that
the object has been changed outside of Turnover.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin