Features and functions of the BMC AMI Utilities SQL language

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

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

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