CA Datacom SQL ALTER DATABASE -20 or -118

book

Article ID: 129939

calendar_today

Updated On:

Products

CA Datacom CA DATACOM - AD CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

Using SQL statement ALTER DATABASE database-name and getting errors, SQLCODEs -20 and -116. Using the ENTITY-NAME which has hyphen(-) character.

ALTER DATABASE DBA-SQLDB DATACOM 
DYNAMIC_EXTEND NO 
; 

___________SQL ERROR SUMMARY START___________ 

SQLCODE = -20, SQLSTATE=42601 
MESSAGE = BAD SYNTAX: <ALTER DATABASE DBA-S> 
WHEN THE ERROR OCCURRED, THE SYNTAX BELOW HAD BEEN PARSED: 
ALTER DATABASE DBA-S 
____________SQL ERROR SUMMARY END____________ 


ALTER DATABASE "SYSUSR.DBA-SQLDB" DATACOM 
DYNAMIC_EXTEND NO 
; 

___________SQL ERROR SUMMARY START___________ 

SQLCODE = -118, SQLSTATE=RNNTF 
MESSAGE = DATABASE SYSUSR.DBA-SQLDB NOT FOUND 
____________SQL ERROR SUMMARY END____________ 

Cause

To perform any SQL processing on the DATABASE, ALTER DATABASE or CREATE AREA, it needs to have a SQLNAME defined. The entity ENTITY-NAME cannot be used.  A Datacom SQLNAME cannot have a hyphen(-) character. The valid character set includes A-Z, 0-9, $, #, @, and _ (underscore).

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

Resolution

Run DDUPDATE to add the SQLNAME to the DATABASE entity. You can make the change directly to the PROD status entity and no catalog of the database is required.
Sample DDPUPDATE input to make the change:

-UPD DATABASE,DBA-SQLDB(PROD) 
2901 N DBA_SQLDB
-END

 

Additional Information

See DocOps section 2900 to 2901 DATABASE Transactions