System stored procedures

System stored procedures are owned by the user ID dbo. The system procedures in this section carry out System Administrator tasks in the IQ Store.

NoteBy default, the maximum length of column values displayed by DBISQLC is 30 characters. This might be inadequate for displaying output of stored procedures such as sp_iqstatus. To avoid truncated output, increase the length by 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.