Fonctions, opérations et jetons SQL sécurisés
Afin de s'assurer de la sécurité de l'environnement, toutes les instructions SQL créées et qui ciblent une source Infor Cloud sont analysées par rapport à une liste de constructions SQL sécurisée. La syntaxe des requêtes SQL doit répondre aux normes SQL ANSI 92. La liste est appliquée uniquement lorsque les sources Infor Cloud peuvent être affectées.
Les fonctions, opérations et jetons SQL suivants sont autorisés :
| 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 |