logo  
Google
 

DB2 SQL-Error: -512

SQLState: 56023

Short Description: STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID

One of the following conditions exists: v The statement refers to multiple locations. v A statement with a remote reference is being EXPLAINED either by a dynamic EXPLAIN statement or the EXPLAIN(YES) option. v An alias is used incorrectly. v A three-part name is implicitly or explicitly used in a statement that is not supported by the DB2 private protocols. v A three-part name is implicitly or explicitly used in a triggered statement. v A PREPARE statement contains an ATTRIBUTES clause. This is not supported by the DB2 private protocols.System action: The statement cannot be executed. Programmer response: If the object cannot be meaningfully eliminated from the statement, see your Database Administrator for other ways to obtain the data required. Refer to Chapter 3 of DB2 SQL Reference for more information about using remote objects. If the remote object reference is in a triggered SQL statement, you can instead invoke a user-defined function or a stored procedure from the trigger and access the remote object from the function or stored procedure.

 <-  BACK TO INDEX