Parameter
dbs/db4/max_hostvars
Short text
Maximum number of host variables
Parameter Description
Specifies the maximum number of host variables for each SQL statement.
Application Area
Database
Default Value
2000
Who is permitted to make changes?
DB administrator
Database System Restrictions
This parameter is only evaluated for DB2 for IBM i.
Are other parameters affected or dependent?
Enter a value below the relevant database limit, so that the SAP system can use the value to calculate valid SQL statements (for example, for FOR ALL ENTRIES statements).
When changing dbs/db4/max_hostvars, keep in mind the maximum permitted length of SQL statements.
Values allowed
Integer value
