Receieving Error Messages In Stored Procedures

[Liam1]

Hello,

I know who to return an error code from within a stored procedure, using SQLCODE. Is there a way to get the full corresponding error message back too?
i.e. Table_1 does not exist
I have tried SQLERRM, but this is not recognised.

Do I have to write my own, or am I missing something?

Thanks in advance,

Liam.

 

[dnoeth]

select * from dbc.errormsgs
where errorcode = :sqlcode;

will return the message template, but the actual table name is missing:
"Object '%VSTR' does not exist"

Dieter