About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Last updated: Feb 11, 2025
The tables in this section list the mathematical operations and expressions that support SQL generation and are often used during data mining. Operations absent from these tables don't support SQL generation.
Operations supporting SQL generation | Notes |
---|---|
|
|
|
|
|
|
|
|
|
Used to concatenate strings. |
Operations supporting SQL generation | Notes |
---|---|
|
|
|
Used to specify "not equal." |
|
|
|
|
|
|
|
Operations supporting SQL generation | Notes |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operations supporting SQL generation | Notes |
---|---|
|
|
|
You can use the special global functions to retrieve global values computed by the Set Globals node. |
|
|
|
|
|
|
|
|
|
Operations supporting SQL generation | Notes |
---|---|
|
|
|
|
|
|
|
|
|
|
|
Was the topic helpful?
0/1000