Identifies wide columns in migrated databases that you must rebuild before they are available for read/write activities.
sp_iqindexrebuildwidedata [table.name]
User must be a table owner, have INSERT permission on a table to rebuild an index on that table, or have the INSERT ANY TABLE system privilege.
CHAR, VARCHAR, BINARY, and VARBINARY columns wider than 255 characters, as well as all Long Varchar and Long Binary columns in databases migrated to SAP Sybase IQ 16.0 must be rebuilt before the database engine can perform read/write activities on them. sp_iqindexrebuildwidedata identifies these columns and generates a list of statements that you can use to rebuild the columns with the sp_iqrebuildindex procedure.
Include the optional [table.name] parameter to generate a list of wide columns for that table. Omit the [table.name] parameter to generate a list of wide columns for all tables in the database.
sp_iqindexrebuildwidedata T2
Owner Table Column Domain Width IndexType sp_iqrebuild DBA T2 C1 char 1020 Long varchar FP sp_iqrebuildindex '"DBA.T2"' 'column "C1" 0';