-950   THE LOCATION NAME SPECIFIED IN THE CONNECT STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE

Explanation

One of the following conditions applies:
  • The location name is blank.
  • The data type of the host variable is not character string.
  • The length attribute of the host variable is greater than 16.
  • The location name does not appear in the LOCATIONS column of the SYSIBM.LOCATIONS table, nor is it the name of the local DB2® subsystem.

System action

The statement cannot be processed. The application process is placed in the unconnected state.

Programmer response

If the location name is specified as the value of a host variable, ensure that the name is left justified in the host variable and, if necessary, padded on the right with blanks. If this is not the problem, either SYSIBM.LOCATIONS must be updated to include the specified name, or the specified name must be changed to match a name in SYSIBM.LOCATIONS.

SQLSTATE

42705