RE: Error message Text for SQL

Bad Memory ....but I think you can with GET DIAGNOSTICS and MESSAGE_TEXT VARCHAR(32672)

Regards,
Bill Hopkins

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Monday, November 11, 2013 2:53 PM
To: Rpg400 Rpg400-L
Subject: Error message Text for SQL

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.