Location of DBSQLPR "Create Table" entities.

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

When using SQL commands to create tables and not specifying a particular database ID, where are the tables stored?

Environment

Datacom/DB

 

Resolution

If you are using the default MUF Startup Options, you should have an option called SQLDEFAULT that looks like this:

SQLDEFAULT 016,CASQLDEFAULT 

This indicates that the default DBID is 16 when you use just the simple CREATE TABLE statement, and that the tables will be created in the area called CASQLDEFAULT. Therefore, you should be able to run a CXX report against DB 16 and area CASQLDEFAULT should show the tables you have created.

Additional Information

For more information about the default MUF Startup Option, please see the Core documentation for the topic "Modify MUF Startup Options and Console Commands" and the SQLDEFAULT option.

As always, please contact Broadcom support for Datacom if you have further questions.