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.

cartouchbea@gmail.com 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.sqlr.doc/sysproccolumns.htm#sysproccolumns 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...