Informix error 668

[Swee Wilson]

I've seen a posting before regarding this error.
I have a stored procedure that is giving me this problem.

create procedure jdate()
system "/bin/date";
end procedure;

I did a tracing on this sp:

trace on
system : /bin/date
exception: looking for handler
SQL error = -668 ISAM error = -1 errorstring = = " "
exception - no appropriate handler

Firstly, I've checked the permissions of the executable, and everyone
can run it. Secondly, the dir /bin is open to everyone.

I am tempted to reinstall Online, since according to the /etc/.snfile
the sequence of installation is incorrect. I think it was installed
in this order:

a) Online 5.01
b) Star 5.01
c) SQL 4.11

Any suggestions?

Thanks,

Wilson
P.S Please CC replies via swi...@starnet.gov.sg

[Mark Denham]

Wilson wrote:

>I've seen a posting before regarding this error.
>I have a stored procedure that is giving me this problem.

>create procedure jdate()
>system "/bin/date";
>end procedure;

>I did a tracing on this sp:

>trace on
>system : /bin/date
>exception: looking for handler
>SQL error = -668 ISAM error = -1 errorstring = = " "
>exception - no appropriate handler

>Firstly, I've checked the permissions of the executable, and everyone
>can run it. Secondly, the dir /bin is open to everyone.

>I am tempted to reinstall Online, since according to the /etc/.snfile
>the sequence of installation is incorrect. I think it was installed
>in this order:

>a) Online 5.01
>b) Star 5.01
>c) SQL 4.11

I have also seen this one, although I am pretty sure that it was nothing to
do with the order that the products were installed. In our case we had 2
machines with different versions of the products, both setup by the same
person. One worked and the other did not. The only difference was the
versions of informix.

It works on 5.03.UC3, I have just tested it. You do need to redirect the
output in order to see anything from it.

Mark Denham
BBC
London, UK
Mark....@bbc.co.uk