CA Workload Automation CA 7 SQL Parm to remove page break

book

Article ID: 208676

calendar_today

Updated On:

Products

CA Workload Automation CA 7 Edition

Issue/Introduction

How to remove page break data in the report when using DBSQLPR to run SQL reports for CA 7?

Environment

Release : 12.1

Component : CA-7

Resolution

Add the  PARM='NOECHO,NOPAGES,NOCOLHDR,NOTYPE'  to produce data only report.

//SQL   EXEC  PGM=DBSQLPR,PARM='NOECHO,NOPAGES,NOCOLHDR,NOTYPE'