After applying CA Datacom SQL Version 14.0 PTF RO87076, why is the format of the output (STDOUT) for some requests different?
For example, using these options and request:
//OPTIONS DD *
//SYSIN DD DATA,DLM=$$
FROM SYSADM.DIR_AREA WHERE DBID = 002 ;
Prior to PTF RO87076, the result was:
With PTF RO87076, the result is:
The result with PTF RO87076 is correct and as intended. PTF RO87076 also corrected this problem:
When the DBSQLPR options "NOCOLHDR" and "NOTYPE" are specified along with "DATASEPARATOR," and a column name is longer than the length of the data, the data will be output using the space for the column name rather than the shorter length of the data itself.
For more information on CA Datacom/DB SQL batch utility DBSQLPR that enables users to execute SQL statements through CA Datacom/DB, refer to the CA Datacom/DB SQL User Guide at