Re: An embedded SQL generated EVAL that does not evaluate???

In-line...

On 7/26/2021 2:08 PM, Hiebert, Chris wrote:
..Thank you Chris..

You may not be able to step on those lines in debug.

You would have to specifically compile the precompiler output.
And you would have to make sure the Debug output wasn't being optimized out of the program.

---

True, I was not able to stop on those lines, it skipped past them to the first original source line after the Fetch Next statement.

But I'd wonder why it even matters.
What are you trying to do that you need to "Know" that those values are being set?
Or what are you trying to solve by looking?

----
I'm executing a <Fetch Next from KCQ for :Rows_To_fetch rows into :KCQX,
where the rows_to_fetch is one thousand.
After the Fetch executes, SQLERRD(3) = *ZERO.
But if I run the SQL statement in an interactive SQL window (or even in the 5250),
it gives me several thousand rows.
And, it had been successfully running, and it was getting the records,
when the fetch input the entire record for this file.
This strange behavior happened after I replaced the <select A.*> with
a select of a list of fields instead.

Aaln

Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Alan
Cassidy
Sent: Monday, July 26, 2021 9:06 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: An embedded SQL generated EVAL that does not evaluate???

Sorry if I'm piling on "too much information".

But I have to amend one point. The SQLRPGLE source compiles with zero
errors, zero warnings.

Compiling the QSQLSRC precompiler output produces and identical compiler
listing.

And although the debug does show the line SQLER5 = Rows_To_Fetch, it
does not stop on the line. It seems to skip the precompiler-generated
lines.

aec