How to get errors and messages like "DB20000I The SQL command completed successfully"?

[makafonov]

Hello. Hoping someone can help. I try to get errors and messages like "DB20000I The SQL command completed successfully". It's my code:

ibm_db_conn = ibm_db.connect(conn_str, '', '')

sql = "UPDATE VMVP.settings SET setting_value='2040' WHERE setting_name = 'bad_option'"

try:

    stmt = ibm_db.exec_immediate(ibm_db_conn, sql)

except Exception:

    print('Transaction couldn\'t be completed:', ibm_db.stmt_errormsg())

else:

    print('Transaction complete.') ibm_db.close(ibm_db_conn)

When I specify an invalid parameter in the SQL statement like "bad_option", I receive every time "Transaction complete" without any errors.

[Василий Макафонов]

How to get errors?

[Saba Kauser]

Hi ,

We have APIs documentation with examples here :

https://github.com/ibmdb/python-ibmdb/wiki/APIs#ibm_dbstmt_errormsg

You  can extract error messages using ibm_db.stmt_errormsg() and

ibm_db.conn_errormsg() .

The one like Db200001 are CLP specific  messages.

[Saba Kauser]

Also, from your update statement it seem like you have setting_name as char column and 'bad option' is just like the other value '12345'. Why are you expecting an error?

[makafonov]

I expected to get something like this: "SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000", because I don't have a row in a table with value bad_option in column setting_name. But every time exceptions don't raise and I receive "Transaction complete".

вторник, 7 июля 2020 г. в 09:03:02 UTC+5, Saba Kauser:

[Saba Kauser]

Can you raise a issue in github here -> https://github.com/ibmdb/python-ibmdb/issues

I can update the code to return warning message for sqlcode 100.

Thanks!