Re: ISQL7.50.UC5 show error messages
On Wed, Sep 21, 2011 at 23:59, SASCHA KURATIS <sascha.kuratis@westfleisch.de > wrote: > I think the ISQL error message files are installed correctly. The error > message file is installed in "$INFORMIXDIR/msg/en_us/0333/errmsg.txt" and > the > environment variable "SQLERRORFILE=$INFORMIXDIR/msg/en_us/0333/errmsg.txt" > is > pointed to that file. > errmsg.txt is text file that contains a variant of the error messages plus an expanded explanation of what the errors mean. It is used by finderr and rofferr. Furthermore i can use the finderr command without any problems. > When i do e.g a "finderr 3400" i get the following Output: > > "-3400 There are no rows satisfying the conditions. > > No rows in the database match the values that are entered in the form. > Enter different values, and query again." > That's good, as far as it goes. > Any other ideas, why i get only the error numbers in ISQL7.50.UC5 ? > The programs (other than finderr and rofferr) do not use errmsg.txt; they use the various *.iem files. You need to work out which file it should be in. The answer seems to be 'perf.iem'. First question: does that file exist in $INFORMIXDIR/msg/en_us/0333? If not, then you need to install ISQL properly into your $INFORMIXDIR. Second question - assuming the answer to the first is 'no': Does that file contain message -3400. I have a message file decompiler called listiem; there is a version of that available in the IIUG Software Archive (Miscellaneous section). -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --000e0cd5743a7555cc04ad89da63
Hi. It still doesn`t working. We have downloaded the message file compiler listiem from the iiug-software archive and looked with this tool in perf.iem. perf.iem contains all error messages and error -3400 as well. The file perf.iem exists in $INFORMIXDIR/msg/en_us/0333/, too. Has anybody an other idea, why we can`t display the error messages in ISQL7.50.UC5 instead of the error numbers, which were displayed at the moment due to an error? Thanks for your help. Sascha
Try making a copy of the message file (or a link to it) in $INFORMIXDIR/msg. Some of the older tools didn't understand the subdirectories and wanted the message files in the grandparent directory. I would think that ISQL 7.50 would have that fixed, but it's worth a try. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Oct 5, 2011 at 7:51 AM, SASCHA KURATIS < sascha.kuratis@westfleisch.de> wrote: > Hi. > > It still doesn`t working. > We have downloaded the message file compiler listiem from the iiug-software > archive and looked with this tool in perf.iem. > perf.iem contains all error messages and error -3400 as well. > The file perf.iem exists in $INFORMIXDIR/msg/en_us/0333/, too. > > Has anybody an other idea, why we can`t display the error messages in > ISQL7.50.UC5 instead of the error numbers, which were displayed at the > moment > due to an error? > > Thanks for your help. > > Sascha > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba3fcde7c8721604ae8e3321
On Wed, Oct 5, 2011 at 04:51, SASCHA KURATIS <sascha.kuratis@westfleisch.de>wrote: > It still doesn`t work. > We have downloaded the message file compiler listiem from the iiug-software > archive and looked with this tool in perf.iem. > perf.iem contains all error messages and error -3400 as well. > The file perf.iem exists in $INFORMIXDIR/msg/en_us/0333/, too. > > Has anybody an other idea, why we can`t display the error messages in > ISQL7.50.UC5 instead of the error numbers, which were displayed at the > moment > due to an error? > If the message files are in place and contain the message, then the next question is 'what is your environment set to'. There are a lot of environment variables that could be affecting this, but the primary ones are: CLIENT_LOCALE LC_ALL LANG Other LC_* variables plus some obscure (archaic) NLS ones might also be a factor. Moving the files into $INFORMIXDIR/msg (or linking them there from $INFORMIXDIR/msg/en_us/033) is not going to help - barring extraordinary bugs in the software. ISQL 7.50 uses CSDK 3.50 (still), and CSDK is quite happy with GLS (and ISQL has been happy with it too since at least ISQL 7.30, probably even 7.20). -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --0015177418a0ac5aae04ae90da60