newbie esql question

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

petelink1@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-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > >

This may have been gone over before, though I have found little about it in my searches. If so, I apologize. We use a proprietary administrative system for our university. Sometimes, when it calls an application from the menu, it changes the real and effective user. I have a need to limit who can change work records (used for both our employees and to track constituent employers) for our employees. So I can't just limit the permissions of the table, since it is also used for other constituents. I created a procedure attached to a trigger to check who is doing the update. However, the USER function returns the changed uid's login. I have tried creating a c udr that returns the effective uid, real uid, or login attached to the tty. Nothing seems to return the actual user who is logged in. So, I was wondering if anyone had any ideas on how I might find out who is actually logged in even though the process is running under setuid? Perhaps another c function somewhere that holds the original uid? Thank you, Jim Goldrick Judson University 1151 North State Street Elgin, Illinois 60123 573-332-7739 http://www.judsonu.edu jgoldrick@judsonu.edu