SET_CURRENT_SQL_SERVER_CONNECTION¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to specify which server to use for embedded SQL statements. By default, the last logged in server will be used. Note that in addition to setting the server, this command also sets the driver to be used. This command is only needed when connecting to multiple servers. To set the server for opening tables, use SET_CURRENT_SQL_SERVER.

Syntax

SET_CURRENT_SQL_SERVER_CONNECTION of {constant} to {server}

Parameter

Description

constant

MYSQLFLEX, ORAFLEX, PGFLEX, or SQLFLEX

server

Name of the server

Example

SET_CURRENT_SQL_SERVER_CONNECTION of SQLFLEX to "(localdb)\v11.0"