*SQLSCHEMADB (SETMODE)

PLBCMP Only, 9.5

*SQLSCHEMADB={dbname}

The *SQLSCHEMADB list control defines the name of a database connection from the Sun_Sqlio_Databases system table that is the default connection for obtaining schema information from the Sunbelt system tables.

{dbname} is a valid database name.

Note:

1. The {dbname} parameter is processed to determine the appropriate connection information that is required to make a connection to a database engine that contains the schema settings used for SQLIO.

2. The {dbname} parameter can be specified as 'Default' to reset to the runtime default database as initially loaded using the runtime INI file settings. Also, the {dbname} parameter can be a user defined database name that has been configured in the current runtime database. If a user defined Database name is specified, this database name must exist in the current runtime database table named 'Sun_Sqlio_Database'.

 

Example using runtime Default:

 

    SETMODE *SQLSCHEMADB="Default"

 

Example using user defined Database Connection name:

 

    SETMODE *SQLSCHEMADB="MySqlioSchema"

 

3. The {dbname} parameter can be specified as a connection string that includes all of the information required to make a direct connection to a database engine that has the SQLIO schema configuration data. In this case, the {dbname} parameter string can be specified using keywords with assigned string data that can optionally include single or double quote characters.

 

Format of SETMODE *SQLSCHEMADB={dbname} connection string:

 

      Name=<string>

      Host=<string>

      User=<string>

      Pass=<string>

      Conn=<string>

      Ext=<string>

      Flags=<dnum>

      Driver=<dnum>

      SqlType=<dnum>

 

The description of the *SQLSCHEMADB={dbname} SQLIO connection string keywords can be found in the PL/B Language Reference manual under the section named SQLIO Schema File Format in the <Database> Schema Record' descriptions.

 

Example:

 

DbEntryX INIT "Name=SqlDevSpot,":

                 "Host='DBADO;;DSN=SqlIoDev',":

                 "Driver=2,":

                 "SqlType=2"

.

         SETMODE *SQLSCHEMADB=DbEntryX

 

4. When a SETMODE *SQLSCHEAMADB instruction is executed with a user defined {dbname}, a reference to the connection data is created and exists until the runtime is terminated. In addition, if a second instruction references this {dbname} parameter database name, the original connection information is used.

See Also: List Controls (SETMODE), SETMODE