System stored procedures are owned by the user ID dbo. The following system procedures carry out system administrator tasks in the IQ Store.
By default, the maximum length of column values displayed
by DBISQLC is 30 characters. This may be inadequate for displaying
output of stored procedures such as sp_iqstatus.
To avoid truncated output, increase the length by setting the TRUNCATION_LENGTH option
using SET OPTION DBO.TRUNCATION_LENGTH = 80
.
Alternatively, from the dbisql menu select Command → Options
and enter a higher value for Limit Display Columns and/or
Limit Output Columns.