Skip to Content
Information
Important We are integrating BMC AMI LOBMaster technology into the BMC AMI Reorg product and discontinuing BMC AMI LOBMaster as a separate product. For the latest integrated documentation, see BMC AMI Reorg for Db2 13.1.

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

Related topics

BMC-AMI-Utilities-SQL-language

Building-BMC-AMI-Utilities-jobs

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

NGT_SQL_syntax_expressions.png


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

NGT_SQL_syntax_expressions_labeled_duration.png

BMC AMI Utilities SQL syntax for expressions (CASE statement)

NGT_SQL_syntax_expressions_CASE.png 

Searched WHEN clause

Searched_WHEN_clause.png  

Simple WHEN clause

Simple_WHEN_clause.png 

 BMC AMI Utilities SQL syntax for predicates

NGT_SQL_syntax_predicates.png



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Reorg for Db2 13.1