JCL for SQL database 020 definition in CABDSAMP library

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

Just added the SQL Option to an existing Datacom test environment. Is there a sample JCL in the CABDSAMP library to create Database 20?

Environment

Datacom/DB with SQL Option

Resolution

As you can read on APAR SI12634 (INFO: CA DATACOM DATABASE ID REGISTRY), currently there is no sample database with DBID 20:

CA Datacom                   Reserved for CA                      19-20

You probably mean the CICS URT 20 used by SQL Option, which is actually a "dummy" URT, i.e. without any table definition (so no need for a database with DBID 20)

The source for this URT can be found on DBSOTPR member of CABDSAMP.