Adding run-time processing statements to the SQL statement box

Use the Add SQL window to add run-time SQL processing statements to the SQL window.

Fields and controls



To add run-time processing statements to the SQL statements list:

  1. Open the Add SQL window.

  2. Type the processing statement or stored procedure name in the SQL statement field. The keyword CALL must precede a stored procedure name.

  3. Optional: Type an acceptable 5-byte SQLSTATE value in the SQLSTATE field and click on Add. The value is added to the Acceptable SQLSTATE values list box. You can enter up to 10 values. The replication program interprets these values as successful execution. You can remove an acceptable SQLSTATE value by clicking on one or more values and then clicking on the Remove push button.

  4. Specify when you want to submit the statement, and on which server (target or source), by clicking on the appropriate radio button in the Submit SQL statement field.

  5. Click on OK. The statement is added to the box in the SQL window, and the Add SQL window closes.


Related information