CA Workload Automation CA 7 SQL Parm to remove page break
Article ID: 208676
Updated On:
Products
CA 7 Workload Automation
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'
Feedback
Yes
No
Powered by
