To determine whether a MAXROWSFETCHED query will either terminate normally or will generate an error depening on how the query terminates, set MAXROWSFETCHEDFAIL:

 

MAXROWSFETCHEDFAIL = 0

 

If MAXROWSFETCHEDFAIL = 0, once the database has read the number of rows specified by MAXROWSFETCHED the query will terminate normally.

 

If MAXROWSFETCHEDFAIL =1, once the database has read the number of rows specified by MAXROWSFETCHED, the query will generate an error message.

 

Default = 1.

 

Environments: Server, Windows, Unix, Mainframe

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

 

Unix Environment Variable: MAXROWSFETCHEDFAIL

Started Task: MAXROWSFETCHEDFAIL

CICS:  MAXROWSFETCHEDfIL