System stored procedures

System stored procedures are owned by the user ID dbo. The following system procedures carry out system administrator tasks in the IQ Store.

NoteBy 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.