Procedures and Functions

Use the system-supplied stored functions and procedures in SAP Sybase IQ databases to retrieve system information.

• sa_get_ldapserver_status System Procedure
  Determines the current status of the LDAP server configuration object.
• sa_get_user_status system procedure
  Allows you to determine the current status of users.
• sp_create_secure_feature_key System Procedure
  Creates a new secure feature key.
• sp_displayroles System Procedure
  Displays all roles granted to a user-defined role or a user, or displays the entire hierarchical tree of roles.
• sp_expireallpasswords System Procedure
  Immediately expires all user passwords.
• SP_HAS_ROLE Function [System]
  Returns an integer value indicating whether the invoking user has been granted a specified system privilege or user-defined role. When used for privilege checking within user-defined stored procedures, SP_HAS_ROLE returns an error message when a user fails a privilege check.
• sp_iqaddlogin Procedure
  Adds a new SAP Sybase IQ user account to the specified login policy.
• sp_iqbackupdetails Procedure
  Shows all the dbfiles included in a particular backup.
• sp_iqbackupsummary Procedure
  Summarizes backup operations performed.
• sp_iqconnection Procedure
  Shows information about connections and versions, including which users are using temporary dbspace, which users are keeping versions alive, what the connections are doing inside SAP Sybase IQ, connection status, database version status, and so on.
• sp_iqcopyloginpolicy Procedure
  Creates a new login policy by copying an existing one.
• sp_iqdbspace Procedure
  Displays detailed information about each SAP Sybase IQ dbspace.
• sp_iqdbspaceinfo Procedure
  Displays the size of each object and subobject used in the specified table. Not supported for RLV dbspaces.
• sp_iqdbspaceobjectinfo Procedure
  Lists objects and subobjects of type table (including columns, indexes, metadata, primary keys, unique constraints, foreign keys, and partitions) for a given dbspace. Not supported for RLV dbspaces.
• sp_iqdroplogin Procedure
  Drops an SAP Sybase IQ user account.
• sp_iqemptyfile Procedure
  Empties a dbfile and moves the objects in the dbfile to another available read-write dbfile in the same dbspace. Not available for files in an RLV dbspace.
• sp_iqestdbspaces Procedure
  Estimates the number and size of dbspaces needed for a given total index size.
• sp_iqfile Procedure
  Displays detailed information about each dbfile in a dbspace.
• sp_iqmodifyadmin Procedure
  Sets an option on a named login policy to a certain value. If no login policy is specified, the option is set on the root policy. In a multiplex, sp_iqmodifyadmin takes an optional parameter that is the multiplex server name.
• sp_iqmodifylogin Procedure
  Assigns a user to a login policy.
• sp_iqobjectinfo Procedure
  Returns partitions and dbspace assignments of database objects and subobjects.
• sp_iqspaceused Procedure
  Shows information about space available and space used in the IQ store, IQ temporary store, RLV store, and IQ global and local shared temporary stores.
• sp_iqsysmon Procedure
  Monitors multiple components of SAP Sybase IQ, including the management of buffer cache, memory, threads, locks, I/O functions, and CPU utilization.
• sp_iqpassword Procedure
  Changes a user’s password.
• sp_objectpermission System Procedure
  Generates a report on object privileges granted to the specified role, or user name, or the object privileges granted on the specified object or dbspace.
• sp_sys_priv_role_info System Procedure
  Generates a report to map a system privilege to the corresponding system role. A single row is returned for each system privilege.
• sp_alter_secure_feature_key System Procedure
  Alters a previously-defined secure feature key by modifying the authorization key and/or the feature list.
• sp_drop_secure_feature_key System Procedure
  Deletes a secure feature key.
• sp_list_secure_feature_keys System Procedure
  Returns information about the contents of a directory.
• sp_use_secure_feature_key System Procedure
  Enables an existing secure feature key.