DBSQLPR

DBSQLPR is a utility that enables users to execute SQL statements through CA Datacom/DB. It Provides a superset of the functionality previously provided by the SQIDEMO and COB430 utilities without any dependence upon the SQI interface or any requirement to preprocess and compile an SQL program. DBSQLPR is for users who want quick access to SQL functionality but do not have access to CICS or the CA Datacom Server.

DBSQLPR outputs message DB00248I to the JESMSGLG each time it runs. The message displays the date/time when the running DBSQLPR was compiled, the CA Datacom release it is part of, and the latest PTF applied (if any). For details, see the CA Datacom/DB Message Reference Guide.

Consider the following:

If you have existing SQIDEMO and COB430 JCL, it runs with little or no changes.
SQL statements must be terminated with a semicolon (;) unless the TERM= parameter is used (see DBSQLPR Options).
SQL statements may not contain host variable references.
All nullable columns are printed with one extra character to the left. This character is blank when a value is present and an asterisk (*) when the data is NULL.
The CA Common Services for z/OS CAILIB is required in STEPLIB (for z/OS) or LIIBDEF (for z/VSE).
When using DBSQLPR, specify PLNCLOSE=T or allow PLNCLOSE to default to that value.