Executing SQL SELECT in a DBSQLPR job is returning just 1000 rows.
How to remove the limit to get all the rows returned?
Release : 15.1
The default row limit for DBSQLPR is 1000 rows.
The number of rows returned by DBSQLPR can be increased by specifying the ROWLIMIT parameter either in the PARM statement of the EXEC card or in the OPTIONS DD statement.
For example, to return 50,000 rows change the PARM statement like this:
//SQL EXEC PGM=DBSQLPR,REGION=2M,
// PARM='PRTWIDTH=255,INPUTWIDTH=70,ROWLIMIT=50000'
See documentation section DBSQLPR Utility--Execute SQL through Datacom/DB