Re: JDBCR4 service pgm usage question

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

RowCount should be the number of rows that were modified.   So in the 
case of an UPDATE statement, it *should* be the number of rows that got 
changed.   However, on a CREATE TABLE or something like that, it would 
be 0 for success, since it doesn't work at the row-level.


MKirkpatrick@xxxxxxxxxxxxxxxxx wrote:
> I have been using Scott K's JDBC service pgm for some time with great 
> results against my WIN DB2 tables.  I do very simple things like read and 
> update these tables.  This morning I had an issue running the same pgm 
> that had run last Friday night without any problem.  This morning when I 
> ran my pgm, no errors were kicked out BUT my Win DB2 table did not get 
> updated.  My SELECT to read rows worked fine. I use the following to 
> update:
>
> stmt = JDBC_PrepStmt(conn: 'UPDATE   DCMS.WEB_PAYMENT '
>                                     + 'set UPDATE_USERID = ? , '
>                                     + 'UPDATE_TIMESTAMP = ? , '
>                                     + 'PROCESS_NOTE = ? ,  '
>                                     + 'ORTHO_SYS_PROCESSED = ?   '
>                                     + 'where '
>                                     + 'CHART_OFFICE = ? '
>                                     + 'and CHART_NUMBER = ? '
>                                     + 'and TRANSACTION_DATE = ? '
>                                     + 'and TRANSACTION_NUM = ? ');
>
>            if (stmt = *NULL);
>              ErrMsg = 'Prepare Statement failed!';
>              return;
>            endif;
>
>            JDBC_setString   (stmt: 1: wUserID       );
>            JDBC_setTimeStamp(stmt: 2: %timestamp()  );
>            JDBC_setString   (stmt: 3: wProcNote     );
>            JDBC_setString   (stmt: 4: 'Y'           );
>            JDBC_setInt      (stmt: 5
>                             : %int(JDBC_GetColByName(rs:'CHART_OFFICE')));
>            JDBC_setInt      (stmt: 6: dCHART        );
>            JDBC_setDate     (stmt: 7
>                             : %date(JDBC_GetColByName(rs
>                             : 'TRANSACTION_DATE'): *iso));
>            JDBC_setString   (stmt: 8
>                             : JDBC_GetColByName(rs:'TRANSACTION_NUM'));
>
>            RowCount = JDBC_ExecPrepUpd( stmt );
>            if (RowCount < 0);
>              ErrMsg = 'Execute Prepared Failed!';
>              return;
>            endif; 
> RowCount was 0.  Does this mean no rows were updated or just that the 
> operation completed without error?
> Also, is there a way of viewing the contents of the SQL UPDATE statement 
> as it will be executed
> I am just not sure how to debug this problem as I can't seem to find any 
> error.  Any help is appreciated.  Thanks.