RE: Help needed on V5R2 problem with BPCS CEA and CCSID

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Clare Holtham
>
> We have a strange problem at a client in Sweden, can anyone help?
> Or can anyone suggest a change to SQL or ODPs or CCSIDs at V5
> which might affect the way these things work?? (IBM are looking
> at the problem...)
>
> If we remove the SQL statement and use an RPG Chain, that works.
> If we do the SQL interactively, that works.
> If we use ISDB on the pgm, this is what appears to happen -
> The pgm retrieves a record from ZPA (PLANLCTN) with the correct data (01)
> The pgm then goes to record CEAAPCTL in ZPA, but comes back with
> the previous record's data (01).
> So is it not resetting the pointer, or not flushing the buffer,
> or not moving the new data into the fields??

Clare, this is a very strange problem.  The fact that interactive SQL works
but embedded SQL does not really bothers me.

Have you tried writing a simple program that does just the two SQL fetches
using embedded SQL and see if that works?  I'd like to try to isolate this
down to the very minimum required to blow up.

My initial thought is that maybe (just maybe) there's some sort of ALIAS or
VIEW in place that's pointing you at the wrong data.  But at this point, SQL
becomes a magic black box, and this is just one more reason I prefer to use
native access.

Joe