View previous topic :: View next topic
|
Author |
Message |
mahesh.ajagtap
New User
Joined: 30 Sep 2006 Posts: 6
|
|
|
|
hi...
when i fire a db2 query it gives sqlcode -950
how can i solve it |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
I suppose you looked up this error?
Quote: |
DSNT408I SQLCODE = -950, ERROR: THE LOCATION NAME SPECIFIED IN THE CONNECT STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE ". |
|
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
A little more explaination:
Quote: |
-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 executed. 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. |
|
|
Back to top |
|
|
|