scottklement.com

I extracted the SQL of a "summary only" WRKQRY using RTVQMQRY. The query has "Use Rounding" set to Y. I've done this before, and with some tweaking and using aggregate functions, have been able to replicate queries in SQL accurately. In this case, however, I kept running into errors when trying to ...

Scott Klement wrote: Wed Jul 09, 2025 11:27 pm hope that helped.

It did. Many thanks!

As a follow-up:

I understand that CALL will send a char(32), so if my prototype expects a char(32) (or shorter) and I send a parm that is 7 characters long, then the trim works as expected because my program's receiving a char(32), comprised of my 7 char string and 25 blanks at the end.

If ...

Ah, thank you both--that makes sense. I appreciate the education!

I have a program with a Main prototype (and matching pi) containing two char parameters. In my program, I'm ascertaining the "actual" lengths of the input parameters using %len and %trim, like so:

%len(%trim(var1));

I'm testing this by calling it from green screen and passing it params of length 7 ...