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
