Specifying the location of the package that Db2 is to use

When your program executes SQL statements, Db2 uses the value in the CURRENT SERVER special register to determine the location of the necessary package. If the current server is your local Db2 subsystem and it does not have a location name, the value in the special register is blank.

About this task

You can change the value of CURRENT SERVER by using the SQL CONNECT statement in your program. If you do not use CONNECT, the value of CURRENT SERVER is the location name of your local Db2 subsystem (or blank, if your Db2 subsystem has no location name).