Whitelist of SQL functions, operations, and tokens
To help ensure the security of the environment, any SQL statements that
you create, and which target an Infor cloud source, are parsed against a whitelist of safe SQL
constructs. SQL query syntax must meet SQL ANSI 92 standards. The whitelist is applied only
where Infor cloud sources might be affected.
These SQL functions, operations, and tokens are allowed:
| Functions and operations | Tokens |
|---|---|
| abs | All |
| acos | Ampersand |
| ascii | And |
| asin | Any |
| atan | As |
| atan2 | Asc |
| avg | AsciiStringLiteral |
| cast | AsciiStringOrQuotedIdentifier |
| ceiling | Between |
| char | By |
| charindex | Case |
| concat | Circumflex |
| cos | Coalesce |
| cot | Colon |
| count | Comma |
| cume_dist | Cross |
| current_timestamp | Delete |
| datefomparts | Desc |
| datepart | Distinct |
| datetime2fromparts | Divide |
| datetimefromparts | Dot |
| datetimeoffsetfromparts | Double |
| degrees | DoubleColon |
| dense_rank | Else |
| exp | End |
| first_value | EqualsSign |
| floor | Except |
| format | Exists |
| getdate | Fetch |
| grouping | From |
| grouping_id | Full |
| lag | GreaterThan |
| last_value | Group |
| lead | Having |
| left | HexLiteral |
| len | Identifier |
| log | In |
| log10 | Inner |
| lower | Insert |
| ltrim | Integer |
| max | Intersect |
| min | Into |
| ntile | Is |
| percent_rank | Join |
| percentile_cont | Left |
| percentile_disc | LeftCurly |
| pi | LeftParenthesis |
| power | LessThan |
| radians | Like |
| rand | Merge |
| rank | Minus |
| replace | MultilineComment |
| replicate | Not |
| reverse | Null |
| right | Nullif |
| round | Numeric |
| row_number | On |
| rtrim | Or |
| sign | Order |
| sin | Outer |
| sqrt | Over |
| stdev | Percent |
| stdevp | PercentSign |
| substring | Plus |
| sum | QuoteIdentifier |
| sysdatetime | Real |
| sysdatetimeoffset | Right |
| tan | RightCurly |
| timefromparts | RightOuterJoin |
| trim | RightParenthesis |
| upper | Select |
| var | Semicolon |
| varp | Set |
| SingleLineComment | |
| Some | |
| Star | |
| Then | |
| Tilde | |
| UnicodeStringLiteral | |
| Union | |
| Update | |
| Values | |
| Variable | |
| VerticalLine | |
| When | |
| Where | |
| WhiteSpace |