Supported operators in SQL
Database native SQL does not provide equivalent functionality for all the operators that you can use in job designs.
The following table lists operators that can be used in a Transformer stage and states whether they can be reproduced in SQL.
If you use any of these unsupported operators in any expression in a Transformer stage, then the processing contained in that Transformer stage cannot be pushed into target or source SQL. If you want to use these items in your job, segregate them into a separate Transformer stage which will not be pushed into a database source or target.
Operator | Supported in Teradata SQL | Supported in IBM® DB2® SQL | Supported in Netezza | Supported in Oracle | Comment |
---|---|---|---|---|---|
-A | Yes | Yes | Yes | Yes | |
A - B | Yes | Yes | Yes | Yes | |
A ! B | Yes | Yes | Yes | Yes | |
A # B | Yes | Yes | Yes | Yes | |
A #< B | Yes | Yes | Yes | Yes | |
A #> B | Yes | Yes | Yes | Yes | |
A & B | Yes | Yes | Yes | Yes | |
A * B | Yes | Yes | Yes | Yes | |
A / B | Yes | Yes | Yes | Yes | |
A : B | Yes | Yes | Yes | Yes | |
A ^ B | Yes | Yes | Yes | Yes | |
A + B | Yes | Yes | Yes | Yes | |
A < B | Yes | Yes | Yes | Yes | |
A <= B | Yes | Yes | Yes | Yes | |
A <> B | Yes | Yes | Yes | Yes | |
A = B | Yes | Yes | Yes | Yes | |
A =< B | Yes | Yes | Yes | Yes | |
A => B | Yes | Yes | Yes | Yes | |
A > B | Yes | Yes | Yes | Yes | |
A >< B | Yes | Yes | Yes | Yes | |
A >= B | Yes | Yes | Yes | Yes | |
A and B | Yes | Yes | Yes | Yes | |
A eq B | Yes | Yes | Yes | Yes | |
A ge B | Yes | Yes | Yes | Yes | |
A gt B | Yes | Yes | Yes | Yes | |
A le B | Yes | Yes | Yes | Yes | |
A lt B | Yes | Yes | Yes | Yes | |
A ne B | Yes | Yes | Yes | Yes | |
A or B | Yes | Yes | Yes | Yes | |
A**B | Yes | Yes | Yes | Yes | |
IF A THEN B ELSE C | Yes | Yes | Yes | Yes | |
not A | Yes | Yes | Yes | Yes | |
not(A) | Yes | Yes | Yes | Yes | |
S[A] | Yes | Yes | Yes | Yes | |
S[A,B] | Yes | Yes | Yes | Yes | |
S[A,B,C] | No | No | No | No | no SQL equivalent for Nth substring |