Re: OPNQRYF syntax error in PDM

We may have an outdated form of BLDQRYSLT. The sa here does ot get wild and crazy and updates. Even when stuff is free. Some months back, I was informed that I needed to find an alternative to ZMODEM as the product was sunsetted. Wrong. We pay support, and an upgrade was available. Just takes kicking the sa in the pants, apparently. Can't get around to installing stuff that has already been paid for.....

I state the above, because I wanted to do a list with BLDQRYSLT, and "our" version did not appear to support %VALUES. No idea what the current version has.

I realize that being on the cutting edge is risky. But, I don't believe it is safer to get years behind, either.

John McKee
-----Original message-----
From: "sjl" sjl_abc@xxxxxxxxxxx
Date: Thu, 31 Mar 2011 10:57:09 -0500
To: midrange-l@xxxxxxxxxxxx
Subject: Re: OPNQRYF syntax error in PDM

John -

I haven't had time to examine it too closely, but %SST or %SUBSTRING is a CL
built-in operation. %subst is the equivalent built-in operation for RPG.

For greater simplicity, my preference has always been to create the QRYSLT
statement section in a separate variable which is then concatenated with
rest. In Control Language, if you have the TAATOOLS installed, BLDQRYSLT is
a great tool for building the QRYSLT statement - it has been around for
almost 30 years...

- sjl


John wrote:
2000 characters.

I don't see how PDM could have an error with cmdbuf if it was too small,
say 100 characters - since this is a syntax issue that I have missed.

This was a modification of an original effort from several years ago.
Been so long, I can't recall how I generated the original,
but I believe I did it from a command line -
then F14 and broke it into chunks. Just didn't break it up nicely.
I can't recall why I did this within RPG except that maybe I had
maybe thought the syntax was easier then with CL.
Written as a CL command, it looked almost as nasty as
some sed expressions I have seen.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.