Re: Functions with "restricted sql"

Isidre wrote: > I know some restictions about the sql DML use on prodedure/functions > writed with SPL. This restrictions denied the use of > functions/procedures from selects if those procedures/functions have > update/insert/delete statments. In this cases you use the > procedure/funtion via EXECUTE PROCEDURE/FUNCTION. > > Well. My question is: If I rewrite this procedures/functions with > other supported language like C or Java(I prefere Java) the > restriction continue? It should - it isn't much of a restriction if it doesn't. > Environment: > OS -> Solaris 9 > IDS -> 9.4.UC4 with J/Foundation (32 bits, it`s incredible but IDS > 9.4.FCx with J/Foundation not exists for solaris ?'?'?') For a long time, there were major problems with the absence of 64-bit JVMs on some platforms. I don't know that Solaris was one of those. Additionally, IDS has to use an IBM JVM rather than a Sun one - which adds to the complexit. I can't confirm or deny your observation because I don't remember trying to obtain IIF 9.40.FCx for Solaris, as it happens. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/