BMC AMI Utilities SQL language

BMC AMI Utilities provide a SQL-like language known as the BMC AMI Utilities SQL language. This language provides constructs and built-in functions similar to the Db2 SQL language.

BMC AMI Utilities use the BMC AMI Utilities SQL language in the following contexts:

  • WHERE clause
  • UNLOAD SELECT WHERE
  • REORG DISCARD WHERE
  • LOAD WHERE
  • BMC AMI Utility Manager criteria _WHERE columns
  • SELECT list
  • Index on expression (IOE)
  • Check constraints
  • BMC AMI Utility Manager
  • ORDER by
  • VALUE clause in BMC AMI Load

Related topic

Building-BMC-AMI-Utilities-jobs 

The following topics describe BMC AMI Utilities SQL language:

 

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