Re: newbie esql question

On Mar 27, 4:33 pm, "Art S. Kagel (Oninit)" <a...@oninit.com> wrote: > peteli...@yahoo.com wrote: > > You should be seeing 'esql' in $INFORMIXDIR/bin and that directory > should be in your path. If you installed esql into a different > directory than the INFORMIXDIR that your engine files reside in, then > you'll have to set INFORMIXDIR to the actual install directory of esql > and append that bin directory to your path. Then it should work. If > not ping me again or post to the list again. I'm usually browsing the > list several times a day. > > Art S. Kagel > Oninit > > > I'm trying to compile Art Kagel's dostats utility, and I'm having an > > issue with esql, which I've never used before. (We're running IDS 9.4 > > FC6 on an AIX 5.2 server.) > > > Here's what I get when I try to compile: > > digiadm@phms2a:/digi/acct/digiadm/dostats $/opt/freeware/bin/make > > INFORMIXC=gcc esql -o dostats dostats.ec getopt.c> > /bin/sh: esql: 0403-006 Execute permission denied. > > make: *** [dostats] Error 127 > > > In the makefile, I used the default option, ESQL=esql. I also tried > > the other option, ESQL=c4gl, which also didn't work. > > > I can find esql only as a name for directories: > > /digi/informix/lib/esql > > /digi/informix/incl/esql > > > But I can't find a command file named esql. > > > Here's the output for esqlvers: > > digiadm@phms2a:/digi/informix/bin $esqlvers > > IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC2 > > Software Serial Number RDS#N000000 > > > Is the install of esql incomplete? Or am I doing something wrong? > > Thanks. > > > Pete Link > > University of Michigan Health System > > Ann Arbor, MI USA > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list Art, Thanks for your reply. I posted a reply to it on March 28, and got a "successful post" message, but it never showed up. So here's basically what I posted: digiadm@phms2a:/digi/acct/digiadm $echo $INFORMIXDIR /digi/informix digiadm@phms2a:/digi/acct/digiadm $echo $PATH /digi/worx_prod/sqr/bin:/digi/informix/bin:/digi/informix/lib:/digi/ informix/ISA /sbin:/usr/local/bin:/digi/informix/bin:/digi/informix/lib:/digi/ informix/ISA/sb in:/usr/local/bin:/digi/local:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/ bin/X11:/sbi n:/usr/java131/jre/bin:/usr/java131/bin:/usr/localsys/bin:/usr/local/ bin:.:/digi /acct/digiadm::/usr/bin:/digi/informix/bin:/digi/worx_prod/bin:/digi/ worx_prod/s cripts digiadm@phms2a:/digi/acct/digiadm $find / -name esql* > findfile.txt <snip> find: 0652-081 cannot change directory to </proc/397388/object>: : The file access permissions do not allow the specified action. etc... <end snip> digiadm@phms2a:/digi/acct/digiadm $more findfile.txt /opt/freeware/share/vim/vim63/syntax/esqlc.vim /digi/informix/msg/en_us/0333/esql.iem /digi/informix/msg/en_us/0333/esqlc.iem /digi/informix/bin/esqlvers /digi/informix/lib/esql /digi/informix/incl/esql findfile.txt: END Our Informix install was done by our AIX sys admin, but I saw the output from it, and I don't remember any messages regarding esql. Thanks again. --pete link

On Tue, Apr 1, 2008 at 4:50 AM, <petelink1@yahoo.com> wrote: > On Mar 27, 4:33 pm, "Art S. Kagel (Oninit)" <a...@oninit.com> wrote: > > > peteli...@yahoo.com wrote: > > > > You should be seeing 'esql' in $INFORMIXDIR/bin and that directory > > should be in your path. If you installed esql into a different > > directory than the INFORMIXDIR that your engine files reside in, then > > you'll have to set INFORMIXDIR to the actual install directory of esql > > and append that bin directory to your path. Then it should work. If > > not ping me again or post to the list again. I'm usually browsing the > > list several times a day. > > > I'm trying to compile Art Kagel's dostats utility, and I'm having an > > > issue with esql, which I've never used before. (We're running IDS 9.4 > > > FC6 on an AIX 5.2 server.) > > > > > Here's what I get when I try to compile: > > > digiadm@phms2a:/digi/acct/digiadm/dostats $/opt/freeware/bin/make > > > INFORMIXC=gcc esql -o dostats dostats.ec getopt.c> > > /bin/sh: esql: 0403-006 Execute permission denied. > > > make: *** [dostats] Error 127 > > > > > In the makefile, I used the default option, ESQL=esql. I also tried > > > the other option, ESQL=c4gl, which also didn't work. > > > > > I can find esql only as a name for directories: > > > /digi/informix/lib/esql > > > /digi/informix/incl/esql > > > > > But I can't find a command file named esql. > > > > > Here's the output for esqlvers: > > > digiadm@phms2a:/digi/informix/bin $esqlvers > > > IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC2 > > > Software Serial Number RDS#N000000 > > > > > Is the install of esql incomplete? Or am I doing something wrong? > > > Thanks. > Art, > Thanks for your reply. > I posted a reply to it on March 28, and got a "successful post" > message, but it never showed up. > So here's basically what I posted: > > digiadm@phms2a:/digi/acct/digiadm $echo $INFORMIXDIR > /digi/informix > > digiadm@phms2a:/digi/acct/digiadm $echo $PATH > /digi/worx_prod/sqr/bin:/digi/informix/bin:/digi/informix/lib:/digi/ > informix/ISA > /sbin:/usr/local/bin:/digi/informix/bin:/digi/informix/lib:/digi/ > informix/ISA/sb > in:/usr/local/bin:/digi/local:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/ > bin/X11:/sbi > n:/usr/java131/jre/bin:/usr/java131/bin:/usr/localsys/bin:/usr/local/ > bin:.:/digi > /acct/digiadm::/usr/bin:/digi/informix/bin:/digi/worx_prod/bin:/digi/ > worx_prod/s > cripts > > digiadm@phms2a:/digi/acct/digiadm $find / -name esql* > findfile.txt > <snip> > find: 0652-081 cannot change directory to </proc/397388/object>: > : The file access permissions do not allow the specified action. > etc... <end snip> > digiadm@phms2a:/digi/acct/digiadm $more findfile.txt > /opt/freeware/share/vim/vim63/syntax/esqlc.vim > /digi/informix/msg/en_us/0333/esql.iem > /digi/informix/msg/en_us/0333/esqlc.iem > /digi/informix/bin/esqlvers > > /digi/informix/lib/esql > /digi/informix/incl/esql > findfile.txt: END > > Our Informix install was done by our AIX sys admin, but I saw the > output from it, and I don't remember any messages regarding esql. > Thanks again. It appears that your Informix install includes IDS but does not include CSDK. You will need CSDK to compile Informix related programs. I assume you also have a C development system installed (C compiler, make, etc) -- because if you don't, you will need those too. You don't need $INFORMIXDIR/lib on $PATH. You could also benefit using this clnpath script on your PATH variable: : "@(#)$Id: clnpath.sh,v 1.6 1999/06/08 23:34:07 jleffler Exp $" # # Print minimal version of $PATH, possibly removing some items case $# in 0) chop=""; path=${PATH:?};; 1) chop=""; path=$1;; 2) chop=$2; path=$1;; *) echo "Usage: `basename $0 .sh` [$PATH [remove:list]]" >&2 exit 1;; esac # Beware of the quotes in the assignment to chop! echo "$path" | ${AWK:-awk} -F: '# BEGIN { # Sort out which path components to omit chop="'"$chop"'"; if (chop != "") nr = split(chop, remove); else nr = 0; for (i = 1; i <= nr; i++) omit[remove[i]] = 1; } { for (i = 1; i <= NF; i++) { x=$i; if (x == "") x = "."; if (omit[x] == 0 && path[x]++ == 0) { output = output pad x; pad = ":"; } } print output; }' I use: export PATH=$(clnpath $PATH) YMMV, depending on your shell. OK, so that's an over-simplification: actually, I use more complicated things like: export PATH=$(clnpath $INFORMIXDIR/bin:$PATH $oldixdbin) This adds the new $INFORMIXDIR/bin to the front of PATH, and removes the save value of the old Informix bin directory so I only have one entry for Informix in my PATH. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.