Increase the row limit for DBSQLPR utility

Products

• Datacom/AD
• Datacom
• DATACOM - AD
• Datacom/DB

Issue/Introduction

Executing SQL SELECT in a DBSQLPR job is returning just 1000 rows.

How to remove the limit to get all the rows returned?

 

Environment

Release : 15.1

Cause

The default row limit for DBSQLPR is 1000 rows. 

Resolution

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' 

Additional Information

See documentation section DBSQLPR Utility--Execute SQL through Datacom/DB