Re: Viewing the resultant SQL in an RPG program

Pete

Even better - do use the Navigator monitor - when you end the monitor, right click it in the list and choose "Analyze results" - in there, take the "extended detailed results" tab and click on the "basic statement information" checkbox - then click on the "view results" button - somewhere to the right will be the statement and the host variables in 2 columns next to each other - you can even see the SELECT statement that generated the report from another button where you hit the "view results" button.

HTH
Vern

-------------- Original message --------------
From: Pete Helgren <Pete@xxxxxxxxxx>

No. But I just did and it works.

Now, to figure out what the problem is with the select statement.

This gets me going again. Thanks,

Pete


Joe Pluta wrote:

From: Pete Helgren

I'll do some trial and error testing of the statement using different
variables and commenting portions of the statement and see if I can
figure out why the SQL is not returning records like I expect. The
*LOVAL/*HIVAL technique is a good one, I just need to know what to
submit in the SQL for *LOVAL and *HIVAL when the field is a 10 character
numeric.

Did you try x'00000000000000000000' and x' FFFFFFFFFFFFFFFFFFFF'?

Joe

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.