Using AfterSQL statements

You can configure the Sybase OC stage to run SQL statements after the stage processes all job data rows.

1. Enter the SQL statements you want to be executed after the data is processed in the text entry area on the After tab.

   If the property value begins with {FILE}, the remaining text is interpreted as a pathname and the content of the file supplies the property value.

   Execution occurs immediately before the connection between the Sybase client and server is terminated. If you specify multiple SQL statements, they are executed as one or more Transact-SQL command batches by using a semicolon ( ; ) as the end-of-batch signal.

2. Select the Treat errors as non-fatal check box to log AfterSQL execution errors as warnings. Processing continues with the next command batch, if any. Each successful execution is committed as a separate transaction.

   If this check box is cleared, AfterSQL execution errors are considered fatal to the job and result in a transaction rollback. The transaction is committed only if all AfterSQL statements successfully execute.