The error "...invalid relational operator" occurs when you configure a WHERE clause in an SQL Join transformation of SAS® Data Integration Studio


When you build a join condition in the SQL Join transformation, the name of one of the operators available for selection for filtering of the data is incorrect. This operator is NOT IS NULL. If you use the NOT IS NULL operator in your WHERE clause syntax and you have enabled explicit PassThrough in the SQL Join transformation, you might receive a database-specific error in your SAS Data Integration Studio job. For example, the following error is generated for these circumstances when your source tables are Oracle tables:

ERROR: ORACLE prepare error: ORA-00920: invalid relational operator.

IS NOT NULL is the correct syntax for this operator. You do not receive the error when using the NOT IS NULL operator if your source tables are SAS tables or your database tables are processed with implicit PassThrough.