Miscellaneous SQL enhancements in Version 15.0 are as follows:
UNSIGNED was added to the syntax for column specifications in ALTER TABLE (when adding a column) and in the CREATE TABLE column definition. See the CA Datacom/DB SQL User Guide.
New string function POSSTR was added. See the information on Character Functions in the CA Datacom/DB SQL User Guide.
DBSQLPR has long needed to output compile information and information about the last PTF applied to the module. In Version 15.0, message DB00248I is used to supply that information. Message DB00248I previously generated output to JESMSGLG in the MUF job for DBSRPPR but now also generates output to the DBSQLPR job in JESMSGLG.
Note: For the DBSQLPER job, there is no output to SYSPRINT, only to JESMSGLG.
For more information, see the information about message DB00248I in the CA Datacom/DB Message Reference Guide.
The DIAGOPTION 1,64,ON was replaced with MUF startup option SQL_ALLOW_TIME_240000 YES/NO. For more information, see the CA Datacom/DB Database and System Administration Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|