Features and functions of the BMC AMI Utilities SQL language
Feature or function | Supported by BMC AMI Utilities SQL | |
---|---|---|
WHERE clause elements | ||
Column-to-column compares | Yes | |
Constant-to-constant compares | No | |
Constant-to-column compares | Yes | |
Host variables | No | |
WHERE clause keywords | ||
BETWEEN, IN, LIKE keywords | Yes | |
NOT BETWEEN, NOT IN, NOT LIKE keywords | Yes | |
IS NULL, IS NOT NULL keywords | Yes | |
CONCAT keyword | Yes | |
Data manipulation | ||
Concatenation | Yes | |
CONSTANT data formats | ||
CHAR (character string), HEX (hexadecimal string), GRAPHIC (graphic string) | Yes | |
INTEGER, DECIMAL, FLOAT (floating point), DECFLOAT (decimal floating point) | Yes | |
Mixed data | Yes | |
Date formats: EUR/ISO/JIS/USA | Yes | |
Time formats: EUR/ISO/JIS/USA | Yes | |
Date/Time elements | ||
Date/time durations | Yes | |
Day of week | Yes | |
Day of month | Yes | |
Day of year | Yes | |
Timestamp duration | Yes | |
Labeled durations | Yes | |
Week | Yes | |
Arithmetic | ||
Date/time arithmetic | Yes | |
Decimal arithmetic | Yes | |
Float/decimal float arithmetic | Yes | |
Integer arithmetic | Yes | |
Functions | ||
AVG(), MIN(), MAX(), SUM(), COUNT() | No | |
VARGRAPHIC() | No | |
See Functions that the BMC AMI Utilities SQL language supports | ||
Operators | ||
AND, OR | Yes | |
NOT | No | |
+, -, *, / | Yes | |
Remainder divide (//) | Yes | |
Concatenation (||) | Yes | |
Special registers | ||
CURRENT DATE | Yes | |
CURRENT TIME | Yes | |
CURRENT TIMESTAMP WITHOUT TIMEZONE | Yes | |
CURRENT TIMEZONE, CURRENT TIMESTAMP WITH TIMEZONE | Yes | |
Other clauses | ||
GROUP BY, HAVING | No | |
JOINS, UNIONS | No | |
Correlated subquery | No | |
Non-correlated subquery | Yes | |
Miscellaneous | ||
Aliases | Yes | |
Data conversion for numeric comparisons | Yes | |
Decimal point as comma | Yes | |
Expressions | Yes | |
Parenthesized expressions | Yes | |
Delimited column names | Yes | |
Qualified column names | No | |
Synonyms | Yes | |
Views | Yes | |
Number of predicates supported | 700 | |
External file support for IN predicate | Yes | |
Subselect in an IN predicate | Yes | |
FIELDPROC in a WHERE clause | No |
Comments
Log in or register to comment.