Hi,
I am getting an error? Can somebody explain why I am getting this error.
What this error code means? Even though it is giving this error, its
getting the data fine. No problems with the data its retreiving, but only
throwing an extra error. In which cases we get this error?
DBD::Informix::st fetchrow failed: SQL: -1227: <<Failed to locate SQL error
message>> at mr_track line 53.
Here is the part of the code that's causing the error. If I run the same
SQL statement thru isql, its working fine. Only problem if I run from the
perl script.
my $stmt = qq[select unit,file,user_id,cr,submit_dt,env_rel,real_rel,sid
from vsmrfi where cr='$mr_number' and sid='$sid' and unit='$unit' and file
='$file'];
my $sth = $dbh->prepare($stmt);
$sth ->execute;
while (@row = $sth->fetchrow) {
print "ROW: @row\n";
}
Thanks in advance.
Rajeev Nalluri
