Before you issue a CLPPlus command, you must first start a CLPPlus session and establish
a connection to the database.
Procedure
To start a CLPPlus session and establish a connection to the
database:
-
Issue the CLPPLUS command in the
command line processor (CLP) or the
Db2® Command
Window: When prompted, enter your password.
For example, issue the following CLPPlus command to start the CLPPlus session and use the
user ID
db2admin to connect to a local SAMPLE database that is listening on port
50000:
clpplus db2admin@localhost:50000/sample
-
On Windows operating system, you can use the menu
option:
-
Click .
-
Specify your user ID and connection information.
The menu option is not available for the following IBM® data server client installations:
- IBM Data Server
Client
- IBM Data Server Runtime
Client
-
IBM Data Server Driver Package
-
On Linux® operating system, you can use the menu
option:
-
Click .
-
Specify your user ID and connection information.
The menu option is not available for the following IBM data server client installations:
- IBM Data Server
Client
- IBM Data Server Runtime
Client
-
IBM Data Server Driver Package
Results
The CLPPlus prompt (SQL>
) is available,
and you are connected to the specified database.
What to do next
You can now use CLPPlus commands and related features. Specify the commands at the CLPPlus
prompt.
To end the CLPPLus session, issue the EXIT or QUIT CLPPlus
command.