To define the number of rows that are read by the database table in a single query scan, set a specific value in the following:

 

MAXROWSFETCHED = (ANY VALUE)

 

Default = 0.

 

See MAXROWSFETCHEDFAIL to determine whether MAXROWSFETCHED queriers should terminate normally or generate an error message.

 

Environments: Server, Windows, Unix, Mainframe

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

 

Unix Environment Variable: MAXROWSFETCHED

Started Task: MAXROWSFETCHED

CICS:  MAXROWSFETCHED