sp_iqindexrebuildwidedata Procedure

Identifies wide columns in migrated databases that you must rebuild before they are available for read/write activities.

Syntax

sp_iqindexrebuildwidedata [table.name]

Privileges

You must have EXECUTE privilege on the system procedure. You must also have one of the following:

INSERT ANY TABLE system privilege
INSERT privilege on a table to rebuild an index
You own the table

Remarks

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.

Example

Generate wide column rebuild statements for table T2:

sp_iqindexrebuildwidedata T2

Output:

Owner    Table    Column    Domain    Width    IndexType            sp_iqrebuild
DBA      T2       C1        char      1020     Long varchar FP      sp_iqrebuildindex '"DBA.T2"'  'column "C1"  0';