SQL embeded in RPG with passed parameters won't use indexes

[Frank.Kolmann@xxxxxxxxxx]

Did you try STRDBMON on the job to see if the system has any
Index Advised suggestions.

Frank Kolmann

>from: Chris Payne <CPayne@xxxxxxxxxxxxxxx>>
>
>Hello,
>            I have an RPG ILE program in which I embedded a cursor. I
created a
>index on date (dtmv95) for the cursor to hit when I open the file. It
worked
>like a charm. But then I changed the date range in the cursor from being
>static to being brought in by a prompt. Now my program will not use my
index
>when it opens the cursor, it fails with reason code 6 which means that
"The
>keys of the access path did not match the fields specified for the join
>criteria."  I think that the optimizer is not 'seeing' the date criteria
in
>my select because they depend on variables, but I have no idea what to do
>about it. Does anyone out there have any experience with this problem?