Strange behavior of DBD/DBI Informix
Posted in 2003
I am not sure if this list is the best one to post to regarding this problem. If not please point me to the better one. Consider the following scenario: 1)$dbh = DBI->connect("dbi:Informix:$database", '', '', { PrintError => 1, RaiseError => 1}); 2)$sql = qq{ INSERT INTO sometable VALUES ( somevalues ) }; 3)$sth = $dbh->prepare( $sql ) or die "Failed to prepare '$sql'\\n"; 4)$dbh->disconnect; 5)N statements of the form $sth->bind_param( K, somevalue ); (K=1..N) 6)$ret = $sth->execute; After doing 4) I still can execute 5) and 6) without any obvious error message. Of course no insert occurs but it is not clear why (supposing we do not know about 4). Even more, while testing the return code $ret We still can not understand what is the problem. $ret is equal to '0E0' that can mean 1) "statement does not affect any rows" 2) "cursor is opened successfully" All of $@ $DBI::errstr sqlcode sqlerrm show nothing in this situation. Should I check something else? Is it bug ("feature")? Your comments are very welcome. Alexandre Krasnov. (TERN Group - Russia) sending to informix-list