Accessing AutoCollect Data Using DBSQLPR › DBSQLPR Delimiter Separated Values Output

DBSQLPR Delimiter Separated Values Output

The DBSQLPR utility is described in the CA Datacom/DB SQL User Guide. It provides a simple way to dynamically execute most SQL statements in batch.

DBSQLPR accepts control parameters (sets execution variables) and SQL statements from SYSIN.

Each SQL statement is compiled and, if the compile is successful, the statement is executed. For SELECT statements, DBSQLPR generates a simple report file with the requested column headers and data.

In addition to the simple report feature, DBSQLPR allows you to change the output choice to a DSV output dataset instead of the generated report output for a given execution of DBSQLPR.