Getting function return type(s) from SMI

I've got some SPL "not variant" functions that I would like to begin
using as keys for some indexes in a database. I also have an
automated re-indexing process that runs periodically that will
calculate the amount of disk space that an index will take when the
index is regenerated. However, I don't have a good way to determine
the size of the key if a function is in the key. Is there some way to
accomplish this through some query of SMI? When I look at the values
in sysprocedures.ret_len, it doesn't really look accurate.

Thanks in advance.

wrote:
> I've got some SPL "not variant" functions that I would like to begin
> using as keys for some indexes in a database. I also have an
> automated re-indexing process that runs periodically that will
> calculate the amount of disk space that an index will take when the
> index is regenerated. However, I don't have a good way to determine
> the size of the key if a function is in the key. Is there some way to
> accomplish this through some query of SMI? When I look at the values
> in sysprocedures.ret_len, it doesn't really look accurate.
>
> Thanks in advance.

I haven't checked the contents. But maybe you want to take a look at:

http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sq...doc/sys

Without checking it, I can only suggest that you'd have to decode the datatype
where paramattr=5 and in some cases (CHAR) check the paramlen.

Regards.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...