Re: Error message Text for SQL

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Thanks Luis - that appears to be what I was looking for.

The examples all appear to reference "EXCEPTION 1" - e.g.  GET DIAGNOSTICS EXCEPTION 1 error_text = MESSAGE_TEXT;

I cannot find EXCEPTION etc. in the syntax diagram - so it is hard to find what it means. Any idea?

 

On 2013-11-11, at 3:09 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

> Jon,
>
> IIRC, if the SQLCA is used the text is truncated automatically to the first
> 70 positions.
>
> Have you tried using Get Diagnostics? Again, IIRC, it allows you to
> retrieve the full message with the MESSAGE_TEXT option...
>
>
> Regards,
>
> Luis
>
> Luis Rodriguez
> IBM Certified Systems Expert — eServer i5 iSeries
> -- 
>
>
>
> On Mon, Nov 11, 2013 at 3:22 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:
>
> > If I get an error in embedded SQL then SQLERRMC contains part of the error
> > message text - but only the first 70 characters. I can see the full message
> > in the log but really don't want to have to retrieve that.
> >
> > Parts of the manual appear to imply that SQLERRMC can be up to 1,000
> > characters long but I see no sign of how to achieve that.
> >
> > Anybody know if there is a simple way to retrieve the full(er) text?
> >
> >
> > Jon Paris
> >
> > www.partner400.com
> > www.SystemiDeveloper.com
> >
> >
> >
> >
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> > mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> -- 
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com