How to identify the dictionaries Visual/DBA can work with

Document ID : KB000123228
Last Modified Date : 20/12/2018
Show Technical Document Details
Introduction:
This document describes how to specify the dictionaries in a given CV that Visual/DBA can work with.
Background:
Visual/DBA has to be told the names of a dictionary in an IDMS CV that it "knows" about.
Environment:
CA Visual/DBA r18 for IDMS
Instructions:
During the installation, the statements in vdb5v18x.sql is used as input to an IDMSBCF batch job against all of the dictionaries that should be managed by Visual/DBA.
One of the entities it creates is a table procedure called SYSCA.VDBA_DICTIONARY5.
The purpose of this table procedure is that each column name in it represents a dictionary that Visual/DBA can manage.
By default it is set to this:
CREATE TABLE PROCEDURE SYSCA.VDBA_DICTIONARY5       
  ( SYSTEM                           CHARACTER(1),  
    APPLDICT                         CHARACTER(1),  
    SYSDICT                          CHARACTER(1)   
  )                                                 
    EXTERNAL NAME VDBADICT                          
    DEFAULT DATABASE NULL                           
    USER MODE                                       
    LOCAL WORK AREA 1024                            
    ;
If you want your Visual/DBA installation to manage a different collection of dictionaries, then change this definition before running the script.
For example, if you only want Visual/DBA to know about SYSTEM and APPLDICT, then change it to this:
CREATE TABLE PROCEDURE SYSCA.VDBA_DICTIONARY5     
  ( SYSTEM                           CHARACTER(1),
    APPLDICT                         CHARACTER(1) 
  )                                               
    EXTERNAL NAME VDBADICT                        
    DEFAULT DATABASE NULL                         
    USER MODE                                     
    LOCAL WORK AREA 1024                          
    ;
Ideally this should be done before running the script.
If you have already run it, then manually change the table procedure in every dictionary in which you have created it by performing a DROP and (re-)CREATE of the table procedure.
For example:
DROP TABLE PROCEDURE SYSCA.VDBA_DICTIONARY5;      
CREATE TABLE PROCEDURE SYSCA.VDBA_DICTIONARY5     
  ( SYSTEM                           CHARACTER(1),
    APPLDICT                         CHARACTER(1) 
  )                                               
    EXTERNAL NAME VDBADICT                        
    DEFAULT DATABASE NULL                         
    USER MODE                                     
    LOCAL WORK AREA 1024                          
    ;


 
Additional Information:
Install the CA IDMS Visual DBA Version 18 SQL Definitions
CREATE TABLE PROCEDURE
DROP TABLE PROCEDURE