i changed prepare to include an option solved the problem
my $sth = $db->prepare( $sql, { odbc_exec_direct => 1})