MaxRowsCompared

MaxRowsCompared can prevent runaway queries in non-relational databases.  

 

MAXROWSCOMPARED = (ANY VALUE)

 

CONNX initially searches the number of records specified in MaxRowsCompared. If there is a match (at least one record returned), the entire database is searched. If there no match (no records returned), the search stops and an error is returned.

 

Default = 0.

 

Environments: Client, Server, Windows, Unix, Mainframe

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  MAXROWSCOMPARED

 

Unix Environment Variable: MAXROWSCOMPARED

Started Task: MAXROWSCOMPARED

CICS:  MAXROWSCOMPARED