hi all, I hope this is the correct place and forum for this.
We are a long-time Datacom shop (although I am not so experienced myself), and we just recently looked at using SQL for our new Test DB creation and update.
I set up a minimal DB using DBSQLPR with this :
CREATE DATABASE STUWD997_INFORMATION DATACOM
DATACOM_ID 997;
COMMIT WORK;
This gave me an RC=0 so I assumed this is now on the Dictionary. a -RPT showed it there as version 0001.
I then tried to run a DDCFBLD to move it into the CXX (per KB TEC1047513) but this fails:
*-------------------------------------------------------------------------------
* CODE FUNCTION,ENTITY-TYPE,OCCURRENCE(VERS,PSWD,OVRD)
* -CXX CATALOG,DATABASE,STUWD997_INFORMATION(0001) ; MS
* TRANSACTION ERROR: DDFCFM0033 INVALID ENTITY-NAME
*-------------------------------------------------------------------------------
One thing I noticed in the inherited JCL was that I had an AUTHID set in the creation, but used a different user (DATACOM-INSTALL) in the DDCFBLD.
Could that discrepancy have caused this ? Otherwise I am a little confused as to why my newly created DB cannot be seen.
Thanks in advance for any advice.
Tony Simper