Start of change

-4731   THE NATIVE SQL ROUTINE STATEMENT FOR PACKAGE location-name.collection-id.program-name.consistency-token STATEMENT NUMBER statement-number CANNOT BE PROCESSED.

Explanation

The SQL routine for the statement must be running at the location where the statement is requested. Either no SQL routine is running at the indicated location, or the SQL routine that is running is not the SQL routine for the indicated package.

location-name
The name of the server where the statement cannot be processed.
collection-id
The name of the collection of the package that contains the statement that cannot be processed.
program-name
The name of the package that contains the statement that cannot be processed.
consistency-token
The consistency token of the package that contains the statement that cannot be processed.
statement-number
The package statement number of the statement that cannot be processed.

System action

The statement cannot be processed.

System programmer response

Take either of the following corrective actions:

  • Use a BIND PACKAGE COPY command instead of the BIND PACKAGE DEPLOY command to bind the package at that location.
  • Change the application logic to run the routine at that location where the statement executes.

SQLSTATE

560C5

End of change