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 or later versions.
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 created prior to Sybase IQ 12.5 ESD8 before you install Sybase IQ 12.6 or later versions, then recreate them after you install Sybase IQ 12.6 or later versions. The ALTER DATABASE UPGRADE command of Sybase IQ 12.6 and later versions 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.”
