Reject links in DataStage

When a DataStage connector or stage includes one or more reject links, records that meet specified reject criteria are automatically routed to the target stage on the reject links. Processing continues for the remaining records.

Single reject link supported connectors

DataStage® supports single reject links for the following connectors:
  • Amazon Redshift
  • Amazon RDS for MySQL
  • Amazon RDS for Oracle
  • Amazon RDS for PostgreSQL
  • Apache Cassandra
  • Apache Derby
  • DataStax Enterprise
  • Db2®
  • Db2 Big SQL
  • Db2 for i
  • Db2 for z/OS®
  • Db2 on Cloud
  • Db2 Warehouse
  • Greenplum
  • IBM Cloud Databases for MySQL
  • IBM Cloud® Databases for PostgreSQL
  • IBM® Data Virtualization Manager for z/OS
  • IBM Db2 for DataStage
  • IBM MQ
  • Informix®
  • Generic JDBC
  • MariaDB
  • Microsoft Azure SQL Database
  • Microsoft SQL Server
  • MySQL
  • Netezza® (PureData® System for Analytics)
  • ODBC
  • Oracle
  • Oracle Database for DataStage
  • PostgreSQL
  • Salesforce API for DataStage
  • SAP ASE
  • SAP HANA
  • SingleStoreDB
  • Sequential file, when used as a target
  • Sequential file, when used as a source and when the node has more than one output link
  • Snowflake
  • Teradata
  • Teradata database for DataStage

Multiple reject link supported connectors

DataStage supports multiple reject links for the following connectors:
  • IBM Db2 for DataStage
  • Generic JDBC
  • IBM MQ
  • ODBC
  • Oracle Database for DataStage
  • Salesforce API for DataStage
  • Teradata database for DataStage

Single reject link supported stages

DataStage supports single reject links for the following stages:
  • Column Export
  • Column Import
  • External Source, when the node has more than one output link
  • External Target
  • Filter
  • Java Integration
  • Lookup
  • Merge, when the node has more than one output link
  • Operational Decision Manager
  • Switch

Multiple reject link supported stages

DataStage supports multiple reject links for the following stages:
  • Operational Decision Manager

Specifying reject links while connector is a source

Google Cloud Storage
The reject link should contain two columns:
  1. A mandatory column that holds the rejected record.
  2. An optional column that holds a message about why the record was rejected. You can remove the optional column.

In the Output tab, you can click Usage and select Yes for Is reject link to automatically add or remove the columns.