Zabbix Documentation 3.4

2.23.04.04.2 (current)In development:4.4 (devel)Unsupported:1.82.02.43.23.4

User Tools

Site Tools


manual:config:items:itemtypes:odbc_checks

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
manual:config:items:itemtypes:odbc_checks [2017/10/06 09:12]
martins-v Zabbix does not limit the query execution time
manual:config:items:itemtypes:odbc_checks [2018/11/01 06:05] (current)
martins-v sql needn't start with 'select'
Line 116: Line 116:
   * If a query returns more than one column, only the first column is read.   * If a query returns more than one column, only the first column is read.
   * If a query returns more than one line, only the first line is read.    * If a query returns more than one line, only the first line is read. 
-  * The SQL command must begin with ''​select''​. +  * The SQL command must return a result set like any query with ''​select ​...''​. The query syntax will depend on the RDBMS which will process them. The syntax of request to a storage procedure must be started with ''​call''​ keyword.
-  * The SQL command mustn't contain any line breaks.+
   * See also [[:​manual/​installation/​known_issues#​odbc_checks|known issues]] for ODBC checks   * See also [[:​manual/​installation/​known_issues#​odbc_checks|known issues]] for ODBC checks