Re: JDBCR4 retrive error description

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Any errors should be printed to stdout.

On 6/6/2017 11:37 AM, gio.cot wrote:
> 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
>
>