Re: dynamic sql - receive fetched row values into host variables

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 10/19/2017 08:28:01
AM:

so now the handler is working...

I have two small test pgms that call the handler... for a different file

in

each pgm...

when i signon and call the pgm for the first one, it works everytime...
then when I call the second pgm, the test pgm fails with
The target for a numeric operation is too small to hold the result.

however if i sign off and back on and call the 2nd test pgm first, it

works

fine... it just doesn't like the handler being called with a different

file

the second call...

what is that?

The handler is in memory for the call from the second program and
apparently has some variables also in memory that aren't getting
reinitialized for each call. That is also why RCLRSC works -- because it
forces the handler out of memory so that it gets new storage for its
variables when it is loaded again. The solution is to make sure global
variable storage is reinitialized when either the calling program or
requested file changes.


Sincerely,

Dave Clark