SQL Statements

Many SQL statements include special syntax to support multiplex functionality.

• ALTER AGENT Statement
  Modifies connection information for the SAP Sybase IQ agent.
• ALTER LOGICAL SERVER Statement
  Modifies configuration for the existing user-defined logical server in the database. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• 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. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• 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.
• COMMENT Statement
  Stores a comment, in the system tables, about a database object.
• CREATE AGENT Statement
  Associates an SAP Sybase IQ agent for SAP Control Center with the named server to support high availability.
• CREATE LOGICAL SERVER Statement
  Creates a user-defined logical server. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• CREATE LOGIN POLICY Statement
  Creates a login policy in the database.
• CREATE LS POLICY Statement
  Creates a user-defined logical server policy. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• CREATE MULTIPLEX SERVER Statement
  Creates a multiplex server.
• DROP AGENT Statement
  Deletes an SAP Sybase IQ agent for SAP Control Center.
• DROP LOGICAL SERVER Statement
  Drops a user-defined logical server. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• DROP MULTIPLEX SERVER Statement
  Deletes a server from the multiplex.