Note the distinction between knowledge base (KB) and SQL database. A KB is fully contained in one SQL database, while on the other hand, an SQL database can contain more than one KB (although there is normally no particular reason to have such a configuration).

NAMING CONVENTION

The naming convention for SQL-based KBs is   [Path]<SqlDatabase>.<KbName.sql  . The optional path has nothing to do with the location of the SQL database, but rather indicates the default directory for the KB's configuration file and knowledge source files (if any).

EXPORTING A 3KB-TYPE KNOWLEDGE BASE TO SQL

You can create a new SQL-type knowledge base by exporting an existing 3KB-type knowledge base (Export to SQL in the Knowledge Base-menu). Pro/3 will create the SQL database if so specified (if not the database must exist or a run-time error will occur - Pro/3 does not check the existence of an SQL database).

In case of multi-DB configurations you will have to export all the participating databases. 

OPENING AN EXISTING SQL-TYPE KNOWLEDGE BASE

Simply enter the name of the knowledge base (e.g. yyy.xxx.sql) in the KB Open Dialog. A run-time error will occur if the database doesn't exist - Pro/3 does not check the existence of an SQL database.

INITIALIZING A NEW SQL-TYPE KNOWLEDGE BASE

Simply specify the name of the new knowledge base (e.g. yyy.xxx.sql) in the KB Open Dialog. The knowledge base xxx must not exist in the SQL database (the knowledge base will simply be opened if it exists already).

See SQL-type KB internal structure for more information.