9628 error with binaryvar

Hi, I'm having a phenomenon with a script, on some servers it works on others with the same version of informix 14.10 or 12.10 I get this error: 9628: Type (binaryvar) not found. indicating unknowledge about this kind of field. I've been trying to find information about this error but I can't find information... Thanks for any help SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------ #Informix

Sergio: The binaryvar data type is an extended type in the binaryudt package. So what's happening is that one server has had this package loaded into one or more databases and the other has not had it loaded. It is an auto-loading package delivered with the server. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

Thanks for reply Art, Considering I am trying to use one query from IBM support to detect "in place alters", there are any fast alternatives? The test I made with oncheck took about 1 hour, and also using another older SQL I have found was also slow ... SELECT DISTINCT ta.tabname FROM sysmaster:systabnames ta, sysmaster:sysptnhdr pt WHERE ta.partnum = pt.partnum AND BIT_AND(HEX(pt.flags),'00800000'::BINARYVAR) = '00800000';Best regards, SP ------------------------------ Sergio Peres AIRC Coimbra ------------------------------