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