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

[cesco <emaxt6@xxxxxxxxx>]

 do you have the subreason?
have a look here if that orients you further
DSPMSGD RANGE(SQ30082 SQ30082) MSGF(QSQLMSG)


    On Thursday, June 12, 2025 at 03:26:28 PM GMT+2, Rob Berendt <robertowenberendt@xxxxxxxxx> wrote:  
 
 Busier than an admin trying to prep for upgrading 3 power systems next week
while leaving for vacation in an hour and a half but try this:
https://www.ibm.com/docs/en/i/7.6.0?topic=services-joblog-info-table-function

On Wed, Jun 11, 2025 at 6:22 PM Dan Bale <dan.bale@xxxxxxxxxxxxxxxxxxxxx>
wrote:

> "GET DIAGNOSTICS CONDITION 1 V_SQLSTATE = RETURNED_SQLSTATE , V_ERRORMSG =
> MESSAGE_TEXT" returns SQL state and the first level text of the associated
> message for the SQL code.  Does anyone know how to retrieve the second
> level text *with data*  of the message?  I'm getting SQ30082's first level
> message "Authorization failure on distributed database connection attempt",
> but the second level text provides the reason for the error.
> *** CONFIDENTIALITY NOTICE: The information contained in this
> communication may be confidential, and is intended only for the use of the
> recipients named above. If the reader of this message is not the intended
> recipient, you are hereby notified that any dissemination, distribution, or
> copying of this communication, or any of its contents, is strictly
> prohibited. If you have received this communication in error, please return
> it to the sender immediately and delete the original message and any copy
> of it from your computer system. If you have any questions concerning this
> message, please contact the sender. ***
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.