BMC AMI Utilities SQL language elements

The basic elements of the  BMC AMI Utilities SQL language are expressions and predicates. When an expression is evaluated, it normally returns a value of a known data type defined in the language. You can use expressions to form predicates or to manipulate data elements. When a predicate is evaluated, it normally results in a true or false condition. You can use predicates to define search conditions.

An expression in its basic form can be one of the following items:

• Function
• Case expression
• Constant
• Column name
• Special register
• Labeled duration

An expression can also include other expressions. The following diagrams show BMC AMI Utilities  SQL language element syntax:

BMC AMI Utilities SQL syntax for expressions

 

BMC AMI Utilities SQL syntax for expressions (labeled-duration syntax)

BMC AMI Utilities SQL syntax for expressions (CASE statement)

 

Searched WHEN clause

  

Simple WHEN clause

 

 BMC AMI Utilities SQL syntax for predicates