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