Executes a SQL statement in the current database at the primary data server.
The Replication Agent instance executes the specified SQL statement against the “current” database.
To set or change the current database, use the pdb_set_sql_database command.
To find the name of the current database, use the pdb_get_sql_database command.
pdb_execute_sql "select * from Authors"
The string is passed directly to the database for execution. No command to terminate is required and no syntax or other validation is performed.
Any results returned from execution of the SQL statement are passed to the Replication Agent administrative client, by way of the Replication Agent administration port.
The pdb_execute_sql command is valid when the Replication Agent instance is in the Admin, Replicating, or Replication Down state.