Re: JDBCR4 retrive error description

Hi all

I'm going to use Scott's JDBCR4 for sync some DB2 Table with MS SQL Table;
as I need to trace and log the errors the I can get when I write or update
the MS SQL table, is there anyway to capture/get the message error like
Duplicate key or other similar error ?

For example : looking the examples in JDBCR4 library I see


rc = JDBC_ExecUpd( conn : 'Create Database testsck'

+ ' Default Character Set utf8'

+ ' Collate utf8_bin' );

if (rc < 0);

ErrMsg = 'Unable to CREATE database';

return *OFF;

endif;


in this case, can I get the cause why the CREATE database failed ? (already
exist , invalid name .. .)


thanks