I have an SQL stored procedure that if called with the db2cmd or the GUI command center works. But if I call the stored proc trought an ODBC or db2cli it looks like it executes the stored proc but nothing happens in the database.

Here is the command used trought ODBC or db2cli:

{CALL CTI.UPDATEAFFICHEFILE ('99','99','99','1')}

here is the message I get with my ODBC query tool:

13:35:16 [{CALL - 0 rows, 0.000 sec] Command processed but no rows were affected
... 1 statement executed, 0 rows affected

Any solutions or theories would be appreaciated!