Limiting Number of Rows Fetched

  1. Save query with the SAVE QUERY AS command
  2. Execute query with rowlimit

RUN query_name(ROWLIMIT=nn

Example: RUN QCO88001(ROWLIMIT=50