Re: Query Optimizer? Reset

On 12 Mar 2013 11:46, Troy Hyde wrote:

<<SNIP>>

I have a file that was created using DDS. A new version was created
but a key field length was changed from 2 to 4. I have a java program
that queries that file using the jt400 toolkit. When I run a query
against the new file, I retrieve the ResultSet metadata to get the
field names and lengths. However, the metadata returned from the
query still gives the old length of the key field that was changed
from 2 to 4. If I change query slightly, the correct metadata is
returned. I believe it is the query optimizer that is returning the
incorrect metadata. How do I reset the query optimizer so that the
new metadata is returned for the query?
<<SNIP>>

The environment being utilized was not described, but perhaps the following [where the environment is described] is a match:

http://sourceforge.net/tracker/?func=detail&aid=3280651&group_id=128806&atid=712772
"...
After the underneath definition of AS/400 physical files changes the ResultSet and ResultSetMetaData got from an SQL query seems not to be aligned to the new definition of the physical files but returns the data according to the old structure of the file.

I'm using the JT400 library (version 7.2) on a Windows XP personal computer with the Sun 1.5.0_22 SE JVM, connecting to a iSeries V7R1M0 machine.
...
This is a server problem. Make sure the V7R1M0 machine has the latest
database fixpack. If this is still a problem, you'll need to contact
server support.
..."