Re: spl decompiler

Frederic, I'm curious about your -710 error, as we ran into them in an application that we wrote which runs in the HDR environment under 7.12. It appears that any prepared statements get invalidated at times when running on HDR primary servers. We had to put in logic to catch the -710 and reprep the statements and cursors. Are running HDR, or getting the errors under a different circumstrance? Thanks, Peter Sylvester MITRE Corporation F.PALMITJAVILA wrote: > David Kosenko wrote: > > > "Leffler, Jonathan" <jleffler@visa.com> offerred: > > +>If an spl decompiler exists, its my solution. > > +>If you know one, please tell me. > > + > > +Why would you need one? The source for the SPL is stored in the > > database > > +along with the compiled code (so it can be reoptimized when > > necessary), so > > +there shouldn't be any reason why you need the decompiler > > > > Well, one of the options we discuss in class for creating "secure" > > stored procedures (i.e. one that nobody knows what it does) is to > > remove the uncompiled version from the database. Since the compiled > > version is still present, the procedure will run, but no nosy > > individuals can go poking around it. This is ESPECIALLY useful in > > situations where a vendor is creating a system for deployment on > > customer sites. Anyone at the customer site could have informix login > > capabilities, and thus be able to hit the database, dump the SPL code, > > rewrite the procedure to their liking and rebuild the proc, possibly > > defating the purpose the procedure had in the first place. By pulling > > the source out, that is not possible. > > > > Just a thought. > > That is my problem: I have purchase informix aplication software , but the > source code of spl is NOT in the systables. The software runs normaly > good, but an persistent error -710 appears. The only way to repare is > stop informix and run update statistics. The informix service says that I > need to look in the source code of the stored procedures, but I don't have > it!!! > HELP! > Frederic Palmitjavila > malestivat@andorra.ad