Welcome Guest, Not a member yet? Register   Sign In
DB2 - ODBC - transaction problem
#1

Greetings,

I have a problem where i need some help.

I have this in my model (call to a proceedure):


$sql="call proc.stored_procedure( ?, ?, 'PM', '0', cast(null as char), cast(null as char) )";
$this->db->query($sql, array($basketId, $firmNumber));

I am getting an error:
SQL0428N The SQL statement is only allowed as the first statement in a unit of work.

I have tried to use $this->db->trans_strict(FALSE); and $this->db->trans_off() before the call and it doesnt help.

The procedure call works if i call it in DbVisualizer or by using db2cmd.

It is a problem with transaction isolation.

Thank you for your hints.

with regards,

Marko
Reply


Messages In This Thread
DB2 - ODBC - transaction problem - by Kozy - 09-29-2015, 02:41 AM



Theme © iAndrew 2016 - Forum software by © MyBB