Using Before/After SQL Statements

Use this property to determine whether you can access the sub-properties to define SQL statements that are run before or after data processing occurs.

If you set Before/After SQL to Yes, the sub-properties are available for you to use. If you set Before/After SQL to No, the sub-properties are not available to you. The default value is No.

Supporting Connectors

The following SCAPI connectors support SQL statements.

  • Db2
  • Db2 Hosted
  • Db2 on Cloud
  • Db2 for i
  • Db2 for Z/OS
  • Db2 Big SQL
  • Db2 Warehouse
  • Microsoft SQL Server
  • Oracle
  • Sybase
  • Informix
  • Microsoft Azure SQL Database
  • Amazon Redshift
  • Google Big Query
  • Snowflake
  • Teradata
  • Apache Hive
  • Netezza Performance Server
  • MySQL
  • Compose for MySQL
  • Amazon RDS for MySQL
  • Amazon RDS for PostgreSQL
  • Databases for PostgreSQL
  • PostgreSQL
  • Maria DB
  • Amazon RDS for Oracle
  • Greenplum