search cancel

Increase the row limit for DBSQLPR utility

book

Article ID: 257855

calendar_today

Updated On:

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