Re: How to retrieve second level text from message in SQL stored procedure

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi James

I don't know about anitmatter! Yes, those commands and APIs exist. If 
you are using embedded SQL in RPGLE, GET DIAGNOSTICS is recommended, it 
is a standard SQL-ish methodology, so far as I know.

And if you *are* writing an SQL procedure, not a external one, it's a 
better option.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.x5XzrAum.3oaOtTJq@centurylink.net> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023

On 6/13/2025 10:15 AM, James H. H. Lampert via MIDRANGE-L wrote:
> I may be sucking antimatter on this, but as I recall,
>
> (1) there are CL commands and/or system APIs to retrieve messages from 
> the job's message queue, including the second-level text, and
>
> (2) SQL stored procedures don't *have* to be pure SQL.
>
> --
> JHHL