Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  9628 error with binaryvar

    Posted 08/17/22 07:37 AM
    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


  • 2.  RE: 9628 error with binaryvar

    Posted 08/17/22 08:07 AM
    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
    ------------------------------



  • 3.  RE: 9628 error with binaryvar

    Posted 08/17/22 08:59 AM

    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
    ------------------------------

    Original Message