This appendix contains a procedure for upgrading LONG BINARY columns that were created in Sybase IQ 12.5 in versions prior to 12.5 ESD8. If you have LONG BINARY columns created in Sybase IQ 12.5 prior to ESD8, you must follow the first six steps of this procedure before you install Sybase IQ 12.6.
Existing LONG BINARY columns created using any Sybase IQ 12.5 release prior to ESD8 are not supported. You must explicitly drop all existing LONG BINARY columns before you install Sybase IQ 12.6, then recreate them after you install Sybase IQ 12.6. The Sybase IQ 12.6 ALTER DATABASE UPGRADE command does not upgrade LONG BINARY columns created prior to Sybase IQ 12.5 ESD8.
You do not need to upgrade LONG
BINARY columns created in Sybase IQ 12.5 ESD8 or later.
Keep in mind, however, that if the server is not licensed for the
LOB component, the CREATE TABLE and ALTER TABLE
ADD column commands with a LONG
BINARY column are not allowed and return the error “Large
Objects Management functionality is not licensed on this server.”
