Thanks Mark,
I know why we got this problem. Last weekend we upgraded the informix
server to 9.21. I think I may need to either re-install DBD or re-compile
DBD with the new Informix PATH. Can you please tell me how can I recompile
the DBD with the new INFORMIX variables.
Regards,
Rajeev Nalluri
Mark Thornber
<emthornber@i To: Rajeev Nalluri
<[EMAIL PROTECTED]>
ee.org> cc: [EMAIL PROTECTED], (bcc: Rajeev
Nalluri/Telcordia)
Subject: Re: Informix DBD Error
10/08/01
11:49 AM
Rajeev,
Rajeev Nalluri wrote:
> 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.
This is telling you the error - cannot find error text file
From Informix Error Messages:-
"-1227 Message file not found.
4GL cannot locate a file of message texts. The file should have a suffix of
.iem
and be in the product directory, $INFORMIXDIR/msg. Reinstall such files
from the distribution materials. If you have started to modify the
user-message file, 4glusr.msg, check that its compiled form has been
replaced in the correct directory."
>
> 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.
I presume your environment for the perl script is not the same as for
the isql usage - check $INFORMIXDIR now against what it was when
DBD::Informix was built. Jonathan Leffler will know for certain - he's
the DBD::Informix Guardian.
--
MarkT
