SET CONNECTION
SET CONNECTION
SET CONNECTION - select a database connection
Synopsis
SET CONNECTION [ TO | = ] connection_name
Description
SET CONNECTION
sets the
"
current
"
database connection, which is the one that all commands use
unless overridden.
Parameters
-
connection_name -
A database connection name established by the
CONNECTcommand. -
CURRENT -
Set the connection to the current connection (thus, nothing happens).
Examples
EXEC SQL SET CONNECTION TO con2; EXEC SQL SET CONNECTION = con1;
Compatibility
SET CONNECTION
is specified in the SQL standard.