Creating Dataviews for CA Datacom/DB Native Command Access › Rules for CA Datacom/DB Native Command Access › Setting a DBID

Setting a DBID

When the DATABASE is created, it is defined with a DBID. This DBID is cataloged in the dataview and passed to the database at execution time. If the DBID changes or a table with a matching definition exists in another database, then non‑SQL programs can be repointed to the new DBID. The CA Ideal commands ALTER PROGRAM, ASSIGN DATAVIEW, and ASSIGN DBID modify the program object, eliminating the need to recatalog the dataview or recompile the program.