SQL Statements

Many SQL statements include special syntax to support multiplex functionality.

• ALTER LOGICAL SERVER Statement
  Modifies configuration for the existing user-defined logical server in the database.
• ALTER LOGIN POLICY Statement
  Changes existing login policies or configures logical server access.
• ALTER LS POLICY Statement
  Modifies some or all option values for the root logical server policy or a user-created logical server policy.
• ALTER MULTIPLEX RENAME Statement
  Renames the multiplex and stores the multiplex name in SYS.ISYSIQINFO system table.
• ALTER MULTIPLEX SERVER Statement
  Changes the name, catalog file path, role, or status of the given server.
• BACKUP Statement
  Backs up an SAP Sybase IQ database on one or more archive devices.
• COMMENT ON LOGICAL SERVER Statement
  Comments on the user-defined logical server.
• CREATE LOGICAL SERVER Statement
  Creates a user-defined logical server.
• CREATE LOGIN POLICY Statement
  Creates a login policy in the database.
• CREATE LS POLICY Statement
  Creates a user-defined logical server policy.
• CREATE MULTIPLEX SERVER Statement
  Creates a multiplex server.
• DROP LOGICAL SERVER Statement
  Drops a user-defined logical server.
• DROP MULTIPLEX SERVER Statement
  Deletes a server from the multiplex.
• RESTORE DATABASE Statement
  Restores an SAP Sybase IQ database backup from one or more archive devices.